DBExpress and MSSQL Express (2005)

Posted on 2006-05-11
Last Modified: 2010-05-18

Since i install the MSSQL 2005 express edition, i have a problem communicating with the MSSQL... and receive an
error message 'Unable to find procedure GetSQLDriverMSSQL'

i use the code:

With SQLConnection1 do
    DriverName                  := 'MSSQL' or 'SQL Native Client'
    GetDriverFunc               := 'GetSQLDriverMSSQL';
    LibraryName                 := 'dbexpmss.dll';
    VendorLib                     := 'oledb';

    Params.Values['DriverName']   := 'SQL Native Client';
    Params.Values['DataBase']      := FenConnection.BaseDeDonnee;
    Params.Values['HostName']     := FenConnection.Serveur;
    Params.Values['User_Name']   := FenConnection.Usager;
    Params.Values['Password']      := FenConnection.MotDePasse;
    ConnectionName                     := FenConnection.NomDeConnection;
    Connected                              := true;

Any idea?
Question by:Fled
    LVL 18

    Accepted Solution

    The latest latest MS SQL Server 2005 editions, including the Express Edition will only connect natively using their new native client connections "stuff" with Microsoft's .NET 2 products only, like Visual Studio.

    However, <S SQL Server 2005 and Express Edition are downward compatgable but after installation you must allow TCP/IP connections and start the MS SQL Browser. Then you can connect to MS SQL 2005 just like MS SQL 2000 and earlier and the MSDE.

    Below is a link that show you how to do that. First older but still relevent:

    This one newer just worded a bit differently:

    Good luck!


    Author Comment


    I found the problem... my code was right, and my configuration too... but my GetSQLDriverMSSQL was not good because it is case sensitive the getSQLDriverMSSQL function work well...

    LVL 18

    Expert Comment

    Hey! Thanks for the points but I really didn't help you as I would have never thought that the call/procedure was/is case sensitive.

    Generally people have a heck of a time connecting to the new MS SQL Database with standard Delphi components becuase it is not set up to do so after installation.

    It would have been appropriate to have stated that you solved the problem yourself as you did and request that the question be closed and get your points refunded.

    Anyway, glad you found and fixed the problem.


    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    Introduction I have seen many questions in this Delphi topic area where queries in threads are needed or suggested. I know bumped into a similar need. This article will address some of the concepts when dealing with a multithreaded delphi database…
    Introduction Raise your hands if you were as upset with FireMonkey as I was when I discovered that there was no TListview.  I use TListView in almost all of my applications I've written, and I was not going to compromise by resorting to TStringGrid…
    In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

    734 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

    20 Experts available now in Live!

    Get 1:1 Help Now