?
Solved

Open application using Visual Basic

Posted on 2003-03-15
7
Medium Priority
?
171 Views
Last Modified: 2013-11-25
I'm trying to use VB to open a database application (SQL based) to get information from it. What's an easy way of doing that?

Thanks in advance

King
0
Comment
Question by:kingamoon
7 Comments
 
LVL 18

Accepted Solution

by:
Sethi earned 200 total points
ID: 8145572
The best way is to use ADO. You will have to open a connection object and then you can use Command objects and Recordset objects to work with your data in SQL Server. You will however need these links to properly guid you about ADO:

http://www.vbcode.com/asp/code.asp?lstCategory=Database
http://www.codeguru.com/vb/Database/index.shtml
0
 
LVL 70

Expert Comment

by:Éric Moreau
ID: 8146633
0
 

Expert Comment

by:CleanupPing
ID: 8900037
kingamoon:
This old question needs to be finalized -- accept an answer, split points, or get a refund.  For information on your options, please click here-> http:/help/closing.jsp#1 
Experts: Post your closing recommendations!  Who deserves points here?
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
LVL 18

Expert Comment

by:Sethi
ID: 8907953
Recommendation: Sethi
0
 

Expert Comment

by:CleanupPing
ID: 9056290
kingamoon:
This old question needs to be finalized -- accept an answer, split points, or get a refund.  For information on your options, please click here-> http:/help/closing.jsp#1 
EXPERTS:
Post your closing recommendations!  No comment means you don't care.
0
 
LVL 18

Expert Comment

by:Sethi
ID: 9063974
Already recommended: Points to Sethi
0
 
LVL 6

Expert Comment

by:GPrentice00
ID: 9113188
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:

 -->Accept Sethi's comment as Answer

Please leave any comments here within the next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER

GPrentice00
Cleanup Volunteer
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Question has a verified solution.

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

When trying to find the cause of a problem in VBA or VB6 it's often valuable to know what procedures were executed prior to the error. You can use the Call Stack for that but it is often inadequate because it may show procedures you aren't intereste…
This article describes some techniques which will make your VBA or Visual Basic Classic code easier to understand and maintain, whether by you, your replacement, or another Experts-Exchange expert.
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…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

621 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