?
Solved

VB6 and SQLexpress 2005

Posted on 2006-11-01
1
Medium Priority
?
198 Views
Last Modified: 2013-12-26
Hello All

We are writting an application in VB6 ( has to be vb6 because we need to use RDO) that reads data from a vendors database into VB, that works ok. We now need to then save the read data into a SQLexpress 2005 database.

Anybody have any ideas or even code snippets that would be great

Many thanks in advance
0
Comment
Question by:Paul-Brooks
1 Comment
 
LVL 20

Accepted Solution

by:
hes earned 2000 total points
ID: 17852117
You have to use ADO 2.8, but the connections and inserts to the database will be the same as SQl2K

An example is here
http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=65022&lngWId=1
0

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

Question has a verified solution.

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

Introduction In a recent article (http://www.experts-exchange.com/A_7811-A-Better-Concatenate-Function.html) for the Excel community, I showed an improved version of the Excel Concatenate() function.  While writing that article I realized that no o…
When designing a form there are several BorderStyles to choose from, all of which can be classified as either 'Fixed' or 'Sizable' and I'd guess that 'Fixed Single' or one of the other fixed types is the most popular choice. I assume it's the most p…
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…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Suggested Courses

807 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