ORACLE STRING

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
Tue Sep 06 13:33:06 CDT 2005

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

"Gina Hernandez" <pdwhitt@nospam.wdsinc.com> wrote in message
news:ORiD3yvsFHA.1132@TK2MSFTNGP10.phx.gbl...
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
Tue Sep 06 14:40:30 CDT 2005

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" <pdwhitt@nospam.wdsinc.com> schrieb im Newsbeitrag
news:ORiD3yvsFHA.1132@TK2MSFTNGP10.phx.gbl...
> 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
>

Gina
Tue Sep 06 15:27:00 CDT 2005

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

Thanks anyways

"Stefan Misch" <stefan.misch@removethis.gmx.de> wrote in message
news:%23eXZYrxsFHA.1256@TK2MSFTNGP09.phx.gbl...
> 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" <pdwhitt@nospam.wdsinc.com> schrieb im Newsbeitrag
> news:ORiD3yvsFHA.1132@TK2MSFTNGP10.phx.gbl...
>> 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
>>
>
>

Gina
Tue Sep 06 15:28:52 CDT 2005

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

Thanks

"Siva M" <shiva_sm@online.excite.com> wrote in message
news:eZdItFxsFHA.908@tk2msftngp13.phx.gbl...
> Check out http://www.connectionstrings.com/
>
> "Gina Hernandez" <pdwhitt@nospam.wdsinc.com> wrote in message
> news:ORiD3yvsFHA.1132@TK2MSFTNGP10.phx.gbl...
> 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
>
>
>

BillT
Wed Sep 07 03:29:02 CDT 2005

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;"

"Gina Hernandez" wrote:
> I went to this web site before, but there's no detail about the specific
> thing I am asking in this e-mail
>
> Thanks
>
> "Siva M" <shiva_sm@online.excite.com> wrote in message
> news:eZdItFxsFHA.908@tk2msftngp13.phx.gbl...
> > Check out http://www.connectionstrings.com/

Carlos
Wed Sep 07 04:40:20 CDT 2005

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" <pdwhitt@nospam.wdsinc.com> escribió en el mensaje
news:ORiD3yvsFHA.1132@TK2MSFTNGP10.phx.gbl...
> 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
>

Gina
Wed Sep 07 10:00:05 CDT 2005

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?

"BillT" <BillT@discussions.microsoft.com> wrote in message
news:5C2B59A7-FDA5-407A-A1BB-20597B29F74A@microsoft.com...
> 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;"
>
> "Gina Hernandez" wrote:
>> I went to this web site before, but there's no detail about the specific
>> thing I am asking in this e-mail
>>
>> Thanks
>>
>> "Siva M" <shiva_sm@online.excite.com> wrote in message
>> news:eZdItFxsFHA.908@tk2msftngp13.phx.gbl...
>> > Check out http://www.connectionstrings.com/

BillT
Wed Sep 07 14:44:06 CDT 2005

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

"Gina Hernandez" wrote:

> 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?
>
> "BillT" <BillT@discussions.microsoft.com> wrote in message
> news:5C2B59A7-FDA5-407A-A1BB-20597B29F74A@microsoft.com...
> > 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;"
> >
> > "Gina Hernandez" wrote:
> >> I went to this web site before, but there's no detail about the specific
> >> thing I am asking in this e-mail
> >>
> >> Thanks
> >>
> >> "Siva M" <shiva_sm@online.excite.com> wrote in message
> >> news:eZdItFxsFHA.908@tk2msftngp13.phx.gbl...
> >> > Check out http://www.connectionstrings.com/
>
>
>