The error message posted is an ODBC error message. It suggests that here is
no DSN set up on the second machine which connects to the oracle database.
line14 of detail.asp should contain an ODBC connection string with a Data
source name in there. If you can read this file, find out what the data
source should be called and then setup an ODBC system datasource with
exactly that name.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
<ziggs> wrote in message news:2g2k9t0k914s21n2d576i99s6od7sefbbr_at_4ax.com...
> 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 - 07:18:58 CST
