7.1.1-rc and SQL Server 2000

[lrrosa]

Hi,
I'm trying to connect to SQL Server 2000 using TZConnection (Zeoslib 7.1.1-rc and Delphi XE2), but always get the same error about invalid table 'sys.syslanguages'.
In SQL Server 2000 this table is called just 'syslanguages' (without sys.).
I tried the protocols 'mssql' and 'FreeTDS_MsSQL-2000', with the exact same result.
Does anyone know other tests I could do?

Here's the error the SQL server returns when connecting:
-------------------------------------------------------------
DBError : [10007] : General SQL Server error : Check messages from the SQL Server.
Invalid object name 'sys.syslanguages'..

Error details:
----------------

Code: Select all

[217829F3]{ZPlain160.bpl} ZPlainDbLibDriver.TZDBLibAbstractPlainDriver.CheckError$qqrpv (Line 653, "ZPlainDbLibDriver.pas" + 32) + $F
[2244E14C]{ZDbc160.bpl } ZDbcDbLib.TZDBLibConnection.CheckDBLibError$qqr29Zdbclogging.TZLoggingCategoryx20System.UnicodeString (Line 406, "ZDbcDbLib.pas" + 2) + $16
[2243C575]{ZDbc160.bpl } ZDbcDbLibStatement.TZDBLibStatement.InternalExecuteStatement$qqr31System.%AnsiStringT$us$i65535$% (Line 224, "ZDbcDbLibStatement.pas" + 17) + $13
[2243CB11]{ZDbc160.bpl } ZDbcDbLibStatement.TZDBLibStatement.ExecuteQuery$qqrx31System.%AnsiStringT$us$i65535$% (Line 343, "ZDbcDbLibStatement.pas" + 5) + $9
[22434021]{ZDbc160.bpl } ZDbcStatement.TZAbstractStatement.ExecuteQuery$qqrx20System.UnicodeString (Line 520, "ZDbcStatement.pas" + 2) + $E
[2244EA59]{ZDbc160.bpl } ZDbcDbLib.TZDBLibConnection.DetermineMSDateFormat$qqrv (Line 639, "ZDbcDbLib.pas" + 2) + $D
[2244E4AB]{ZDbc160.bpl } ZDbcDbLib.TZDBLibConnection.Open$qqrv (Line 473, "ZDbcDbLib.pas" + 39) + $3
[231DC1CA]{ZComponent160.bpl} ZAbstractConnection.TZAbstractConnection.Connect$qqrv (Line 858, "ZAbstractConnection.pas" + 44) + $5
[231DB910]{ZComponent160.bpl} ZAbstractConnection.TZAbstractConnection.SetConnected$qqro (Line 510, "ZAbstractConnection.pas" + 8) + $5
[5008C726]{rtl160.bpl  } System.TypInfo.SetOrdProp (Line 2109, "System.TypInfo.pas" + 33) + $0
[20FABF0E]{designide160.bpl} DesignEditors.TPropertyEditor.SetOrdValue (Line 839, "DesignEditors.pas" + 2) + $E
[20FF233B]{designide160.bpl} VCLEditors.TBooleanProperty.MouseUp (Line 1843, "VCLEditors.pas" + 5) + $10
[2111A8B5]{vclide160.bpl} PropBox.TCustomPropListBox.ItemMouseUp (Line 1629, "PropBox.pas" + 16) + $1B
[2111AAAB]{vclide160.bpl} PropBox.TCustomPropListBox.MouseUp (Line 1694, "PropBox.pas" + 1) + $D
[50333324]{vcl160.bpl  } Vcl.Controls.TControl.DoMouseUp (Line 7448, "Vcl.Controls.pas" + 2) + $28
[503333A0]{vcl160.bpl  } Vcl.Controls.TControl.WMLButtonUp (Line 7461, "Vcl.Controls.pas" + 9) + $6
[21120224]{vclide160.bpl} IDEInspListBox.TInspListBox.WMLButtonUp (Line 1632, "IDEInspListBox.pas" + 3) + $4
[50332995]{vcl160.bpl  } Vcl.Controls.TControl.WndProc (Line 7204, "Vcl.Controls.pas" + 91) + $6
[50336B3B]{vcl160.bpl  } Vcl.Controls.TWinControl.IsControlMouseMsg (Line 9745, "Vcl.Controls.pas" + 1) + $9
[503372F3]{vcl160.bpl  } Vcl.Controls.TWinControl.WndProc (Line 9976, "Vcl.Controls.pas" + 152) + $6
[5035A413]{vcl160.bpl  } Vcl.StdCtrls.TCustomListBox.WndProc (Line 6918, "Vcl.StdCtrls.pas" + 55) + $5
[50336948]{vcl160.bpl  } Vcl.Controls.TWinControl.MainWndProc (Line 9689, "Vcl.Controls.pas" + 3) + $6
[500B6890]{rtl160.bpl  } System.Classes.StdWndProc (Line 13878, "System.Classes.pas" + 8) + $0
[50454598]{vcl160.bpl  } Vcl.Forms.TApplication.CancelHint (Line 10993, "Vcl.Forms.pas" + 6) + $7
[50453213]{vcl160.bpl  } Vcl.Forms.TApplication.ProcessMessage (Line 10164, "Vcl.Forms.pas" + 23) + $1
[50453256]{vcl160.bpl  } Vcl.Forms.TApplication.HandleMessage (Line 10194, "Vcl.Forms.pas" + 1) + $4
[50453595]{vcl160.bpl  } Vcl.Forms.TApplication.Run (Line 10332, "Vcl.Forms.pas" + 26) + $3

[EgonHugeist]

Thanks for the hint. I've testet the date-format determination without the sys schema. Works fine with MSSQL2012 too.

Patch done R2760 \testing-7.1 (SVN).

[lrrosa]

Thanks for your reply, Michael.
I downloaded R2770 \testing-7.1 to test the patch.

Now it only works when I connect to database 'master'.
If I try to connect to any other database it still shows the error "invalid object name 'syslanguages' ".

I think this view works independently of database in MSSql 2005+. But in MSSql 2000 it's just a table and is dependent of 'master' database (master.dbo.syslanguages).

[lrrosa]

Hi,
the latest patch I tried is working as it should ( R2796 \testing-7.1).
Thanks to all.