oracle db connection with VB 2005 express BETA 2

[henk]

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/tech/windows/odpnet/index.html) And
..NET Managed Provider for Oracle
(http://www.microsoft.com/downloads/details.aspx?FamilyId=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.

 

[Carlos J. Quintero [.NET MVP]]

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