Hey, folks.

I (might be) figuring how how to use the ODBC object (which I'm trying to use to create a connection to an Oracle 10g database server, just to test a connection).

Here's what I'm trying: Use the File object to create a DSN file with connection information input from a Dialog Box object. Once the File object writes the connection information to the DSN file, the ODBC object opens that DSN file.

What I don't know is how do I use the ODBC object to initiate the connection? I'm guessing I need to send a SQL command to initiate the connection? What would that command be?

Thanks again for all your help!


Most appreciatively...

RGBreality