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

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
Mon Aug 21 19:30:22 CDT 2006


"imhl58" <imhl58@discussions.microsoft.com> wrote in message
news:9871111A-F314-418E-8BAC-D7239C615BCC@microsoft.com...
> 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

imhl58
Mon Aug 21 21:44:02 CDT 2006

"David Browne" wrote:
> 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?