Structure of the ODBC file DSN

Odbc
ODBC File DSN's little secret
1. Use the attached WordPad text editor to create a suffix named. The file for the DSN, formatted as follows, and then saved in text format:
Note: The format is important and must be saved as ' text format ', otherwise the editor should be OK.
#################################
[ODBC]
driver= driver Name
uid= User Name
pwd= Password
database= database name
Wsid= Server Name
app= (casually fill in)
Server= Server Name
###############################

2. To this. The DSN file is copied to your common files\odbc\datasources directory, and if you don't know the directory,
Try to build a file DSN in the Control Panel and then locate the file to get the directory.

3. Cn.open "filedsn= filename. dsn" can be connected.

****************************************************************************
Here are my tests.
1.MY.DSN file:
[ODBC]
Driver=sql Server
Uid=sa
Pwd=finegirl
Database=testdb
Wsid=tbb-it
App=netstar Application
Server=tbb-it

2. Copy to C:\Program Files\Common Files\odbc\datasources Directory

3. The procedure is called as follows:
Dim cn as New ADODB. Connection
cn. Open "Filedsn=my.dsn"
*****************************************************************************

Be clear enough, remember to add points, if you are handsome enough, please drink coffee. :)

I want to reply: Someone is involved in the discussion, please email me.