Search found 4 matches

by lrrosa
15.01.2015, 14:21
Forum: ZeosLib 7.2 Forum
Topic: Proposal for MSSQL issue getting identity column
Replies: 5
Views: 1156

Re: Proposal for MSSQL issue getting identity column

There is a global variable that returns all the information about the current version: SELECT @@VERSION And there is a function easier to parse that returns just the version number: SELECT SERVERPROPERTY('productversion') But I don't know if this second method is supported on SQL Server < 2000.
by lrrosa
07.10.2013, 19:22
Forum: ZeosLib 7.1 stable Forum
Topic: 7.1.1-rc and SQL Server 2000
Replies: 3
Views: 1154

Re: 7.1.1-rc and SQL Server 2000

Hi,
the latest patch I tried is working as it should ( R2796 \testing-7.1).
Thanks to all.
by lrrosa
30.09.2013, 20:04
Forum: ZeosLib 7.1 stable Forum
Topic: 7.1.1-rc and SQL Server 2000
Replies: 3
Views: 1154

Re: 7.1.1-rc and SQL Server 2000

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 datab...
by lrrosa
26.09.2013, 20:09
Forum: ZeosLib 7.1 stable Forum
Topic: 7.1.1-rc and SQL Server 2000
Replies: 3
Views: 1154

7.1.1-rc and SQL Server 2000

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