Error connecting 10g with vb6 in vista?

mayjune's Avatar, Join Date: Jun 2009
Invasive contributor
Hi,
I am using oracle 10g and vb 6 on vista. When i try connecting it i get this
Error = -2147467259 (80004005)
Error string: [Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed

It works the first time till i don't restart the comp, then if i repair or reinstall it works till I don't restart the computer again. The same problem i faced on other comp which has windows 7. It sounds like maybe vista/7 has some problem, but I know people who are using same config and vista and it works for them without any problem. I don't know how to fix this problem. Please help...
nimesh's Avatar, Join Date: Apr 2009
Invasive contributor
What ODBC driver are you using?

and this does not seem to be a vista/7 issue, but a permission issue
nimesh's Avatar, Join Date: Apr 2009
Invasive contributor
Check if this helps:
http://www.orafaq.com/forum/t/38079/2/
mayjune like this
mayjune's Avatar, Join Date: Jun 2009
Invasive contributor
how do i check which odbc drivers is it?

this is what the code is like

Code:
Dim ado As ADODB.Connection

Private Sub Form_Load()
    Set ado = New ADODB.Connection
    ado.ConnectionString = "Provider=MSDASQL.1;Password=ppp;Persist Security Info=True;User ID=aaa;Data Source=xxx"
    ado.Open
end sub
nimesh's Avatar, Join Date: Apr 2009
Invasive contributor
Have you configured the DSN?

Data Source=xxx

xxx - this is the dsn name
mayjune's Avatar, Join Date: Jun 2009
Invasive contributor
Hey I got it!!
Vista/7 is really annoying with its "security" thing!!
Just goto Vb6.exe file (the main file which runs the vb6)
If you don't know how to find it
goto start and goto visual basic 6
right click and select properties -> open file location
when you can see the exe file
right click, goto compatibility -> run as administrator -> ok
run it and it will work flawlessly....

Thanks the link you gave me the idea, they gave something different but it clicked me as this i had done for 3d studio max 9 and it worked!

Yeaaa
nimesh's Avatar, Join Date: Apr 2009
Invasive contributor
thanks