Re: ODBC problems between webcatalog and filemaker pro
This WebDNA talk-list message is from 2001
It keeps the original formatting.
numero = 38179
interpreted = N
texte = I downloaded and installed 402rc2, and it doesn't seem to have changed anything at all. I am still getting the same error.Marc Frechet Scott Anderson wrote: > > A while back, I think it was for one of the 401 beta builds, we did fix an > issue with SQL cursor types. You should download the latest WebCatalog 402 > release candidate (402rc2), and see if that solves the SQL problem you are > having. You can download the latest WebCatalog build here: > > ftp://ftp.isd.smithmicro.com/beta/webcatalog > > You can view the list of changes and bug fixes for each build here: > > http://betadoc.smithmicro.com/WebCatalog%20Change%20History.html > > >Webcatalog Version 4.0. > > >Marc Frechet > > Scott Anderson wrote: > > > > 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/ > > ------------------------------------------------------------- > 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:
I downloaded and installed 402rc2, and it doesn't seem to have changed anything at all. I am still getting the same error.Marc Frechet Scott Anderson wrote: > > A while back, I think it was for one of the 401 beta builds, we did fix an > issue with SQL cursor types. You should download the latest WebCatalog 402 > release candidate (402rc2), and see if that solves the SQL problem you are > having. You can download the latest WebCatalog build here: > > ftp://ftp.isd.smithmicro.com/beta/webcatalog > > You can view the list of changes and bug fixes for each build here: > > http://betadoc.smithmicro.com/WebCatalog%20Change%20History.html > > >Webcatalog Version 4.0. > > >Marc Frechet > > Scott Anderson wrote: > > > > 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/ > > ------------------------------------------------------------- > 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/
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:
Math (1997)
Latest beta slow on [order] and [purchase] (1997)
Error handling for accountNum (1997)
space at start of menu (2000)
Webcat causing crashes left and right! (1997)
frames & carts (1997)
[cart] clarification... (1997)
shipcost (1997)
Resume Catalog ? (1997)
Some shell fun (2004)
Emailer (WebCat2) (1997)
How do I get Google to crawl a WebCat site? (2003)
This list needs a digest: rant, rave... (1997)
HTML text cannot be copied to clipboard? (1999)
Server crash (1997)
[ELSEIF] was hideif [x]=1,2,3..: (2003)
SetHeader context (1998)
mod_webcatalog2.so.2-40 is garbled (2008)
How do I pass [cart] when user clicks back (2000)
Multiple fields on 1 input (1997)