ASP connection to oracle

nahmed · #1 (**permalink**) 05-01-03, 14:46

Hello there

ASP connction to oracle database

could some one advise me please

Memnoch1207 · #2 (**permalink**) 05-02-03, 01:35

Code:

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 · #3 (**permalink**) 05-02-03, 10:10

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 · #4 (**permalink**) 05-02-03, 13:18

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!

Internet Services

Web Development

Digital Marketing

Consumer Tech