Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

run-time error 3151

Status
Not open for further replies.

pipa

IS-IT--Management
Dec 6, 2001
2
IT
when accessed a linked database I have been given the following visual basic error

run time error 3151

ODBC - CONNECTION TO {Microsoft ODBC for Oracle} 'failed

Any ideas to solve this issue

ciao

 
Most probably your ODBC setup is wrong. Go to the ODBS Icon in the config panel and change the settings. I also recommend using the odbc that comes with the oracle client CD. Too bad I.T. is not cash business

Luc Foata
Unix sysadmin, Oracle DBA
 
..it could be an error on tnsnames.ora or something like about some sys file connection?
thkx
ciao Gp
 
if you weant to valide your sqlnert or net8 setup you can use tnsping or tnsping80 or even sqlplus from the client to try to connect to your database.
If tnsping answers then your problem is your odbc, else it is your net setup. Too bad I.T. is not cash business

Luc Foata
Unix sysadmin, Oracle DBA
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top