Printable View
I can't remember how to bring up the ODBC Data Source Admin screen, if I want the user to specify a User DSN, System DSN, File DSN, Driver etc.
I've had suggestions just to keep the ConnectionString blank and try to open the connection, but that doesn't seem to work.
To bring the ODBC data source adm screen. Go to control panel and it should have an icon for ODBC. If not you have to install it.
Sorry, I should have been more specific. I don't remember how to pull it up in my VB code. I'm using ADO. Here's what I have right now.
dim cn As New ADODB.Connection
With cn
.ConnectionString
= "DSN=Informix;Database=temp_db;Uid=;Pwd=;"
.ConnectionTimeout = 10
.Open
End With
I'd like to allow them to specifiy what type of System DSN, File DSN, Driver etc. they'd like to use.