Oracle Logon

[andthe]

I'm using an ODBC connection to connect to an oracle database. When I run a query that is based on other queries, it asks me to logon to the oracle database multiple times. Is there a way to only logon once? Any help is greatly appreciated! Thanks!!

 

[jmersing]

You have to create something called a connection string. It stores your password and user name. You can do it through the vba editor.

Did you set up a DSN connection, you can do that by linking to the tables by selecting an ODBC connection. You can store the info there also.

I also use MySQL drivers to connect and store connection string info. I think you can still download them for free @ http://www.mysql.com

 

[andthe]

Yes, I setup a DSN connection. I was able to enter the connect string and user id. However, I don't see a place to store the password.

I'm not real familiar with the vba editor, so I'm not sure what/where I would do this.

Thanks!

 

[caronii]

When you set up the ODBC connection for your table, there is a checkbox called Save Password. If you check that you shouldn't have to enter your password again.

 

[andthe]

I found it! Thanks a lot!

 

[andthe]

One thing I forgot to ask, since I already have my queries and reports setup is there anyway to modify the table connection to select "Save Password"?