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

qdfDWInstallBase.Connect = _

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
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.