Re: WEBCAT with SQL backend. Help please!
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 28066
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:
sort links (2002)
[WebDNA] unix timestamp in WebDNA (2009)
[SearchString] problem with [search] context (1997)
Frames and WebCat (1997)
Dealer Locator (2008)
PCS Frames (1997)
Restarting Crippled Webcatalog (2003)
[lookup] is case-sensitive, [lookup] is case sensitive... (2003)
Overriding text variables ... (2000)
WC Database Format (1997)
[protect] and identification (2008)
Cancel Subscription (1996)
Getting Values into Cart the easy way?* (1998)
Resume Catalog ? (1997)
More than one db with the same namn (was: WC2f3) (1997)
switching users (1998)
HELP WITH DATES (1997)
sorted cart? (1998)
File Upload (1997)
Running _every_ page through WebCat ? (1997)