Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle 8i and ODBC connection problem
Good point Sybrand. Here it is
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager] Data source name not found and no
default
driver specified
/ServerB14/detail.asp, line 85
Also, and if it helps out, I think I have the tnsnames.ora set up correctly and the ODBC set up right since I can get to the Oracle DB from Access and Crystal Reports.
I don't understand the tnsping, but tried this. I opened up a command prompt, typed
tnsping ServerA14 with no luck (the server that has the oracle DB
and then
tnsping 10.1.2.11 with no luck (that same server's ip)
Does that mean anything?
Also, our techie people tried to use a different server to connect to the oracle DB server that has ASP working fine, but they could not get an ASP to connect to the DB server either. Someone reinstalled Oracle 8.1.7 on my Server again, but didn't map the drive to the oracle setup program. I asked them to reinstall again after they map the drive but they think it's a waste of time. The only reason I mention it is because I saw a past post mentioning to map the drive first.
On Thu, 22 Feb 2001 09:17:16 +0100, Sybrand Bakker <postbus_at_sybrandb.demon.nl> wrote:
>On 22 Feb 2001 01:26:09 -0600, ziggs <> wrote:
>
>>We have an oracle DB on a web server and it will do ASP just fine.
>>However, when I try to connect to the same oracle DB with the same
>>ASP's on a different server, the different server won't connect to via
>>ODBC. The oracle DB is 8i. I am able to use Crystal Reports to
>>access the same oracle DB and also MS access, so I'm stumped. Any
>>ideas?
>
>We're stumped too, because you post no *exact* error messages.
>You can ping that server from the different machine?
>You can tnsping it?
>What is the ODBC error message?
>
>
>Hth,
>
>Sybrand Bakker, Oracle DBA
Received on Mon Feb 26 2001 - 01:56:03 CST