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:
Configuring E-mail (1997)
F3 crashing server (1997)
Type 11 errors setting up WebCAt 2 (1997)
post (2000)
Re:Help name our technology! (1997)
Feature req. (2002)
about this server and links to who (1997)
Proper file locations (1997)
Nested tags count question (1997)
SAVECART (1997)
Line Breaks (2003)
HTML Editors (1997)
html delivery (1997)
[shownext max=?] armed (1997)
Need example sites for seminar; will plug you too (1998)
Secure server question (1997)
Checking for blank form fields (sort of...) (1998)
SiteEdit NewFile.html ? (1997)
re: [addlineitem] working almost (1997)
[WebDNA] SMS Gateway (2013)