microsoft odbc for oracle

[kausti]

hi all!
i am trying to connect oracle procedures with vb6 application and asp. for that i need microsoft odbc for oracle. i installed this driver twice and it shows in the control panel also. but in vb6 as well as asp, when i try to connect, it gives me error 'no driver specified'. please note that i have created a dsn and already connected database using oracle odbc driver. but the problem is to call oracle procedures from the vb or asp, i have to use ms odbc for oracle.
if you have any solutions , please mail me immediately.
thank you,
kausti

[Robert Moy]

Hello:

Did you try to use ADO to do this? To get to ADO, You must go to
1.Project
2.Components
3. Check Miscrosoft ADO
4. Put in the ADO object in the form
4. Afterward in Properties for ADO
5. ConnectionString
6. click the button for ConnectionString
7. Microsoft OLE for Oracle
8. Put in UserId, Password, Server
9. click Apply
10. click RecordSource
11. Go to Command Type
12. Pick you wish
13. Go to Table or Store Procedure

I hope this solve the problem. Go Luck

[kausti]

hi Robert!
thanks for the reply. but u see i have already done what u told me. and infact it works fine with oracle odbc driver. but its when i try to use microsoft OLE for oracle that i receive the message 'no interface driver connected- function not performed'
starnge thing is the driver is listed in the drivers list. i even reinstalled the driver but no avail. any solution?
thanx anyways for ur prompt reply.
c ya