Solved

Vb and SQL Server

Posted on 1998-07-04
1
133 Views
Last Modified: 2010-05-03
I'm building a app in VB5 that will manage an SQL Server 6.5 database.

The question is, should i use a connection object or a database object?

Should i use DAO and ODBC or use rDO??
0
Comment
Question by:PedroMVGomes
1 Comment
 
LVL 9

Accepted Solution

by:
cymbolic earned 50 total points
ID: 1464933
Use a connection object, and RDO or ADO.  If just starting on this, I recommend you get "Hitchiker's Guide to Visual Basic & SQL server" by W. R. Vaughn from Microsoft Press.  It contains detailed examples, historical perspectives and comparisons of your available access methods.  Definitely don't use DAO if RDO or ADO is an option.
0

Featured Post

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Input past end of file vbs script 9 92
Problem to skip loop 6 57
Access 2013 combo box not working 3 44
Notepad++ how to remove delimiter : from beggning of the line? 3 103
Introduction While answering a recent question (http://www.experts-exchange.com/Q_27402310.html) in the VB classic zone, I wrote some VB code in the (Office) VBA environment, rather than fire up my older PC.  I didn't post completely correct code o…
You can of course define an array to hold data that is of a particular type like an array of Strings to hold customer names or an array of Doubles to hold customer sales, but what do you do if you want to coordinate that data? This article describes…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question