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.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 LewisSamLewis.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/
Associated Messages, from the most recent to the oldest:
>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 LewisSamLewis.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/
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:
is sku a REQUIRED field on NT (1997)
[format xs] freeze (1997)
update problem (1998)
(no subject) (1997)
A quickie question (1997)
Re:Email Problem (1997)
Problems with ^ could be solved with [REPLACE CHARACTERS] (1997)
Setting up WebCatalog with Retail Pro data (1996)
Formating found categories (1997)
[WebDNA] v7 problem? (2012)
RE: strip .0 off off IPaddress (1999)
formulas.db problem solved (1998)
WebCat2 Append problem (B14Macacgi) (1997)
pop up menu's (1998)
Web Catalog 2 demo (1997)
Date Time Oddness (1999)
For those of you not on the WebCatalog Beta... (1997)
[WebDNA] Best practice re: password storage (2013)
FW: Virus Alert: FBI Finds 911 Virus Wiping Out Hard DrivesToday (2000)
using showpage and showcart commands (1996)