By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,392 Members | 1,583 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,392 IT Pros & Developers. It's quick & easy.

Building ODBC Connect strings that work

P: n/a
I've been trying to build a DAO.QueryDef.Connect string, building it
from a user ID and password string obtained previously by a log-in
dialog box, using it to log in to an Oracle database through an ODBC
connection. The problem I have is that it's intermittent, in that
invariably the first time I try to connect I still get the Oracle
log-in prompt where the user has to type in all the info again anyway;
and on subsequent connections sometimes the Connect string gets right
in, sometimes I still get the Oracle log-in dialog.

Here's an example of the Connect string using literals for
illustration:

qdfDWInstallBase.Connect = _
"ODBC;UID=MYUSERID;PASSWORD=MYPASSWORD;DSN=DW"

I have to think the purpose of the Connect string is to automate the
ODBC login. Any help at all would be greatly appreciated. Thanks in
advance!
Nov 12 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.