ODBC problems between webcatalog and filemaker pro
This WebDNA talk-list message is from 2001
It keeps the original formatting.
numero = 38166
interpreted = N
texte = I posted this problem here several days ago, but I have enough different information that I wanted to start over. This is a little bit off topic now, but I would really appreciate it if anyone who has seen this problem before could comment.I am having trouble connecting Webcatalog to Filemaker via ODBC on a Macintosh. This means that Webcatalog is running on a Mac, and that is a pivotal point of my problem. I can get it to work perfectly well under NT and Linux, but I need a Mac specific solution (to avoid buying another copy of webcatalog).I am running this script:[sql dsn=testdsn&statement=SELECT name FROM test] [founditems] [name] [/founditems] [/sql]And getting this error in response:SQL Error: S1106 [FileMaker][ODBC FileMaker Pro driver]In SQLExtendedFetch, only SQL_FETCH_NEXT is supported for SQL_SCROLL_FORWARD_ONLY cursors. I know for a fact that there is nothing wrong with the SQL query or the Filemaker database setup, because an NT machine running this same script and connecting to the same database works. This suggests two possibilities for where the problem is: the ODBC driver, or the driver manager. I am using the ODBC 3.11 Filemaker Pro PPC driver and the ODBC driver manager that ship with the Mac version of Filemaker Developer 5. I have gone through the documentation for them thouroughly, and I do not believe I have done anything wrong in terms of setup. I have also tried the OpenLink drivers, with the same results. Has anyone seen this before, or can anyone suggest different drivers/manager that might work?Again, I apologize for the off topic question, but I'm a little lost when it comes to Mac software. Thanks in advance.Marc Frechet------------------------------------------------------------- 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:
I posted this problem here several days ago, but I have enough different information that I wanted to start over. This is a little bit off topic now, but I would really appreciate it if anyone who has seen this problem before could comment.I am having trouble connecting Webcatalog to Filemaker via ODBC on a Macintosh. This means that Webcatalog is running on a Mac, and that is a pivotal point of my problem. I can get it to work perfectly well under NT and Linux, but I need a Mac specific solution (to avoid buying another copy of webcatalog).I am running this script:[sql dsn=testdsn&statement=SELECT name FROM test] [founditems] [name] [/founditems] [/sql]And getting this error in response:SQL Error: S1106 [FileMaker][ODBC FileMaker Pro driver]In SQLExtendedFetch, only SQL_FETCH_NEXT is supported for SQL_SCROLL_FORWARD_ONLY cursors. I know for a fact that there is nothing wrong with the SQL query or the Filemaker database setup, because an NT machine running this same script and connecting to the same database works. This suggests two possibilities for where the problem is: the ODBC driver, or the driver manager. I am using the ODBC 3.11 Filemaker Pro PPC driver and the ODBC driver manager that ship with the Mac version of Filemaker Developer 5. I have gone through the documentation for them thouroughly, and I do not believe I have done anything wrong in terms of setup. I have also tried the OpenLink drivers, with the same results. Has anyone seen this before, or can anyone suggest different drivers/manager that might work?Again, I apologize for the off topic question, but I'm a little lost when it comes to Mac software. Thanks in advance.Marc Frechet------------------------------------------------------------- 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/
Marc Frechet
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:
[OT] MacWorld Expo (2004)
[OT] Domain Name Scam (2000)
Possible Bug in 2.0b15.acgi (1997)
WebCat2b13MacPlugIn - [shownext method=post] ??? (1997)
ExpireDate Zero or Greater than Today (2006)
Question about replacing words (1998)
Tool of Use to Unix WebCat Admins (2000)
A multi-processor savvy WebCatalog? (1997)
Location of Webcat site in folder hierarchy (1997)
Hyperboard/bulletin board available (1998)
Links and Carriage Returns, Oh my! (2000)
IE-caching (1998)
Duplicate Cart ID (2001)
IE, Layers, and Select (2002)
[WebDNA] WebDNA staging server (2008)
[shownext max=?] armed (1997)
WebMerch/Emailer Error (1998)
Re:2nd WebCatalog2 Feature Request (1996)
Alternating colors (1997)
Country & Ship-to address & other fields ? (1997)