[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 151
  • Last Modified:

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
0
dfhaines
Asked:
dfhaines
1 Solution
 
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
 
JagarCommented:
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
 
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

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now