ODBC problems between webcat and filemaker pro
This WebDNA talk-list message is from 2001
It keeps the original formatting.
numero = 38053
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?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.Also, before someone suggests I take an entirely different approach, please keep in mind that I _must_ pull information from an existing filemaker database. That part is non-negotiable, so changing database platforms is not an option. The client company also only has the macintosh version of Webcatalog. I would really rather avoid having to export the information first, but I'll use that as a last resort...Thanks,Marc Frechet------------------------------------------------------------- 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?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.Also, before someone suggests I take an entirely different approach, please keep in mind that I _must_ pull information from an existing filemaker database. That part is non-negotiable, so changing database platforms is not an option. The client company also only has the macintosh version of Webcatalog. I would really rather avoid having to export the information first, but I'll use that as a last resort...Thanks,Marc Frechet------------------------------------------------------------- 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:
Email Formatting (1998)
[WebDNA] maybe silly suggestion? [founditems] (2015)
World Address Info (2003)
WebCat & Backoffice Solution? (2000)
search form problem.. (1997)
MacWEEK article help needed (1996)
Simple way to create unique SKU (1997)
Changing names of .hdr field names (2003)
PCS Frames (1997)
Time for a hard questions. (1997)
PIXO support (1997)
Database Options (1997)
Exclamation point (1997)
Shipping [grandtotal] solution (1997)
[format xs] freeze (1997)
Mac 2.1b2 speed (1997)
[WebDNA] [sendmail] inside search (2016)
[random] only for 1-100??? (1997)
[WriteFile] problems (1997)
[WebDNA] Need Rosetta to install on OS X? (2010)