Connecting VB 4 App to SQL Server Database

What method other than ODBC can I use to open and connect to a SQL Server Database in my VB 4.0 app?  If other method(s) are available, please reply with code.

Thank you for your time and attention to this matter.
-David
dfhainesAsked:
Who is Participating?
 
JagarConnect With a Mentor Commented:
You can use OLEDB and ActiveX Data Objects.  I would reccommend using these as they are easy to use and provide you with move functionality then RDO (ver. 2.0) of ADO does anyways.
0
 
clifABBCommented:
As far as I know, ODBC is the only way.
0
 
yowkeeCommented:
The other way might be using DB Library provided by SQL Server. As I remember, there is something call VBSQL may go thru this way. I didn't have the reference on hand, can't confirm about it.
0
 
dfhainesAuthor Commented:
Jagar,

Before I accept your answer, are their ActiveX Data Objects and/or OLEDB in VB 4.0?  

David
0
 
dfhainesAuthor Commented:
Jagar,

Before I accept your answer, are their ActiveX Data Objects and/or OLEDB in VB 4.0?  

David

0
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.

All Courses

From novice to tech pro — start learning today.