ODBC Connection in an ASP Page

[teelliott]

I am working on a project for a client that uses FM Pro. I have downloaded the FM 5.5 30 day trial version.

I created a new table and called it LocationCodes with not extension. I opened the file in FM then selected View -> Preferences -> Plug-ins and selected Local Data Access Companions.

Then selected File -> Sharing and made sure Multi-user was checked.

I created a System/ODBC called WorldHotel using the FileMaker Pro driver.

Below is my asp code:

set conn = server.CreateObject("ADODB.Connection")

set rs = server.CreateObject("ADODB.RecordSet")

conn.Open "WorldHotel"

sql = "SELECT CityCode from LocationCodes"

set rs = conn.Execute(sql)

When I run this code I get the following error:

Microsoft OLE DB Provider for ODBC Drivers (0x80004005)

[FileMaker][ODBC FileMaker Pro driver][FileMaker Pro]Connect failed

Any help would be GREATLY appreciated.

[simon1663]

First of all, I think you need Visual Basic addon from Filemaker unlimited. Secondly, I suspect you have not setup ODBC connection properly....

What I suggest you rather do: use XML with web sharing - it is always the easiest way...

[salmon]

the dsn in the server have to include the ip of the machine that is holding the database. and your database have to have the RDAC sharing enable. also setup dsn on every machine where your are querying the database from.

[Ace]

Ok, I had this problem too, but after many hours of trying, I finally found out, what it's all about!

PHP and ASP both run in a system account, not in the same account as the current user. This means, that you, of course, has to create a system DSN, not user DSN.

Secondly, because the PHP and ASP runs in a system account, you cannot expect the ODBC to be able to contact FM Pro directly - instead you have to mark the "Use remote connection" and write "localhost" or whatever is the name of your web server.

Then make sure, that you have shared your databases for remote access, not just local access (which would only work, if the ODBC driver and FM Pro was running under the same user account)

This is only an issue on NT based OS', which means it should not be a problem under win95/98/me

[gecko]

Okay.... I'm able to connect my ASP page and my Filemaker database using ODBC on my computer becose I have Filemaker.

But, I want put my web site on an other server and Filemake is'nt install on this server.... What is the solution? May I install only ODBC drivers on the server ? I don,t want buy another filemaker software only for the hosting web server....

Thanks for your help!

David

------------------------------------------

[email protected]

Please remove "-nospam" for reach me!

------------------------------------------

[Leb i Sol]

Okay.... I'm able to connect my ASP page and my Filemaker database using ODBC on my computer becose I have Filemaker.

....

you will may-be able to update-delete-insert but SQL based Filtering syntax will NOT work with FM.

FM does not "understand" SQL very well

eg. WHERE userID= 'strUser'AND Reg_date='strDate'....

on top of it all:

you loose stored procedures= speed <

you must use ODBC= lowers the performance,many hosts require extra $$$ for DSN, if server is shared it Greatly kills your entire performance...etc.

the best shot you got with FM and ASP is on:

http://www.fmcdn.com/

or just ignore what I said and ....6 months from now you will be back at this forum

p.s. that is what happend to me..

good luck