0

I'm using the times ten demo odp on a windows 7 box and have followed all the steps. I have a tnsnames.ora entry as follows

sampledb_1122 =(DESCRIPTION=
(CONNECT_DATA = 
    (SERVICE_NAME = sampledb_1122)
    (SERVER = timesten_direct)
)

)

The driver I'm using is ttdv1122d.dll

and using the following as the connection string:

connStr = @"Data Source=sampledb_1122:timesten_direct;user id=appuser;password=appuser";

I've also tried:

connStr = @"Data Source=localhost/sampledb_1122:timesten_direct;userid=appuser;password=appuser";

When I try opening the connection con.Open() for the oracle connection, it fails and throws the error ORA-29158: Unable to open library

I'm able to connect using ttisql cmd prompt and see all the data.

Any help on what I'm missing. I have oracle times ten 1122 installed.

Thanks, Nikhil

Nikhil
  • 181
  • 3
  • 12

2 Answers2

0

try to connect with this string "DSN=MyDSN;UID=MyUser;Pwd=MyPassword;OraclePWD=OracleDbPassword";

Ugur Artun
  • 1,744
  • 2
  • 23
  • 41
  • I tried this but get the following error:'DSN' is an invalid connection string attribute. Then I tried a bunch of others too - connStr = @"Data Source=my_cachedb_rightCS;User Id=XOM_GRT_EA_3510000;Password=XOM_GRT_EA_3510000;OraclePwd=XOM_GRT_EA_3510000"; but get the same issue. – Nikhil Jul 05 '13 at 12:54
0

So the problem wasn't the connect string but the ODAC version. I changed it to 4.11.2.3.0 and also changed the properties of my project in visual studio to be a 64 bit and unchecked the prefer 32 bit. Compiled and ran it and was able to connect to the times ten instance. The final connection string was the following:

"Data Source=sampledb_1122;user id=appuser;password=appuser;Statement Cache Size=0"
Nikhil
  • 181
  • 3
  • 12