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:
UNC path support in WebDNA 5.0 (2003)
Transfering [text] variables (2000)
PIXO support (1997)
Lots of bounce errors (2007)
UPS Shipping (1999)
For those of you not on the WebCatalog Beta... (1997)
attn: smitmicro - cart limitation (2002)
buy 2 items get this free (2003)
WebDNA and SQL (2003)
More on the email templates (1997)
[carts] and databases (1997)
WebCat2b15MacPlugin - showing [math] (1997)
Help! WebCat2 bug (1997)
[WebDNA] OAuth - anybody done this yet? (2009)
Login Page & [Protect] (2001)
[WebDNA] anyone set up webdna 7 on Amazon's cloud? (2012)
Unceremonious Unwanted Unsubscription (1999)
syntax question, not in online refernce (1997)
off topic - dna snipets (1997)
Virtual hosting and webcatNT (1997)