[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1186
  • Last Modified:

DBExpress and MSSQL Express (2005)

Hi,

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
begin
    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;
end;

Any idea?
Thanks
0
Fled
Asked:
Fled
  • 2
1 Solution
 
JohnjcesCommented:
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:
http://blogs.msdn.com/sqlexpress/archive/2004/07/23/192044.aspx

This one newer just worded a bit differently:
http://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx

Good luck!

John
0
 
FledAuthor Commented:
Hi,

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...

Thanks
0
 
JohnjcesCommented:
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.

John
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now