ODBC Oracle and passwords

[GBall]

Has anyone coded a link to an Oracle database using their NT logon ID and password ("UID=;password=&quot and managed to connect without the ODBC login box being displayed ?
I just can't seem to get round this.
Every time I run the code, the box gets displayed, but all I do is click on the OK button and it connects me.
So why does it pop up ?

thanks for any/all help. Regards,
Graham

 

[tomschafer]

Never messed with Oracle but any easy way to get the connect string in SQL Server is to manually link to the table and when the table selection dialog box pops up make sure you have save password checked. Then open up the table in design view in Access goto view properties and the description property should be the string you are looking for. Hope it works.

 

[Parttimer]

I get the same problem, but I have to input the password to get connected. The way round this for me was to use an SQL pass through query. In the querys properties under ODBC connect str I placed the following:

ODBC;DSN=UNIX Consolidation;DBQ=?????;ASY=ON;PWD=?????

Works fine for me just fill in the question marks with your rel details.

Hope this helps

PartTimer.

 

[GBall]

When I first posted, I was using the MS ODBC for Oracle driver, which popped up the box with all the data filled in.
I've now changed to the Oracle 73 ver 2.5 driver, which pops up a similar box, but does not have the server field populated.
I can get it to connect OK with a link and refresh it in code, but I just can't get it to work dsn-less.
I have even created a file dsn, checked mysysobjects and faithfully reproduced the connection string, but without success.
TGIF !!
Regards,
Graham