FM/ODBC Question

[Anatoli]

RE: So my first question is--when I create the Data Source, it doesn't ask me the location of the file to use. Do I put the file in a certain folder? How does it know what file to use?

-----------

Do you have the file open in FileMaker?

[marija]

Hello FM Gurus:

I have set up an ODBC Data Source for FM. I am connecting to the Data Source using ASP. I'm getting the error: "[FileMaker][ODBC FileMaker Pro driver][FileMaker Pro]Database not open." when I try to connect. This is actually more promising than previous errors! I do have the database open in FM Pro, though.

So my first question is--when I create the Data Source, it doesn't ask me the location of the file to use. Do I put the file in a certain folder? How does it know what file to use?

#2 Any ideas why I'm getting this error? I'll paste my code if it'll help.

Any info would be great. Thanks!!

[marija]

Do I have to have the file open in FileMaker when I create the data source? I do have it open when I'm trying to CONNECT to the data source.

[Anatoli]

I know next to nothing about ODBC. It was never strong point for FileMaker. But try to have everything open in FM when you are testing ODBC and see how it goes.

[homerJ]

Did you enable Local Data Access Companion or Remote Data Access Companion in Filemaker Pro?

No,you don't need to put any file in any folder when you set up the Data Source.One more thing, I think you can't have any space between the FM database's name (corerct me if I'm wrong).

[JPaul]

You can also download an exhaustive documentation on how ODBC works at www.merant.com (formerly INTERSOLV, the world's leader ODBC factory).

Regards.