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:

Email check problems -1 (1999) strange problem listfiles and movefile (long) (2000) Cool! formulas (1998) Field name-subcategory (1997) Unable to view next 101-200 (1997) Group search doesn't work. (1997) Frames and WebCat (1997) WebMerchant - WorldPay (2004) PCS Frames (1997) webcat plugin issue (2001) Bug or syntax error on my part? (1997) [convertChars] and HTML Tags (1997) [Shell script] question. (2004) 2.0Beta Command Ref (can't find this instruction) (1997) Getting total number of items ordered (1997) Card clearance, problems - solutions? (1997) WC2b15 - [HTMLx]...[/HTMLx] problems (1997) 4.0 image uploading /features (2000) [OT] SMTP Server for W2000 (2002) Fwd: virtual domain and [listfile] paths and aliases (1998)