Zeoslib Portal

I'm intensively using Zeos in my everyday work with MS SQL Server. To this day I have used the ntwdblib.dll, but recently I started to port my software to Linux. Therefore I'm forced to use FreeTDS. Suddenly after switching to FreeTDS my stored procedures stopped working with errors about missing pa...

Okay, so the problem exists with access to "master" database. The MS SQL parser allows maximum of 3 prefixes, so when it sees something like master.INFORMATION_SCHEMA.COLUMNS it thinks that "master" is the identifier of linked server object. I've managed to overcome this issue by...

Damn it! Yes, select * from INFORMATION_SCHEMA. will not work. It seems that when the Catalog = 'INFORMATION_SCHEMA' the call to "sp_*" procedures should be executed without the "INFORMATION_SCHEMA" context. So this is an exception. I wonder if there are more such exceptions ther...

Excellent! I hope someone will benefit from this patch also. :) At my local Zeos installation i've changed all the "sp_*" calls except these: exec sp_databases exec sp_datatype_info exec sp_jdbc_getschemas exec sp_jdbc_getcatalogs exec sp_jdbc_datatype_info By now everything seems to be ok...

Thanks for your concern. I'll try to examine the Zeos source to find sp_*, but generally yes, I think, all system stored procedures should be called within proper context. This does not hurt and should fix other potential problems. My patch is quick and dirty and does not work with canonical MS SQL ...

Hi. Recently I've begun to port some old, but very large desktop application from Borland C++ Builder to Lazarus. I've found the Zeoslib only component library suitable for replacing proprietary SQLDirect. I've ported the code to Delphi (with fantastic Perl script), then made it work, then moved to ...