Cannot connect to Oracle 9i Server with Oracle 9i Client using Visual Basic ADO's 2.1

Can you post the procedure header/interface: the list of parameters with their datatypes etc?

Have you also tried to install the Oledb provider from Oracle and use that one?
I had good results with that one, better than with the ODBC of microsoft and the one from Oracle.
Basically, I either had Bugs or Bad Performance using ODBC drivers, and switching to OleDB solved those problems.

CHeers

Humm,

You should try to connect via the "Test Connection" button, in the Oracle ODBC Driver Configuration window.  Please do the following and then let me know what happens:

1.  Open the control panel.
2.  Open the Administrative Tools folder.
3.  Double-click the Data Sources (ODBC)
4.  For ease of use just make a user DSN, left-click the User DSN tab
5.  Left Click the Add button.
6.  Scroll down the list until you see Oracle in OraHome92 <<what ever you named the oracle home to.
7.  Left-click the driver and then left-click the Finish button.
8.  Type "Test" in the source name, whatever the TNS entry is in the TNS Service Name field, and your user id in the User Id field.
9.  Left click the Test Connection button.
10. Enter your password and click ok...
11. If your connection fails here please let me know what the error message is.

Thanks,
JohnsterMonster

PS If you are failing here... it may be a good time to check the client out as well.  Open a cmd prompt and do the following:

c:\>tnsping <<tnsname_entry_goes_here>>
and
c:\>sqlplus /nolog
sql> connect username/password@<<tnsname_entry_goes_here>>

Example:
C:\Documents and Settings\jmharper>tnsping oratst

TNS Ping Utility for 32-bit Windows: Version 9.2.0.1.0 - Production on 11-AUG-2004 09:14:57

Copyright (c) 1997 Oracle Corporation.  All rights reserved.

Used parameter files:
C:\oracle\ora92\network\admin\sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = oratst)(PORT = 1521))) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = ORATST)))
OK (20 msec)

C:\Documents and Settings\jmharper>

and
C:\Documents and Settings\jmharper>sqlplus /nolog

SQL*Plus: Release 9.2.0.1.0 - Production on Wed Aug 11 09:15:39 2004

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

SQL> connect lang_test/abc123@oratst
Connected.
SQL>

BTW - Your error message is this:

ORA-06512: at stringline string
Cause: Backtrace message as the stack is unwound by unhandled exceptions.
Action: Fix the problem causing the exception or write an exception handler for this condition. Or you may need to contact your application administrator or DBA.

Thanks again,
JohnsterMonster

I am sorry, but none of the anwers above have resolved my issue. I am very grateful to angelIII {http:#11770268} & j79h110 {http:#11774266}, but i would prefer not to give any points.

Thanks.