Re: ODBC problems between webcatalog and filemaker pro
This WebDNA talk-list message is from 2001
It keeps the original formatting.
numero = 38168
interpreted = N
texte = WebCatalog version?> -----Original Message----- > From: WebCatalog Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On > Behalf Of Marc Frechet > Sent: Friday, August 24, 2001 2:21 PM > To: WebCatalog Talk > Subject: ODBC problems between webcatalog and filemaker pro > > > 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/------------------------------------------------------------- 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:
WebCatalog version?> -----Original Message----- > From: WebCatalog Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On > Behalf Of Marc Frechet > Sent: Friday, August 24, 2001 2:21 PM > To: WebCatalog Talk > Subject: ODBC problems between webcatalog and filemaker pro > > > 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/------------------------------------------------------------- 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/
Scott Anderson
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:
nslookup (2000)
[if] and [showif] (2002)
Problems passing [SKU] with $Replace in 2.0 (1997)
UPDATE PROBLEM (1997)
Help with Repost Data msg from form (1997)
RE: OK, here goes... (1997)
RE: WebCat name recognition (was MacFinder -- a new WebDNAweb (1998)
sort problems....bug or brain fart? (1997)
WebCatalog Upgrade Pricing? (1997)
WC Database Format (1997)
WebCat2 - Getting to the browser's username/password data (1997)
Writefile (2000)
Database of Tax Rates? (1997)
Secure Server (1997)
Protect (1997)
Custom Shipping Charges (1997)
Confirmation emails classified as junk (2000)
Purchased cart being overwritten - still !?? (1997)
Quickie question on the email templates (1997)
2nd WebCatalog2 Feature Request (1996)