| Should I install Oracle 9i Client on the server? [message #138273] |
Wed, 21 September 2005 01:47  |
rushing
Messages: 135
Registered: January 2004
Location: Beijing,China
|
Senior Member |
|
|
I have install Oracle 9i database on the server.
If I want to use System.Data.OracleClient within .net program on the server, should I install the client software of Oracle 9i?
|
|
|
|
| Re: Should I install Oracle 9i Client on the server? [message #138274 is a reply to message #138273] |
Wed, 21 September 2005 02:01  |
sunil_v_mishra
Messages: 506
Registered: March 2005
|
Senior Member |
|
|
hi,
Dont have to do any thing on server were your database is stored ... practically your client for database is store on different machine other than server .. and remember oracle client is connect to the oracle database server because of TNSNAMES.ORA file which contain the connection string to connect the database on server.
As far .Net is consider you dont have to supply connect string from the client but ... i think you should have tnsnames.ora file at the client end because of which connection can be establish between client and oracle database server.
Still you can check for some other thing .. i m not confident about .net but long time back my one client connect to database using ASP.Net without specifing connect string in his ASP.Net code and that database was remotly present to which he was connecting (note:- database was of hosting domain 24x7 production) and to provide connection to client i had not doen any thing other than informaing him what his tnsname.ora should be.
Regards
Always Friend Sunilkumar
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
