[nahmed]

Hello there

ASP connction to oracle database

could some one advise me please

[Memnoch1207]

OLE DB Provider for Oracle (from Microsoft)

oConn.Open "Provider=msdaora;" & _
                  "Data Source=OracleServer.world;" & _ 
                  "User Id=;" & _
                  "Password=;"


OLE DB Provider for Oracle (from Oracle)

For Standard Security

oConn.Open "Provider=OraOLEDB.Oracle;" & _
                  "Data Source=MyOracleDB;" & _ 
                  "User Id=;" & _
                  "Password=;"

For a Trusted Connection

oConn.Open "Provider=OraOLEDB.Oracle;" & _
                  "Data Source=MyOracleDB;" & _ 
                  "User Id=;" & _
                  "Password=;"
Or

oConn.Open "Provider=OraOLEDB.Oracle;" & _
                  "Data Source=MyOracleDB;" & _ 
                  "OSAuthent=1;"

[nahmed]

Hello there

after using following code

OLE DB Provider for Oracle (from Microsoft)[/b]

oConn.Open "Provider=msdaora;" & _
"Data Source=bsntora;" & _
"User Id=;" & _
"Password=;"


I am getting this error message

Microsoft OLE DB provider for oracle (0*80004005)
ora-12514: TNS:listener could not resolve SERVICES_Name given
in connection descriptor

I am working on uni server

[rhs98]

nas your going to have to ask uni to let you play with the settings. I think most of uni computers are not set up to allow you to connect like this.

Go and ask your FYP tutor, he will be able to tell you what to do. But your cutting it fine leaving it this late: its due friday!