By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,166 Members | 1,575 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,166 IT Pros & Developers. It's quick & easy.

oracle db connection with VB 2005 express BETA 2

P: n/a
Hello, I want make a database connection to an Oracle db (8i) with
Visual Basic 2005 express BETA 2. I already installed Oracle Data
Provider for .NET
(http://www.oracle.com/technology/tec...net/index.html) And
..NET Managed Provider for Oracle
(http://www.microsoft.com/downloads/d...d=4F55D429-17D...)
I still can't configure the oracle connection. The "add new data
source" button does not mention a ODBC or Oracle datasource. Or isn't
there any oracle connection possible in the vb'05 express version? (and
should I use visual studio 2003?)

Thanks in advance.

Nov 21 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Hi,

With both .NET providers the basic connect string is:

"DataSource=MyServer;User ID=scott;Password=tiger"

Each provider has other specific attributes. You can use the ADO.NET
Connection String Assistant of my add-in (below). Even the demo version will
allow you to see the connect string attributes.

--

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

"henk" <ri*******@hotmail.com> escribió en el mensaje
news:11**********************@o13g2000cwo.googlegr oups.com...
Hello, I want make a database connection to an Oracle db (8i) with
Visual Basic 2005 express BETA 2. I already installed Oracle Data
Provider for .NET
(http://www.oracle.com/technology/tec...net/index.html) And
.NET Managed Provider for Oracle
(http://www.microsoft.com/downloads/d...d=4F55D429-17D...)
I still can't configure the oracle connection. The "add new data
source" button does not mention a ODBC or Oracle datasource. Or isn't
there any oracle connection possible in the vb'05 express version? (and
should I use visual studio 2003?)

Thanks in advance.

Nov 21 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.