OCI.DLL: The specified module could not be found + OCIEnvCreate fa

[Guest]

In VS2005 (Version 8.0.50727.42), I'm trying to create a "Data Connection" in
the "Server Explorer" window ...

I right click on "Data Connections" ... and choose "Add Connection" ...

In that window, I change the "Data Source" to "Oracle Database" ...

Then for "Server Name" I enter "newbisd.world", which corresponds to an
entry in my TNSnames.ora file ... and I type in my Username and Password ...

Then, when I hit either "OK" or "Test Connection", I get an error box titled
"OCI.DLL" that says "The specified module could not be found" ... and after I
click "OK" to that, another one comes up saying "OCIEnvCreate failed with
return code -1 but error message text was not available."

Where do I start?

Thanks for any tips / pointers ...


other info ...
- I'm running Windows 2000 5.00.2195 (SP4)
- I'm running Oracle 9.2 ... have upgraded to this
- I can connect to the database with Oracle SQL*Plus ... and TOAD
- I've read Paul Clement's reply to MikeB from 7/22/2005 and gave
Authenticated User privelege to the ORACLE_HOME ...
- According to my registry (when viewd by Regedit), in the
HKEY_LOCAL_MACHINE folder + SOFTWARE folder + ORACLE folder, the variable
ORACLE_HOME = C:\oracle\ora92 (... and I have a similar entry in a subfolder
called HOME0) ... and in this folder's "bin" directory, I've got a file named
"oci.dll" that's 112KB dated 05/01/2002 8:40pm

 

[David Browne]

In VS2005 (Version 8.0.50727.42), I'm trying to create a "Data Connection"
in
the "Server Explorer" window ...

I right click on "Data Connections" ... and choose "Add Connection" ...

In that window, I change the "Data Source" to "Oracle Database" ...

Then for "Server Name" I enter "newbisd.world", which corresponds to an
entry in my TNSnames.ora file ... and I type in my Username and Password
...

Then, when I hit either "OK" or "Test Connection", I get an error box
titled
"OCI.DLL" that says "The specified module could not be found" ... and
after I
click "OK" to that, another one comes up saying "OCIEnvCreate failed with
return code -1 but error message text was not available."

Where do I start?

Add the location of OCI.DLL to the PATH and reboot.

David

 

[Guest]

Add the location of OCI.DLL to the PATH and reboot.
David

Assuming you mean the "System variable", which I can see/edit via Control
Panel + System + Advanced + Environment Variables ... it already is ... also
assuming that it's OK for it to be listed as "Path" (as opposed to "PATH")
.... the first subdirectory listed is "C:\oracle\ora92\bin" and there is a
file in that directory called "oci.dll" (with timestamp I previously posted).

Thanks for reply ... got another idea?