Connection String

[Guest]

Could anyone please tell me what do each parameter denote in this example of Connection string used in Add functio
connstring =
"ODBC;DSN=96SalesData;UID=Rep21;PWD=NUyHwYQI;Database=96Sales

I presume that UID stands for User id and PWD for password and Database is the name of the databas
but what does DSN stand for
Any help
Thanks

 

[Brad]

Data source name.

Go into Control Panel>Data Sources to see a list of DSNs
defined on your system. It's essentially a shortcut to a
database on your network that knows how to talk to the
database through the driver associated with that DSN.

-Brad

-----Original Message-----
Could anyone please tell me what do each parameter denote

in this example of Connection string used in Add function

connstring = _
"ODBC;DSN=96SalesData;UID=Rep21;PWD=NUyHwYQI;Database= 96Sales"

I presume that UID stands for User id and PWD for

password and Database is the name of the database

 

[Guest]

H
I went to Control Panel>Administrative Tools>Data Sources and encountered a dialog box
In the list User DSN, its shows the list of ODBC drivers installed on the system. File DSN is empty. Do I need to add the database in this
Also please tell me what is the use of File DSN , if User DSN denotes the list of ODBC drivers
Thanks

 

[Guest]

Sorry for error in the earlier post for mistaking User DSN as ODBC drivers. Please tell me what is User DSN for? What is the fullform of DSN?