Problem with connecting to database

[Patros]

The error given is
Microsoft OLE DB Provider for SQL Server (0x80004005)
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
/Application/Query.asp, line 6
Basically I am trying to connect to an Oracle 9i database

The code is as follows
Set cnGAME = CreateObject("ADODB.Connection&quot
cnGAME.Open "Provider=SQLOLEDB;" & _
"Data Source=(local);" & _
"Initial Catalog=games;" & _
"User Id=;" & _
"Password=;"

Does anyone know what it should be?
Thanks in advance,
Patros.

 

[palbano]

>> "User Id=;" & _
>> "Password=;"

don't u need a login+password to gain access?

just a wild guess
-pete

 

[Patros]

Actually the username and password are given, just kind of deleted them as they are not the problem.
[I can log onto oracle 9i server via the oracle terminal/screen using my username + password)

 

[baddos]

You are using the SQL server connection string not an oracle one.

-Bad Dos

 

[Patros]

So "Provider=SQLOLEDB;" & _
needs to be changed to what?
Thanks,
Patros

 

[baddos]

Try this...

Provider=MSDAORA;Data Source=games;User ID=myuserID;Password=mypassword

 

[Patros]

Thanks