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:
tricky embedded[showifs/hideifs] (w/ code.. long) (2000)
Possible Bug 4.51 (2004)
WebTen? (1997)
WebCatalog Beta Documentation (1997)
Personal Web Server (1998)
4.02 release 10/1 (2001)
Various Problems (1997)
WebCat2_Mac RETURNs in .db (1997)
Banners (1997)
[TaxTotal] (1998)
Deleting Orders (1997)
color and size options / ARCHIVES (1997)
Dates and Math - Simple Subtraction (2004)
[WebDNA] A new popuated field to a DB with 700.000 records (2009)
[WebDNA] [OT] iTools FTP question (2010)
Mac vs. Unix Line Endings (2002)
Emailer.Out (1998)
OT ImageMagick and Thumbnails (2003)
autosensing lanague selection (1997)
E-mail loop ! (1997)