How should I deploy the connectionstring with Oracle 8.0.5?

  • Thread starter Thread starter LiuGuoqiang
  • Start date Start date
L

LiuGuoqiang

Hi,Ask a simple question:How should I deploy the
connectionstring with Oracle 8.0.5?


thx
 
Depends, but a few good ways include .Config files or as attributes of a
DataAccess class. Ideally you want to encrypt these buggers as far as the
file goes for security reasons.
 
Not sure what do you mean by "Deploy". If you mean what is the correct connectionstring to connect to Oracle 8.0.5 then the answer it is not different than what you would use
for any other Oracle version. Basically if you are using the Microsoft .NET Managed Provider for Oracle then it would be:

"data source=Oracleds;user ID=xyz;password=xxx"

If you are using the Microsoft OLEDB provider for Oracle then it would be:

"Provider=msdaora;data source=Oracleds;user ID=xyz;password=xxx"

If you are using the Microsoft ODBC Driver for Oracle then it would be:

"DSN=myDSN;UID=xyz;PWD=xxx"

Note that oracleds would be the alias or hostname for the oracle server. myDSN would be the ODBC Data Source name that points to the oracle server.

Also the above connection strings are irrelevant to the Oracle server version.

I hope this helps!


Thanks,
Hussein Abuthuraya
Microsoft Developer Support

This posting is provided "AS IS" with no warranties, and confers no rights.

Are you secure? For information about the Microsoft Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
 
Back
Top