Link to home
Start Free TrialLog in
Avatar of pdanese
pdanese

asked on

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.

Avatar of Mani Pazhana
Mani Pazhana
Flag of United States of America image

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
ASKER CERTIFIED SOLUTION
Avatar of Mani Pazhana
Mani Pazhana
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of pdanese
pdanese

ASKER

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.