Using VB/ADO connecting to Sybase, I set up a new System DSN called "rightnow". Don't put in a default server or database. Add two or more comma delimited servers and databases in the connection tab of the ODBC mangager.
.ConnectionString = "DATA SOURCE=rightnow"
.Properties("prompt"
= adPromptCompleteRequired
.Open UserID:=sUsername, Password:=sPassword
the first run thru it works fine. It opens a login box and I have to choose the server or db. After you choose a server database and entery in the reg is written saying which svr/db. The next time you run it, it grabs the stuff from the registry. I don't want that. I want it to prompt again. How do I get ODBC to NOT look at the reg. I don't want to add code to delte this reg entery.
.ConnectionString = "DATA SOURCE=rightnow"
.Properties("prompt"
= adPromptCompleteRequired .Open UserID:=sUsername, Password:=sPassword
the first run thru it works fine. It opens a login box and I have to choose the server or db. After you choose a server database and entery in the reg is written saying which svr/db. The next time you run it, it grabs the stuff from the registry. I don't want that. I want it to prompt again. How do I get ODBC to NOT look at the reg. I don't want to add code to delte this reg entery.
