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:
Date search - yes or no (1997)
Expert tech support -- a fast and simple solution (long) ... (2000)
Extra equals signs with IE? (More debugging questions...) (1997)
Multiple SSL Keys (1998)
Referrer from multiple entry points (1998)
Happy Easter ... and grep string request ... (2004)
Sorry I didn't pay attention-but ??? (1997)
[WebDNA] Connect to MS SQL (2013)
Making a secret cookie code in WebCat (2001)
Add message to Order (1997)
RE: WebCat cannot handle compatible search parameters? (1997)
Denying access by IP address (2000)
Was it something I said??? (1998)
Summarising on two fields (1998)
[group] ? (1997)
WebCat2.0 acgi vs plugin (1997)
ooops...WebCatalog [FoundItems] Problem - LONG - (1997)
problems with 2 tags (1997)
Nesting FoundItem Context (1997)
WedDNA Codeless Language Module file (2004)