Re: ODBC problems between webcatalog and filemaker pro
This WebDNA talk-list message is from 2001
It keeps the original formatting.
numero = 38173
interpreted = N
texte = 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/webcatalogYou 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/
Associated Messages, from the most recent to the oldest:
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/webcatalogYou 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/
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:
Newbie Tax Question (1997)
problems with WebCat-Plugin ()
More than one db with the same namn (was: WC2f3) (1997)
Hiding URL ? (1998)
move files (2000)
search comparison (2003)
syntax question, not in online refernce (1997)
Cleaning up all the shopping carts (2000)
Netscape v. IE (1997)
RE: URL too Long? (1997)
[feature req?]DeleteFounditem (2002)
WebCatalog/Mac 2.1b2 - PIXO (1997)
multi-table date sort problem thingy (2002)
[ShowIf] and empty fields (1997)
Format Thousands Looks Busted (2000)
many-to-one problem (1998)
2.1 pricing? (1998)
Web Delivery Page concept (1997)
Not really WebCat (1997)
[WebDNA] El Capitan (2017)