Automatic login during a macro

[twistedsistem]

I have a macro that runs to a sql database that requires a username and password. Is there a way i can set up a vb script to input this for the user automatically. If so can someone help me with that?

 

[unmarkedhelicopter]

Normally when you specify the database connection you supply (if necessary) the username and password.
What are you running this from and what are you connecting to ?

 

[KeithG]

You should be able to include it in your connection string. Are you running a pass through query from a macro?