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:
Emailer update for Mac? (1998)
Running _every_ page through WebCat ? (1997)
Bug Report, maybe (1997)
I assume it is a safe bet this does not help (1998)
Some Questions (1997)
Grep Master Needed (2003)
creator code (1997)
E-mailer error codes (1997)
WebCatalog host... (2000)
sort problems....bug or brain fart? (1997)
Problems with dbcatalog.exe (1997)
Multi-processor Mac info ... (1997)
HELP - NONE STOP DIGESTS. Digest for 4/24/97) (1997)
Math, Multiple Equasions and Show/Hide (1998)
SSL and Webstar 3 with Webcatalog (1998)
no time stamp & different times from emailer (1998)
method of payment (1997)
hideif/showif causes error if wrapped around searches (2003)
Nested tags count question (1997)
error: Too many nested [xxx] contexts (1997)