Printable View
I have setup a system DSN (have the server IP address, DB Name etc) and used in the ADO connection
ADO.Open "DSN=xxx",
If the user do not have this DSN installed, then it cannot be run.
My question is :
How should I change the statement, so that I can hard code the IP address, DB name etc in the ADO.Open statement
Thanks for any hint
ADO.Open "Provider=[provider name];Driver={driver name};Server=[server];Database=[database];Uid=[userid];Pwd=[password];"
eg; for a SQL server database
ADO.Open "Provider=SQLOLEDB;Driver={SQL Server};Server=MYSERVER;Database=MYDB;Uid=SA;Pwd=;"
It may seem a little obvious, but as an addition to to the previous post, you can set up an 'Options' form where the server ip etc. is set by the user. Alternatively use the registry, or even a remote path. Just a couple of idea to make the program more flexible.
Matt