Zeoslib Portal

Hi Michael, Yes it's seems that PostUpdates is not the right direction, but also CancelUpdates is not ok, i think there should be DisposeCachedUpdates (in order to only free the cached rows). If you work in AutoCommit, than ApplyUpdates call PostUpdates which copy data and free cached rows. When you...

Hi, I think there is an error inside TZAbstractDataset.CommitUpdates in ZAbstractDataSet.pas. There should be a call to CachedResultSet.PostUpdates instead of CachedResultSet.CancelUpdates. PostUpdates call PostRowUpdates(OldRowAccessor, NewRowAccessor), which will copy buffer from NewRowAccessor. I...

Hi, You can set TDSPORT environment variable : SetEnvironmentVariable('TDSPORT', '6060'); or you can export tds_config_env_tdsport, recompile freetds and use it. For FreeTDS, there should be some make files for VS and BC. If i remeber correctly, there was a version that used a TZConnection property ...

Thank you Michal. The size of the library is smaller than the 32 Bit version because is compiled with vs2010, and in the lib folder are the compiled with Borland C++ 5.5. I will make all the builds : Borland W32 MS/Syb Debug/Releas and VS2010 W32 / W64 and i will put them inside the lib folder. Bogdan

Hi,

The 1434 udp port is for SQL Browser and is not required. It is used by freeTDS if it's available.

Bogdan

Hi,

I manage to build a 64Bit dblib, put I don't have an environment in order to test it.
So I attach the file, and i will appreciate if you can let us know about the results. If it is ok, i will put all the x64 versions it inside the test\lib folder

All the best,
Bogdan

Hi, dblib is not supported for some time by microsoft. They use oledb (with ct-lib), and right now i understand that they change to odbc (starting with SQL Server 2012). This layer is for API access to SQL Server. The inner protocol is TDS with different versions. The dblib library (ntwdblib.dll) is...

Hi,

Using ntwdblib from microsoft it will limit the varchar to 256. This is a driver limitation. You can use ADO, or freeTDS in order to use varchar with more than 256 chars. It should work also with unicode data ....

Bogdan

Hi, I will have a look on the dblib. Yes you can always ask :). I just add #define MSDBLIB 1 to the Src\win32\config.h file and comment out //#define TDS42 1 and add #define TDS72 1. So the TDS Version was 72, but it should be leaved as TDS42. It took me a day to figure out that the 72 version is no...

Hi, This is my implementation for FreeTDS driver. It's base on dbLib driver with some modifications. I make some test with same basic sql and it should be fine. It will be more ease for me also if you can include it into svn. You should change WINDOWS_DLL_LOCATION inside ZPlainFreeTDS with dblib_dll...

I make a little modification in order to handle 3 parts name into from clause.
Right now it dosen't work on dbname.schamename.tablename.

I test with :
dbname.schamename.tablename
dbname..tablename
.schamename.tablename
schamename.tablename
tablename
..tablename

Hi, You can try to creat the table using something like : create table test (column varchar) ... SqLite dosen't care about the type name of the field so you can write anything there. After that the Zeos will handle the type that you enter into the create table statement using pragma table_info(tblNa...

Also the patch file for the ZPlainDbLibDriver.pas

Hi, This are the modified files. There are little modifications. For ZPlainDbLibDriver.pas it should be ok, for the MetaData, as far as i so, in the cvs version this problem ( the one with invalid column name) not exists any more, because a diffrent approach. I put also the modified file for the ZEO...

Hi Mark, Sorry for this late response. I will pack the file and post it here. I will configure the SVN and try to use it for future, but right now I'm a little bit busy. I use thi excelent library (ver. 6.1.5) for some time on the mssql without a problem and now I try to port some application to ver...