specify odbc connections and pw at runtime

[geebee]

hi,

i would like to know if there is a way to specify odbc connection and pw at
runtime when i run a query. what would be the code to write?

thanks in advance,
geebee

 

[Alex Dybenko]

Hi,
are you talking about pass-through query? then you can simple assign new
connection string to .Connect property of querydef object

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com