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_nameThe 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.ThanksHelene-------------------------------------------------------------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_nameThe 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.ThanksHelene-------------------------------------------------------------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:
emailer (1997)
WebCatalog dying in NT (1998)
Help! WebCat2 bug (1997)
Bug - 4.5 (2002)
[WebDNA] WebDNA [sendmail] - fixes and future features (2010)
Searchable WebCat (etc.) Docs ? (1997)
Problem displaying search result (1997)
Multiple prices (1997)
Error Lob.db records error message not name (1997)
RE: ShowNext Command (1997)
suggestion (1997)
WebCat2 several catalogs? (1997)
Navigator 4.0 & tables (1997)
WebCat name recognition (was MacFinder -- a new WebDNAweb site) (1998)
More DateMath problems (1997)
no [include]s with encryption? (1998)
RequiredFields template (1997)
[format] problem (2001)
multi-paragraph fields (1997)
New Plug-in and Type 11 errors (1997)