B
Bob Clegg
I am about to connect to an Oracle database using ado.net
The connection string sample that I tried is:
oOracleConn.ConnectionString = "Data Source=MySever;User
ID=MyUser;Password=MyPassword;Integrated Security=SSPI";
I keep getting ORA 12154 TNS could not resolve SERVICE_NAME given in
connect descriptor.
Which seems reasonable seeing I am not specifiying the SID.
But there doesn't seem to be a way to specify the SID (at least in the help
file that I found.)
(Yes there are multiple SIDs on this machine.)
Can anyone please give me a connection string for say :
HostComputer MyComputer
User MyUser
Password MyPassword
SID ThisSID
(Running Oracle 8.1.7 Client.)
thanks
Bob
The connection string sample that I tried is:
oOracleConn.ConnectionString = "Data Source=MySever;User
ID=MyUser;Password=MyPassword;Integrated Security=SSPI";
I keep getting ORA 12154 TNS could not resolve SERVICE_NAME given in
connect descriptor.
Which seems reasonable seeing I am not specifiying the SID.
But there doesn't seem to be a way to specify the SID (at least in the help
file that I found.)
(Yes there are multiple SIDs on this machine.)
Can anyone please give me a connection string for say :
HostComputer MyComputer
User MyUser
Password MyPassword
SID ThisSID
(Running Oracle 8.1.7 Client.)
thanks
Bob