write text into a pop-up window

[LinuxKommy]

I am having a problem connecting to an ODBC source. Even if i put the username and password in the DSN, the system ALWAYS wants the L/P and pops up a box to do so. I want it to run a query while no one is here, so there is the problem. would there be anyway for a vb script (started from task scheduler) to input the username and password without me being here?

thanks in advance,
douglas

 

[TomKane]

VB has a "sendkeys" function - maybe it works in vb as well?

 

[facho]

You have to pass the username and password from within your script when you connect to your DSN, putting it in the DSN won't usually work. Try something like this:

Set objConnection = CreateObject("ADODB.Connection&quot
Set objRecordset = CreateObject("ADODB.Recordset&quot
objConnection.Open "DSN=DSNName;UID=DBUser;PWD=password"

Where
DSNName = the name of your DSN
DBUser = the username you are trying to connect with
passwork = the user's password

Hope this helps.