i can not use TNS file or oracle databse in my client pc. how can i do this ??
Please help .
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Pankaj PandeyPosted Jun 20, 2013, 4:43 AM
if yes then write the result,,is it working or not when you put it direct in your pgmm,
write the code that you are using ..
shakila jannatPosted Jun 20, 2013, 3:36 AM
Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=MyHost)(PORT=MyPort)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=MyOracleSID)));User Id=myUsername; Password=myPassword;
this code in my app.config file it gives me
error:Object reference not set to an instance of an object what should i do???
:(
Pankaj PandeyPosted Jun 20, 2013, 3:30 AM
Using TNS
Data Source=TORCL;User Id=myUsername;Password=myPassword;
Using integrated security
Data Source=TORCL;Integrated Security=SSPI;
Using ODP.NET without tnsnames.ora
Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=MyHost)(PORT=MyPort)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=MyOracleSID)));User Id=myUsername;
Password=myPassword;
Sanjeeb LenkaPosted Jun 20, 2013, 3:06 AM
http://docs.oracle.com/cd/B28359_01/appdev.111/b28844/using_aspnt.htm#autoId0
download it:
http://www.oracle.com/technetwork/developer-tools/visual-studio/overview/index.html
mark it as answered if its help you.