| odbc call oracle instant client [message #223420] |
Thu, 08 March 2007 17:13 |
mmarius28
Messages: 1
Registered: November 2005
|
Junior Member |
|
|
Hy,
I tried to install odbc in oracle instant client 10.1 on Windows Vista, but odbc_install.bat says it couldn't find "HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI"
I cheked in the registry - it exists.
I tried with ODBC in oracle instant client 10.2 - it works ok, but I have another problem:
I have a VFP9 application witch connects through ODBC to an Oracle 10g database
I call a stored procedure witch returns a cursor:
lnSucces = SQLEXEC(gnConnHandle, "{ call my_programs(lnUserId) }")
It works fine with ODBC in oracle instant client 10.1, but with ODBC in 10.2 says:
Connectivity error: Unable to retrieve specific error information. Driver is probably out of resources
This error ocures while connected to an Oracle 10.1 or 10.2 database, on windows xp or vista.
Do you know how to get working ODBC 10.1 on Vista, or why ODBC 10.2 doesn't know how to work with ODBC call escape sequence?
Thanks in advance
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
