I need a simple ODBC connection EXAMPLE

[kenteroo]

Hi Folks,

I'm trying to connect to a Filemeker DB running on a Windoze box using WinRunner via ODBC on another Windoze box. Doing this with Oracle is extremely simple but I have yet to find an example of how to simply connect to a FMP DB via ODBC.

The code in WR looks like this:

DSN = "casap10"; # my defined FMP DSN

UID= "USER";

PWD = "PWD";

query = ("SELECT * FROM TABLE");

rc = db_connect ( "mySession" , "DSN="& DSN &";UID="& UID &";PWD="&PWD );

db_execute_query ( "mySession", query , record_count );

Questions:

What should TABLE look like in my query? ("xyz.fmp"?) OR

Where is the DB name defined? I have several running on casap10. Do I need a DSN per DB?

I have to say that there should be many, many, many examples of this sort of thing available on this list if I search for "ODBC connection example" but I haven't been able to find any. Am I missing something simple?

Many thanks in advance!

[ March 25, 2002, 12:21 PM: Message edited by: kenteroo ]