ORACLE STRING

[Gina Hernandez]

Hello:

I have a web appliction and , I need to have the proper string to get a
connection to an Oracle DB from Vb.Net 2003, using a .NET string. I
need to know how to specify the password, login and the server in the
string connection. In all the examples, I haven't seen where and how to
specify this parameters, please help me with this matters.

Thanks

Gina Hernandez

 

[Siva M]

Check out http://www.connectionstrings.com/

Hello:

I have a web appliction and , I need to have the proper string to get a
connection to an Oracle DB from Vb.Net 2003, using a .NET string. I
need to know how to specify the password, login and the server in the
string connection. In all the examples, I haven't seen where and how to
specify this parameters, please help me with this matters.

Thanks

Gina Hernandez

 

[Stefan Misch]

Just a tip:

create an empty .UDL file (e.g. test.udl) and double click it. Choose OLEDB
provider and set appropriate properties. After that open the file with a
text editor and you have your connection string.

HTH,
Stefan

 

[Gina Hernandez]

Well, I am not trying to use an OLEDB connection, I am trying to use .NET
native connection

Thanks anyways

 

[Gina Hernandez]

I went to this web site before, but there's no detail about the specific
thing I am asking in this e-mail

Thanks

 

[Guest]

For your purposes, what's wrong with this connection string from
www.connectionstrings.com?
Specifying username and password:
"Data Source=MyOracleDB;User Id=username;Password=passwd;Integrated
Security=no;"

 

[Carlos J. Quintero [VB MVP]]

Hi Gina,

My add-in (below) offers a ADO.NET connection string feature that allows you
to create connection string for Oracle (and other databases) using different
..NET Data Providers, OLEDB Providers or ODBC Drivers, and it allows you to
test the connection. Even the demo version allows you to get the result.

--

Best regards,

Carlos J. Quintero

MZ-Tools: Productivity add-ins for Visual Studio .NET, VB6, VB5 and VBA
You can code, design and document much faster.
Free resources for add-in developers:
http://www.mztools.com

 

[Gina Hernandez]

where do you specify the server and the database?? or the Data source could
it be the Oracle server and the data base could be included when you are
doing the required query?

 

[Guest]

See "Connection Strings and Objects" section at
http://www.oracle.com/technology/pub/articles/cook_dotnet.html