VB.net Standard edition and database connections

Hi, I have a pretty simple question.

I'm thinking about getting VB.net 2003 Standard edition (100 bucks or so), but it isn't clear to me what limitations this software has w/respect to database connectivity.

Will the standard edition allow me to connect to other databases (besides sqlserver) like Oracle & Mysql?

I've read different/contradictory things about this and microsoft itself does its best to muddy/avoid the issue.
What seems clear is that databases cannot be accessed remotely using vb.net 2003 standard, but it isn't clear if I have Oracle running as a localhost whether I'll be able to connect.

Thanks.

pdaneseAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

mani_saiCommented:
Hello pdanese ,

Regarding database connectivity issues(remotely or locally).

It is possilbe to connect using vb.net 2003 / ado.net.

You have to use proper ADO.Net provider.

You can find the list of providers for your scenario:


http://www.sqlstrings.com/

http://www.sqlstrings.com/SQL-Server-connection-strings.htm

http://www.able-consulting.com/ADO_Conn.htm


Hope it helps
0
mani_saiCommented:
For Oracle:

Here are some examples of connection string you can use to connect to oracle databases:

Oracle .NET Data Provider - From Microsoft

 System.Data.OracleClient
The Microsoft .NET Framework Data Provider for Oracle is an add-on component to the .NET Framework 1.0 that provides access to an Oracle database using the Oracle Call Interface (OCI) as provided by Oracle Client software.

Oracle 8i Release 3 (8.1.7) Client or later must be installed for this provider to function correctly.

Note: This .NET Data Provider is included in version 1.1 of the .NET Framework. You need only download this, if you are running version 1.0.

Using C#:

using System.Data.OracleClient;
 
OracleConnection oOracleConn = new OracleConnection();
oOracleConn.ConnectionString = "Data Source=Oracle8i;" +
                               "Integrated Security=SSPI";
oOracleConn.Open();

Using VB.NET:

Imports System.Data.OracleClient

Dim oOracleConn As OracleConnection = New OracleConnection()
oOracleConn.ConnectionString = "Data Source=Oracle8i;" & _
                               "Integrated Security=SSPI";
oOracleConn.Open()


--------------------------------------------------------------------------------

 Oracle .NET Data Provider - From Oracle
 Oracle.DataAccess.Client
The Oracle .NET Framework Data Provider from Oracle is an add-on component to the .NET Framework.

Using C#

using Oracle.DataAccess.Client;
...
OracleConnection oOracleConn = new OracleConnection();
oOracleConn.ConnectionString = "Data Source=MyOracleServerName;" +
                               "Integrated Security=SSPI";
oOracleConn.Open();


Using VB.NET

Imports Oracle.DataAccess.Client
...
Dim oOracleConn As OracleConnection = New OracleConnection()
oOracleConn.ConnectionString = "Data Source=MyOracleServerName;" & _
                               "Integrated Security=SSPI";
oOracleConn.Open()

--------------------------------------------------------------------------------

 OraDirect .NET Data Provider - From CoreLab
 CoreLab.Oracle
The OraDirect .NET Data Provider is an add-on component to the .NET
Framework that provides access to an Oracle database using the Oracle
Call Interface (OCI) as provided by Oracle Client software.

Using C#

using CoreLab.Oracle;

OracleConnection oOracleConn = new OracleConnection();
oOracleConn.ConnectionString = "User ID=myUsername;" +
                              "Password=myPassword;" +
                              "Host=(local);" +
                              "Pooling=true;" +
                              "Min Pool Size=0;" +
                              "Max Pool Size=100;" +
                              "Connection Lifetime=0";
oOracleConn.Open();

-----------------------------------------------------------------------------------------

Using VB.NET

Imports CoreLab.Oracle

Dim oOracleConn As OracleConnection = New OracleConnection()
oOracleConn.ConnectionString = "User ID=myUsername;" & _
                              "Password=myPassword;" & _
                              "Host=(local);" & _
                              "Pooling=true;" & _
                              "Min Pool Size=0;" & _
                              "Max Pool Size=100;" & _
                              "Connection Lifetime=0"
oOracleConn.Open()



----------------------------------------------------------------------------------------------------
For Oracle OLE DB Provider

' VB.NET
Imports System.Data.OleDb
...
Dim oOleDbConnection As OleDbConnection
Dim sConnString As String = _
         "Provider=OraOLEDB.Oracle;" & _
         "Data Source=MyOracleDB;" & _
         "User ID=myUsername;" & _
         "Password=myPassword"
oOleDbConnection = New OleDb.OleDbConnection(sConnString)
oOleDbConnection.Open()

--------------------------------------------------------------------------------------------------
For Oracle ODBC Driver

' VB.NET
Imports System.Data.Odbc
...
Dim oODBCConnection As OdbcConnection
Dim sConnString As String = _
         "Driver={Microsoft ODBC for Oracle};" & _
         "Server=OracleServer.world;" & _
         "Uid=myUsername;" & _
         "Pwd=myPassword"
oODBCConnection = New Odbc.OdbcConnection(sConnString)
oODBCConnection.Open()

0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
pdaneseAuthor Commented:
I just want to make sure that your suggestions will work with the standard edition (i.e. NOT the full-blown Professional edition that costs $1000 or so).

Thanks.

0
mani_saiCommented:
Yup
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic.NET

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.