Using SQL server 2005 instead of Access database with VB6 Application

Posted on 2007-08-04
Last Modified: 2010-03-19
I'm using VB6 with Access database and I was working though this connection :
con.Open "Driver={SQL Native Client};Server=IT-professional\sqlexpress;Database=WH;Uid=sa;Pwd=Admin_1Nt4"

to sue it through the data base by this way:
RF.Open " Select Cust_Code From Customers ", con, adOpenKeyset, adLockPessimistic

and it was working 100% but now I switched to SQL Express 2005 but I want to know are I have to change the SQL statments I was using for Access or can work with SQL server.  


Question by:Mostafa_ElSadek
    LVL 33

    Expert Comment

    Basically there's not much to worry.

    But there's a difference between SQL Server and Access when it comes to dates.
    In SQL Server, we use single quotes as delimiter around date values but in Access, we use #.


    Author Comment

    ok man I'll start to change it in my application but would you please advice are the SQL Express 2005 slower than Access database for data processing.


    LVL 33

    Accepted Solution

    It's in fact faster.
    It's more scalable as well.


    Author Comment

    ok man thanks for help it is realy helped so much

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Introduction This article will provide a solution for an error that might occur installing a new SQL 2005 64-bit cluster. This article will assume that you are fully prepared to complete the installation and describes the error as it occurred durin…
    Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
    To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
    This video is in connection to the article "The case of a missing mobile phone (". It will help one to understand clearly the steps to track a lost android phone.

    779 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

    Need Help in Real-Time?

    Connect with top rated Experts

    9 Experts available now in Live!

    Get 1:1 Help Now