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:
[NT] ie 4.0 required (1997)
Nesting format tags (1997)
Multi-processor Mac info ... (1997)
[SearchString] problem with [search] context (1997)
Error: Can't open order file. Ignoring [OrderFile] context (2000)
WC2b12: Yes, Formulas.db is for real (1997)
Search Combining Problem (2004)
Almost a there but..bye bye NetCloak (1997)
Variable prices and Formulas.db (1997)
Read and Write (2001)
Setting up WebCatalog with Retail Pro data (1996)
Mac: LModelDirector bug fix (1997)
Setting up shop (1997)
[REPLACE] inside [FOUNDITEMS] (1998)
Variable in a variable (2002)
WebCat2 - many [carts] on one template page? (1997)
ReplaceFoundItems (2006)
multiple search commands (1997)
Searching multiple fields from one form field (1997)
A multi-processor savvy WebCatalog? (1997)