Hi All:
How can I create a DSN programically for my database on sql server2000? I do not want to screate dsn for each individual user on their machine, I want to the dsn in my program.

Here is what I am doing, and it is not working.

oDataConn.Open "Provider=sqloledb;" & _
"Driver={SQL Server};" & _
"Server=NACSIIS2;" & _
"Database=Meeting_Test;" & _
"Uid=admin;" & _
"Pwd="


Thanks for any info.
MA