Parameter type not valid

Question

0.00/5 (No votes)

See more:

Am working on vb 6.

Currently we are using microsoft obdc for oracle to connect with oracle database.
But i want to use oracle client...
I created DSN and used in connected string to open my data type. i'm using ADODB connection in my form.
but while executing my stored procedure its giving an error :"Parameter type not valid". (for input n output parameters am using parameter type adVarient).

Can u help me out..............??

Posted 20-Jul-11 5:46am

M.Ambigai

Add a Solution

Comments

S Houghtelin 20-Jul-11 14:30pm

Can you provide the code where the error is generated?

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Mehul M Thakkar · Answer 1 · 2011-07-20T08:49:00

Solution 1

I believe you should do some googling.

Also check the following links if it can help you somewhere,

How to Use Stored Procedures in VB6[^]

http://www.vb6.us/tutorials/using-ado-and-stored-procedures-vb6[^]

http://www.vb6.us/tutorials/oracle-and-visual-basic-using-ado[^]

Posted 20-Jul-11 8:49am

Mehul M Thakkar

Comments

M.Ambigai 22-Jul-11 0:57am

i've tried with all possible parameter types.
Am using varchar2 in my backend stored procedure.. i want exact parameter in my parameter in my frontend too. bcs varchar n varient sometimes give runtime exception.

In .net i used datatype varchar2 (In oracle client by jus adding reference of system.data.oracleclient).

Is there any possiblility here???

if i want to use varchar2 in vb6 wat is the reference i should add...?