Setting up a Connection String

I have only ever used ODBC for setting up my database connections, but I need to do it in a way that does not go through ODBC. How do I set it up so that when a user installs the program the datasourse is already setup without having to set-up ODBC????

Thanks

You can use 'DSN-less' connections by creating a connection string on-the-fly but this assumes that you have the drivers already installed.

If you create a connection object using the Data Environment the connection string can be cut and paste from the designer.

Cheers,

P.

Father of two sets of twins!!!! hard work I bet

How do you you the App.Path function? eg.

Ado.ConnectionString = App.Path ??????

basically the database is in the app path so how would I set up the database that way????