cRODEEkrank
Technical User
I'm currently building an ASP application which interacts with a Microsoft database with linked tables to Oracle. I've created a connection string using the ODBC Oracle provider from Microsoft and I've received the following error:
TNS:could not resolve service name
Here's my connection code:
Set conn = server.CreateObject("ADODB.Connection"
strConnInfo = "Provider=msdaora;"
strConninfo = strconninfo & "Data Source=OracleContractorDB;"
strConninfo = strconninfo & "User Id=8789;"
strConninfo = strconninfo & "Password=8789"
conn.Open strConnInfo
Just as some background information, I can't access the Oracle database, as I'm not permitted to but do have permission to link tables via Access, so this is really my only option. Any thoughts??
CK
TNS:could not resolve service name
Here's my connection code:
Set conn = server.CreateObject("ADODB.Connection"
strConnInfo = "Provider=msdaora;"
strConninfo = strconninfo & "Data Source=OracleContractorDB;"
strConninfo = strconninfo & "User Id=8789;"
strConninfo = strconninfo & "Password=8789"
conn.Open strConnInfo
Just as some background information, I can't access the Oracle database, as I'm not permitted to but do have permission to link tables via Access, so this is really my only option. Any thoughts??
CK