Connection to Oracle problem

[trade30]

I have a server running Win2K and an Oracle DBServer (seperate machine) running on Win2K. We where in an NT Domain, we just migrated to a Win2K Domain. Since then I keep getting a "Data Source Not Found" error.

Anybody have this problem before?
Any ideas to try?

Thanks for your help.

[John]

Hi,

Please answer the following so we can help:

1) What product and version are you using?

2) What driver are you using?

Thanks,
John

[trade30]

OS - Win2K w sp2
ASP-DB Enterprise version. The dll is as follows: ASPDB2002-EP-1009a.dll

ODBC: Microsoft ODBC for Oracle version 2.573.6526.00

[Mark]

Hi,
If you are getting a "data source not found" but it USED to work, it looks like a connection string problem or a driver didn't get loaded onto your new Windows 2000 system. Try to connect using "pure asp" code (don't use ASP-db) and see what happens. Did you create a System DSN that points to your Oracle database? Did you used to have one on your old NT system? Maybe that's what's missing.
-Mark

[Frank]

Also try the MS Oracle driver.

[trade30]

I don't think I was clear when I described the problem.
Before the problem I had a server running Win2K OS connecting to a NT 4.0 Domain.
The db connection is via a system DSN.

We upgraded the Domain - not this server. We moved the computer account from NT 4.0 domain to a Win2K domain.

We are using a MS driver.
Now that I have said that... IDEA!!!

Ok the problem is..... security rights.

I didnot change the user / password for the new domain in the Componet.

Yeah, it works..