connection to database

[rhitom dutta]

I have created the table in sql plus. In sql,the followings are the input
User name: trainee
Password: trainee
Host string: traindev
There is a table named ‘reg’.
I am using ASP code to connect to the database.
The connection code:

<%
Dim objConn
Set objConn=Server.CreateObject("ADODB.Connection")
objConn.Provider="MSDAORA"
objConn.ConnectionString= "userid=trainee; password=trainee; datasource=traindev"
objConn.Open
%>

But it shows the following error:
Error Type:
Microsoft OLE DB Provider for Oracle (0x80004005)
ORA-12203: TNS:unable to connect to destination

[jhardman]

that doesn't look like a very standard connection string. I could be wrong. Is traindev a DSN you created, or the name of the Oracle server?