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:
Cart passing in URL... (2004)
WebCatalog for guestbook ? (1997)
SetHeader not Working (2006)
I've been framed by webcatalog! Does anyone know the way out? (2000)
Updating Prices in DB (working) (1999)
problems with 2 tags (1997)
[SHOWIF AND/OR] (1997)
Weird Problem (1997)
search form problem.. (1997)
Logging purchases (1997)
Exclude by date - multiple (1997)
[WebDNA] Problem running Webdna (2011)
OT: Windows-based Code Editor (2002)
quantity minimum problem (1997)
WebCat2 Append problem (B14Macacgi) (1997)
Stumpted Again (1997)
WebCat2_Mac RETURNs in .db (1997)
Calculating multiple shipping... (1997)
Sami (1998)
America Online Issues (1998)