Search found 4 matches
- 15.01.2015, 14:21
- Forum: ZeosLib 7.2 Forum
- Topic: Proposal for MSSQL issue getting identity column
- Replies: 5
- Views: 1217
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.
- 07.10.2013, 19:22
- Forum: ZeosLib 7.1 stable Forum
- Topic: 7.1.1-rc and SQL Server 2000
- Replies: 3
- Views: 1210
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.
the latest patch I tried is working as it should ( R2796 \testing-7.1).
Thanks to all.
- 30.09.2013, 20:04
- Forum: ZeosLib 7.1 stable Forum
- Topic: 7.1.1-rc and SQL Server 2000
- Replies: 3
- Views: 1210
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...
- 26.09.2013, 20:09
- Forum: ZeosLib 7.1 stable Forum
- Topic: 7.1.1-rc and SQL Server 2000
- Replies: 3
- Views: 1210
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',...