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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
Thanks.
Yup
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