Re: ODBC problems between webcat and filemaker pro
This WebDNA talk-list message is from 2001
It keeps the original formatting.
numero = 38063
interpreted = N
texte = >Based on your SQL statement I tried another test, and got the same >results as before. Here's the SQL statement I tried: > >[sql dsn=CCscript&statement=SELECT >marctest.name, marctest.address >FROM `marctest.fp5`] >[founditems][name][/founditems] >[/sql] > >And here's the error I get, once again: > >SQL Error: S1106 >[FileMaker][ODBC FileMaker Pro driver]In SQLExtendedFetch, only >SQL_FETCH_NEXT is supported for SQL_SCROLL_FORWARD_ONLY cursors. Marc,Let's step back a minute. Have you tested the ODBC connection from outside of WebCatalog? Make sure you do this to verify that your DSNs and FM database are setup properly. I use Microsoft Query to test with. -- Sam LewisSamLewis.com Tel: 626-852-0956 Fax: 916-404-5698------------------------------------------------------------- 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 Web Archive of this list is at: http://search.smithmicro.com/
Associated Messages, from the most recent to the oldest:
>Based on your SQL statement I tried another test, and got the same >results as before. Here's the SQL statement I tried: > >[sql dsn=CCscript&statement=SELECT >marctest.name, marctest.address >FROM `marctest.fp5`] >[founditems][name][/founditems] >[/sql] > >And here's the error I get, once again: > >SQL Error: S1106 >[FileMaker][ODBC FileMaker Pro driver]In SQLExtendedFetch, only >SQL_FETCH_NEXT is supported for SQL_SCROLL_FORWARD_ONLY cursors. Marc,Let's step back a minute. Have you tested the ODBC connection from outside of WebCatalog? Make sure you do this to verify that your DSNs and FM database are setup properly. I use Microsoft Query to test with. -- Sam LewisSamLewis.com Tel: 626-852-0956 Fax: 916-404-5698------------------------------------------------------------- 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 Web Archive of this list is at: http://search.smithmicro.com/
Sam Lewis
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:
YACBQ.....(Yet another checkbox question) (2000)
If Empty ? (1997)
how to do multiple prices/item? (1998)
[WriteFile] problems (1997)
WebCat2 several catalogs? (1997)
Location of Browser Info.txt file (1997)
OFF TOPIC: help wanted (1997)
addlineitem mystery (2003)
Replace context problem ... (1997)
taxRate is fine but taxTotal isn't (1997)
Any problems with Welcome & WebCat? (2000)
Reversed words (1997)
multiple prices (1998)
[lookup] speed sales pitch (2003)
[WebDNA] WebDNA is not parsing CSS file (2010)
oops private message leaked into talk list (1997)
ShowIf inside formulas (1997)
[WebDNA] Ubuntu 18.04 & Apache2 & WebDNA fcgi - File upload error (2019)
Prevent multiple appends with Reload Button (1997)
Users.db permissions (2002)