Re: ODBC problems between webcat and filemaker pro
This WebDNA talk-list message is from 2001
It keeps the original formatting.
numero = 38060
interpreted = N
texte = By the way, I also tried several variations, such as:[sql dsn=CCscript&password=&statement=SELECT marctest.name, marctest.addressFROM `marctest.fp5` marctest][founditems][name][/founditems][/sql]...and, renaming the database simply marctest,[sql dsn=CCscript&password=&statement=SELECT marctest.name, marctest.addressFROM `marctest`][founditems][name][/founditems][/sql]Both had the same results.Marc FrechetSam Lewis wrote:> > >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 Lewis> > SamLewis.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/---------------------------------------------------------------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:
By the way, I also tried several variations, such as:[sql dsn=CCscript&password=&statement=SELECT marctest.name, marctest.addressFROM `marctest.fp5` marctest][founditems][name][/founditems][/sql]...and, renaming the database simply marctest,[sql dsn=CCscript&password=&statement=SELECT marctest.name, marctest.addressFROM `marctest`][founditems][name][/founditems][/sql]Both had the same results.Marc FrechetSam Lewis wrote:> > >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 Lewis> > SamLewis.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/---------------------------------------------------------------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:
A quickie question (1997)
Tab Charactor (1997)
exclamation mark... (1999)
Download URL & access on the fly ? (1997)
Help! WebCat2 bug (1997)
Upgrading old WebCat Database Files (1997)
writefile and texte (1997)
Banners and sort of random display (1997)
Troubles with Selection Drop Down List Search (1998)
Sample Tearoom Search Error (1997)
Mac List Servers (was: Duplicate Hell) (1999)
Grant, please help me ... (1997)
[WebDNA] last month's last day expressed as days since 00/00/0000 would be what? (in code) (2008)
Webcatalog, Webstar and Crasharama (1999)
NT [delete] - duh nevermind. (1998)
Search in 2 or more catalogs (1997)
One more time (1997)
# fields limited? (1997)
Erotic Sites (1997)
Modifying order output (1997)