Deploying with ODBC Connection [RESOLVED

If are deploying an application that uses ODBC for a Datasource connection, is it possible to setup that ODBC on the target site as part of the deployment? Or does the end user need to configure the connection manually?

e.g. Your application deploys to say C:\Program Files\My Project and the database called MyData is in a sub directory called DATA. The ODBC Connection name should be MyProjectData. The Target site will obviously NOT have an ODBC connection setup, so one needs to be created for the Application to work.

(Hope that makes sense!)

You dont need to make the user do it, as there are a few ways of dealing with this. Here's a few, shown in my order of preference:

1) Don't use a DSN (see the ADO connections link below for DSN-less connection strings)

2) Get your installer software to create the DSN when the program is installed (the MSI installer can do this)

3) Get your program to set it up when the program starts.

Great, Thanks a lot.