Oracle Network Conn Sting
-
I use this connection string to connect to a DB on the same computer as the application. Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;User Id=myUsername;Password=myPassword; Now I want to connect from my application to a remote database on remote server through local network. How should I modify the connection string?
-
I use this connection string to connect to a DB on the same computer as the application. Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;User Id=myUsername;Password=myPassword; Now I want to connect from my application to a remote database on remote server through local network. How should I modify the connection string?
http://www.connectionstrings.com[^] can help you out. You are going to have to point the connection string to the ip address of the remote server. Frankly, I have not done any Oracle work in the past year or so, the site I provided is a very useful site that is worth bookmarking :-D
"I've seen more information on a frickin' sticky note!" - Dave Kreskowiak
-
http://www.connectionstrings.com[^] can help you out. You are going to have to point the connection string to the ip address of the remote server. Frankly, I have not done any Oracle work in the past year or so, the site I provided is a very useful site that is worth bookmarking :-D
"I've seen more information on a frickin' sticky note!" - Dave Kreskowiak
So I will have to do something like this? Provider=OraOLEDB.Oracle;**Host=xxx.xxx.xxx..xxx;Port=1521;**Data Source=MyOracleDB;User Id=myUsernameassword=myPassword; Do I still need the "Data Source" option?