Re: ODBC problems between webcat and filemaker pro
This WebDNA talk-list message is from 2001
It keeps the original formatting.
numero = 38059
interpreted = N
texte = Based on your SQL statement I tried another test, and got the same results as before. Here's the SQL statement I tried:[sql dsn=CCscript&statement=SELECT marctest.name, marctest.address FROM `marctest.fp5`] [founditems][name][/founditems] [/sql]And here's the error I get, once again:SQL Error: S1106 [FileMaker][ODBC FileMaker Pro driver]In SQLExtendedFetch, only SQL_FETCH_NEXT is supported for SQL_SCROLL_FORWARD_ONLY cursors.I'm also using the filemaker ODBC driver from the Filemaker 5 distribution, and the ODBC control panel shipped with system 9.1. Any ideas?Marc Frechet Sam Lewis wrote: > > >I somehow got thrust into a situation where I need to have webcatalog > >pull information out of a Filemaker Pro database. The Filemaker > >database is running on a Mac, Webcatalog also on a Mac, but different > >machines. This initially didn't seem like it would be a problem, since > >Filemaker Pro is ODBC compatible. Well, as it turns out, I've only > >found one ODBC driver for Filemaker that actually seems to work at all, > >and Webcatalog doesn't seem to be able to communicate with that driver. > >My question is, has anyone else out there successfully connected the > >two? And if so, how? > > I use it every day. I'm dumping UPS tracking numbers into a FM > database and then pulling that info out with WebCat. I also push data > into FM to be pulled into UPS via ODBC. > > >The specific problem that I have is that when I use an SQL context in > >Webcatalog that tries to run any sort of search (SELECT statement), my > >filemaker pro driver returns this error message: [FileMaker][ODBC > >FileMaker Pro driver]In SQLExtendedFetch, only SQL_FETCH_NEXT is > >supported for SQL_SCROLL_FORWARD_ONLY cursors. I have not been able > >to get Webcatalog to get the search to use a different fetch direction, > >and it's seeming like it's just not possible due to how the SQL tag > >works. > > [sql dsn=FilemakerDSN&password=abcd&statement=SELECT > TrackNumbers.track, TrackNumbers.ref1, TrackNumbers.ref2, > TrackNumbers.cost, TrackNumbers.track2, TrackNumbers.void, > TrackNumbers.modDate, TrackNumbers.modTime > FROM `TrackNumbers.fm` TrackNumbers > ORDER BY TrackNumbers.modDate, TrackNumbers.modTime] > [founditems][track][/founditems][/sql] > > This sql works just fine. > > I'm using the ODBC manager from the Office 98 distribution and the FM > odbc driver from the Filemaker 4/5 distribution. > > Show us your Sql statement and maybe we can find something in there. > > -- > > Sam Lewis > > SamLewis.com > Tel: 626-852-0956 Fax: 916-404-5698 > > ------------------------------------------------------------- > 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:
Based on your SQL statement I tried another test, and got the same results as before. Here's the SQL statement I tried:[sql dsn=CCscript&statement=SELECT marctest.name, marctest.address FROM `marctest.fp5`] [founditems][name][/founditems] [/sql]And here's the error I get, once again:SQL Error: S1106 [FileMaker][ODBC FileMaker Pro driver]In SQLExtendedFetch, only SQL_FETCH_NEXT is supported for SQL_SCROLL_FORWARD_ONLY cursors.I'm also using the filemaker ODBC driver from the Filemaker 5 distribution, and the ODBC control panel shipped with system 9.1. Any ideas?Marc Frechet Sam Lewis wrote: > > >I somehow got thrust into a situation where I need to have webcatalog > >pull information out of a Filemaker Pro database. The Filemaker > >database is running on a Mac, Webcatalog also on a Mac, but different > >machines. This initially didn't seem like it would be a problem, since > >Filemaker Pro is ODBC compatible. Well, as it turns out, I've only > >found one ODBC driver for Filemaker that actually seems to work at all, > >and Webcatalog doesn't seem to be able to communicate with that driver. > >My question is, has anyone else out there successfully connected the > >two? And if so, how? > > I use it every day. I'm dumping UPS tracking numbers into a FM > database and then pulling that info out with WebCat. I also push data > into FM to be pulled into UPS via ODBC. > > >The specific problem that I have is that when I use an SQL context in > >Webcatalog that tries to run any sort of search (SELECT statement), my > >filemaker pro driver returns this error message: [FileMaker][ODBC > >FileMaker Pro driver]In SQLExtendedFetch, only SQL_FETCH_NEXT is > >supported for SQL_SCROLL_FORWARD_ONLY cursors. I have not been able > >to get Webcatalog to get the search to use a different fetch direction, > >and it's seeming like it's just not possible due to how the SQL tag > >works. > > [sql dsn=FilemakerDSN&password=abcd&statement=SELECT > TrackNumbers.track, TrackNumbers.ref1, TrackNumbers.ref2, > TrackNumbers.cost, TrackNumbers.track2, TrackNumbers.void, > TrackNumbers.modDate, TrackNumbers.modTime > FROM `TrackNumbers.fm` TrackNumbers > ORDER BY TrackNumbers.modDate, TrackNumbers.modTime] > [founditems][track][/founditems][/sql] > > This sql works just fine. > > I'm using the ODBC manager from the Office 98 distribution and the FM > ODBC driver from the Filemaker 4/5 distribution. > > Show us your Sql statement and maybe we can find something in there. > > -- > > Sam Lewis > > SamLewis.com > Tel: 626-852-0956 Fax: 916-404-5698 > > ------------------------------------------------------------- > 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:
Help! WebCat2 bug (1997)
WebDNA on OS X Tiger (2006)
Summing fields (1997)
include bug????? (1997)
Mac Vs WindowsNT (1997)
WebCat2 several catalogs? (1997)
Was 5.0 Pricing, now Sandbox versus Website and ruminating (2003)
ConvertChars request (1999)
Webcat Installation Problem? (2000)
WebCat2 - many [carts] on one template page? (1997)
Building Calendars (1997)
Memory Error message (1998)
OT: IP addres checking (2003)
[WebDNA] fastcgi 7+ & [cart]? (2010)
WebCatalog [FoundItems] Problem - AGAIN - (1997)
Search/sort in URL Was: GuestBook example (1997)
Fileinfo... (2000)
Searching using numbers (1998)
[showif]/[hideif] question (1997)
Running webcat 6 on Windows XP Prof. (2005)