You should add the password to the connection string in the same way you add the user id (UID) but use password=xxxx
>>> Once you connect in MSQuery it should hold [assume you are using MSQuery most do] so when teh code runs its in.
It's best this way and not saved with the query as a secure system would insist the user changes their password often, your query with the saved password would only work for the period your password was 'live'
>>> Sorry i do not agree if this ODBC is at work, which it must that by nor there, if you are an OP on YOUR System them security should nolt be an issue, under NT technologies its VERY hard to break in and the IT dept shopuld have screensaver PW protected for inctivity and so on, ODBC is not critical and takes time to get any amount of data worth stealing or un management authorised and add to the fact its not so easy to get the data unless you know exactly how to do this - you will know me well enough - i can not see the threat on that - just cant see it. If this guy the OP is having troubles and hes got teh task to do at work, then that highlights the point - IM NOT PICKNG just offering a view [ as you have seen i used ODBC a lot]
This way is still safe as you could use an input box to prompt for the password.
>> prompt is best but as i have explained.
ODBC i feel should be kept simple!!
If you want ti to be totally run in the backgropund with no user input then add it to the script or save it as previously mentioned - but make sure your sys admin keeps one account open for you which does not require password changes - and NEVER let on to an auditor !!!
>>> anyone will know soon as its run if they know of ODBC,,
Should get up and running soon, i would suggest the ICT Dept are approacted as we seem to be hitting issues and there could be complex issues assigned to teh ODBC licence say to many guys logged in so the link faults you might not as i was not be allocated to take a lcence cal from the corperate server wherethe remonte install will be located.
Just some history and knowledge there that i hope helps a bit - OK express my way i work total sucess and what i do - i cant say im right just expression my opions.
Kind regards