Re: ODBC problems between webcat and filemaker pro

This WebDNA talk-list message is from

2001

It keeps the original formatting. numero = 38057
interpreted = N
texte = >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.modTimeFROM `TrackNumbers.fm` TrackNumbersORDER 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 LewisSamLewis.comTel: 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/ Associated Messages, from the most recent to the oldest:

Re: ODBC problems between webcat and filemaker pro (Sam Lewis 2001) Re: ODBC problems between webcat and filemaker pro (Marc Frechet 2001) Re: ODBC problems between webcat and filemaker pro (Marc Frechet 2001) Re: ODBC problems between webcat and filemaker pro (Sam Lewis 2001) Re: ODBC problems between webcat and filemaker pro (Nitai @ ComputerOil 2001) ODBC problems between webcat and filemaker pro (Marc Frechet 2001)

>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.modTimeFROM `TrackNumbers.fm` TrackNumbersORDER 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 LewisSamLewis.comTel: 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/ Sam Lewis

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:

Adding up weights (1998) Separate SSL Server (1997) Help name our technology! (1997) Location of Webcat site in folder hierarchy (1997) WebMerchant 1.6 and SHTML (1997) Multiple catalog databases and showcart (1997) Summary search -- speed (1997) RE: [WebDNA] Sorting -- Dealing with Blanks (2008) How to remove comments with grep? (2003) [WebDNA] sem_open solved (2012) Bug or syntax error on my part? (1997) Error handling for accountNum (1997) Math variable size-dumb question (1999) Mailer (2006) Wanted: More Math Functions (or, Can You Solve This?) (1997) IASPI_Rewrite & WebDNA (2007) Requiring that certain fields be completed (1997) WebCat2b13MacPlugIn - [include] doesn't allow creator (1997) Using EIMS instead of Emailer (1998) Freeze (2003)