Automatic creation of ODBC connections for new SQL installs

As some of you probably know, we are migrating from Unix/Oracle to Windows/SQL. In the past, for new Oracle installs I create a CD. My question is, for SQL is there a way that the ODBC connections can be automatically created on the fat client from a CD install? I think it has something to do with the ODBCDataSource.inf file which is located in the Client directory on the deployment server. In the past I haven't copied this fold to my CD. Should I?

Patty

When installing from CD it does create the ODBC but not correctly. We got the CD to create the ODBC connections correctly by tweaking the ODBCDataSource.inf file on the deployment server. We had to add the port number (we don't use the SQL default port) and we had to specify the network protocol to use TCP/IP. Below is an example of one datasource from the .inf file.

[Central Objects - PY7333]
Driver=C:\WINDOWS\System32\sqlsrv32.dll
Server=V-TESTOWDB
Database=JDE_PY7333
AutoTranslate=No
Address=V-TESTOWDB,3853
Network=DBMSSOCN

Patty