I have been experimenting with ODBC connections the last few days with excel and have been able to pull out the necessary data where required. The only problem that I can't seem to work out is the ability to pass the username and password credentials through with the ODBC connection string. What is currently happening, is for each query I am getting prompted to enter my log in details again. Which from the looks of it is because the ODBC connection ends after each query is executed.
The questions that I have are:
- Is it possible to keep the connection open for longer so that the log in details are not required for each query? This would be similar to how performing the queries via Microsoft Access work. It asks for the log in details once and then I assume keeps the connection open for all the following queries
- Is it possible to pass the log in details through with the connection string? And if so how? (I have tried setting UID and PWD to be the log in details but still get prompted)