VERIFY ODBC CONNECTION

[99Chuck99]

Hi All,
I have a question, I have set up a ODBC connection using the ODBC administrator in MSACCESS to link to an Oracle database on a network server, which works great. Prompts user for ID & PASSWORD. Is there a way to test this connection prior to any code running in case they enter an invalid password. Thanks in advance for any help.

 

[SkipVought]

Sure, if you handle the prompts and then insert the ID & Password into the Connect String and open the database and test the connection.

Skip,

_[red][/red]

 

[99Chuck99]

Each user on this shared database has been set up with an ODBC connection through the MSACCESS ODBC administrator (CONNECTION NAME = MAXPROD) which prompts the user for ID and password. I do not have a connection string in my code. If I set one up would the verfiy the MAXPROD connection?

 

[99Chuck99]

I'm thinking something like this...
Dim cn as Adodb.connection
Dim str as string

Set cn = new adodb.connection
cn.connectionstring = "DSN=MAXPROD"

cn.open
(test connection prior to code runing with promt if logon invalid)

 

[SkipVought]

Check out...

http://www.carlprothman.net/Default.aspx?tabid=81

http://www.connectionstrings.com/

http://support.microsoft.com/default.aspx?scid=kb;en-us;193128

Skip,

_[red][/red]