Mssql connection doesn't work

[CenturyBreak]

Hello! I have installed D2009 and Zeoslib_trunk_558. It is all ok with Firebird 1.5.5 and mysql. But I can't connect to mssql Server 2005.
At Delphi 11 with ZeosLib361 works well.

Error: SQL server is unavailable or does not exist. Specified SQL server not found. ConnectionOpen(CreateFile())

[0FA85B89]{ZPlain120.bpl} ZPlainDbLibDriver.TZDBLibMSSQL7PlainDriver.CheckError (Line 1212, "..\..\src\plain\ZPlainDbLibDriver.pas" + 26) + $1A
[50049AE1]{rtl120.bpl } Classes.TStrings.IndexOfName (Line 4973, "Classes.pas" + + $1D
[12BFDDA7]{ZDbc120.bpl } Zdbcdblib.TZDBLibConnection.CheckDBLibError + $3B
[12BFDA8F]{ZDbc120.bpl } Zdbcdblib.TZDBLibConnection.InternalLogin + $2C7
[12BFDE72]{ZDbc120.bpl } Zdbcdblib.TZDBLibConnection.Open + $2A
[12CD0CB3]{ZComponent120.bpl} Zconnection.TZConnection.Connect + $1E3
[12CD056D]{ZComponent120.bpl} Zconnection.TZConnection.SetConnected + $2D
[5003F57E]{rtl120.bpl } TypInfo.SetOrdProp (Line 1506, "TypInfo.pas" + 31) + $0
[20B9ACF2]{designide120.bpl} DesignEditors.TPropertyEditor.SetOrdValue (Line 838, "DesignEditors.pas" + 2) + $E
[20B9BDFB]{designide120.bpl} DesignEditors.TEnumProperty.SetValue (Line 1398, "DesignEditors.pas" + 5) + $4
[20B9A961]{designide120.bpl} DesignEditors.TPropertyEditor.Edit (Line 668, "DesignEditors.pas" + 11) + $14
[208AAFDA]{coreide120.bpl} PropInsp.TPropertyInspector.PropListEditDblClick (Line 882, "PropInsp.pas" + 20) + $5
[20C87371]{vclide120.bpl} IDEInspListBox.TInspListBox.DoEditDblClick (Line 976, "IDEInspListBox.pas" + 2) + $A
[20C88BB2]{vclide120.bpl} IDEInspListBox.TInspListBox.EditDblClick (Line 1546, "IDEInspListBox.pas" + 0) + $2
[501D1195]{vcl120.bpl } Controls.TControl.DblClick (Line 6763, "Controls.pas" + 1) + $14
[501D12F8]{vcl120.bpl } Controls.TControl.WMLButtonDblClk (Line 6806, "Controls.pas" + 4) + $C
[501D0C0E]{vcl120.bpl } Controls.TControl.WndProc (Line 6642, "Controls.pas" + 91) + $6
[501D4BF4]{vcl120.bpl } Controls.TWinControl.IsControlMouseMsg (Line 9129, "Controls.pas" + 9) + $25
[501D529B]{vcl120.bpl } Controls.TWinControl.WndProc (Line 9336, "Controls.pas" + 136) + $6
[20C86513]{vclide120.bpl} IDEInspListBox.TPropInspEdit.WndProc (Line 439, "IDEInspListBox.pas" + 7) + $4
[501D49B4]{vcl120.bpl } Controls.TWinControl.MainWndProc (Line 9065, "Controls.pas" + 3) + $6
[50058938]{rtl120.bpl } Classes.StdWndProc (Line 12723, "Classes.pas" + + $0
[501F9EC7]{vcl120.bpl } Forms.TApplication.ProcessMessage (Line 9613, "Forms.pas" + 23) + $1
[501F9F0A]{vcl120.bpl } Forms.TApplication.HandleMessage (Line 9643, "Forms.pas" + 1) + $4
[501FA235]{vcl120.bpl } Forms.TApplication.Run (Line 9780, "Forms.pas" + 26) + $3
[004259D2]{bds.exe } bds.bds (Line 196, "" + 7) + $7

[SeSchi77]

Error: SQL server is unavailable or does not exist. Specified SQL server not found. ConnectionOpen(CreateFile())

I hade the same problem as you and fixed it by changing some files.
If you like I can mail you my changed source code.

[mdaems]

Don't mail. Please, attach a diff or the changed files in the forum. I don't have mssql so I can't test it myself.

Mark

[SeSchi77]

Don't mail. Please, attach a diff or the changed files in the forum. I don't have mssql so I can't test it myself.

O.K. here my changed files.
It works on windows 7 with delphi 2010.

[mdaems]

Hi,

Thanks for the files, but I'm wondering why you had to change the component layer and the general dbc classes when the problem only occurs with mssql. As it worked before with FB and mysql we sholdn't changes their behaviour.
Isn't it sufficient to replace the ZDbcDblib* files?

Mark

[Dunnys]

Hi,

I can confirm that only replacing the ZDbcDblib* files fixes the connect error with M$ SQL Server.
Testet with Delphi 2009 (Update 3) under Wnidows 7 on SQL Server Express 2008, hope this answers your question.

Also thx. for a great DB component.

/Dunnys

[mdaems]

Thanks for the test, Dunnys.

SVN Rev. 716

Mark