Re: WEBCAT with SQL backend. Help please!
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 28065
interpreted = N
texte = > >I have installed the ODBC (MS package from Office 98) and succeeded >>to connect to FileMaker Pro 5. >>No way to do the same experience with Webcat. I can't figure out what >>I did wrong! >>Do you have a WEBCAT with SQL backend protocol that can help? >>And what about sql in version 4 exactly? What are the planned features. > >What exact version of WebCatalog? > >We do not control or create any of the ODBC or SQL software, so the >instructions need to come from other manufacturers. But I'll do my >best. When you tested this with Office 98, you must have created >some kind of DSN (Data Source Name) in your ODBC control panel that >knows how to communicate with FileMaker. Whatever that DSN name is >must be typed into the [SQL] context in your templates. The online >docs describing [SQL] give an example.That's what I exactly have done. - I have retrieved the Data with Excel - The Db name is Sales_Data and the Table is Liste. The data to retrieve is Company_name The simple code I used is:
TEST [SQL dsn=Sales_Data&statement=SELECT * from Liste] Found [NumFound] items
[FoundItems] [Company_name]
[/FoundItems] [/SQL] When I access to this page, webstar quits!I understand your business is not to solve all the ODBC questions. I think a protocol based on Office 98 and FileMaker Pro 5 would be very helpful for all of us.There are cases where loading the DB in memory is not desirable (Data too huge). I don't want to use another solution than Webcat in these cases. I just need to acess these datas in a sql db. If I can do it for FileMaker, I know I'll do it for any SQL DB. It will be just a question of how to parameter the ODBC driver.Thanks Helene------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to
.This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to
Associated Messages, from the most recent to the oldest:
> >I have installed the ODBC (MS package from Office 98) and succeeded >>to connect to FileMaker Pro 5. >>No way to do the same experience with Webcat. I can't figure out what >>I did wrong! >>Do you have a WEBCAT with SQL backend protocol that can help? >>And what about sql in version 4 exactly? What are the planned features. > >What exact version of WebCatalog? > >We do not control or create any of the ODBC or SQL software, so the >instructions need to come from other manufacturers. But I'll do my >best. When you tested this with Office 98, you must have created >some kind of DSN (Data Source Name) in your ODBC control panel that >knows how to communicate with FileMaker. Whatever that DSN name is >must be typed into the [SQL] context in your templates. The online >docs describing [SQL] give an example.That's what I exactly have done. - I have retrieved the Data with Excel - The Db name is Sales_Data and the Table is Liste. The data to retrieve is Company_name The simple code I used is: TEST [SQL dsn=Sales_Data&statement=SELECT * from Liste] Found [NumFound] items
[founditems] [Company_name]
[/FoundItems] [/SQL] When I access to this page, webstar quits!I understand your business is not to solve all the ODBC questions. I think a protocol based on Office 98 and FileMaker Pro 5 would be very helpful for all of us.There are cases where loading the DB in memory is not desirable (Data too huge). I don't want to use another solution than Webcat in these cases. I just need to acess these datas in a sql db. If I can do it for FileMaker, I know I'll do it for any SQL DB. It will be just a question of how to parameter the ODBC driver.Thanks Helene------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to .This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to
helene
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
re: emailer prob (1998)
Questions about maximum (1999)
Read and weep (2003)
Version 2.0 and 1.6 simultaneous (1997)
Sorting via date (2002)
RE: Formulas.db + Users.db (1997)
[append] and SSL (1997)
Problems adding stuff to the shopping cart. (1997)
Forcing a NEWCART (1997)
Word wrapping (1997)
File Uploads... (1997)
Quit revisited (1997)
[WebDNA] fastcgi 7+ & [cart]? (2010)
Shop from PDF (2004)
F2 to F3 rocky transition (1997)
No Line Breaks Appearing (2000)
[shell] (2002)
Next (1997)
Trouble with formula.db + more explanation (1997)
Need help with emailer- 2 issues (1997)