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

Posted on 2004-08-10
Last Modified: 2008-02-01
We are Running into a problem Connecting to the Oracle 9i database with Oracle 9i Client using Visual Basic 6.0 and ADO's.

We have tried the the following drivers and all of them seem to fail at some point or other. Here is a description of the drivers and error messages

MS ODBC for Oracle using Connection String

Unable to Execute StoredProcedures with Paramters using ADO.
Error # 3265:Item cannot be found in the collection corresponding to the requested name or ordinal.

MS ODBC driver for Oracle using DSN with Oracle 9i Client
Unable to Execute StoredProcedures with Paramters using ADO.
Error: [Microsoft][ODBC driver for Oracle][Oracle]ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06512

Oracle in ORAHOME using DSN and ADO
Unable to Execute StoredProcedures with Paramters using ADO.
Throws an error when refresh parameters is called.

Can some body please help!!!!!!!!!!!!!!!!!!!!1

Thanks in advance...

Question by:shubz
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 11770268
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.



Expert Comment

ID: 11774266

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.


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>>
c:\>sqlplus /nolog
sql> connect username/password@<<tnsname_entry_goes_here>>

C:\Documents and Settings\jmharper>tnsping oratst

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

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

Used parameter files:

Used TNSNAMES adapter to resolve the alias
OK (20 msec)

C:\Documents and Settings\jmharper>

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

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

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

SQL> connect lang_test/abc123@oratst

Expert Comment

ID: 11774316
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,

Author Comment

ID: 12091695
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.


Accepted Solution

GhostMod earned 0 total points
ID: 12118953
PAQed - no points refunded (of 100)

Community Support Moderator

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…
Recently, Microsoft released a best-practice guide for securing Active Directory. It's a whopping 300+ pages long. Those of us tasked with securing our company’s databases and systems would, ideally, have time to devote to learning the ins and outs…
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question