TMSSQLConnection - sqlDB component for accessing MS SQL Server

[ludob]

I searched for sybase session timeouts but other than the tcp keepalive timeout, which is 2 hours per default, I didn't find anything. I traced the output of the GUI that I use (based on jconnect) : it sends a "select getdate()" query about every 400 secs. This is, considering the order of magnitude, just below the 10-15 minutes timeout I'm experiencing.  I also noticed that I'm not receiving TCP Keep-Alive packages from springbok. That could be a router configuration thing anywhere between client and server.   
 

[BigChimp]

Local connection (test program using mssqlconn/freetds) is fine after about 20 minutes.
So it is probably a network thing, yes.

[Lacak2]

Thanks, I've managed to compile dblib.dll including iconv.dll; it seems to work.

Updated the readme for Visual Studio 2010, and clarified some file/download locations etc:

Code: [Select]

Compiling FreeTDS DB-Lib with MS Visual C++ 2005:
=================================================
1.   Download sources from www.freetds.org
2.   *Open FreeTDS.dsw from /win32/msvc6 source directory*


How did you open FreeTDS.dsw in VC++ 2008/2010 (Express or not ?) ?
When I try open /win32/msvc6/FreeTDS.dsw (like stated above in readme.txt) in VS2008 then I get error "Project file ... has been corrupted and cannot be opened", when in VC++ 2010 Express I get error "Project upgrade failed" (it seems be a known issue: http://connect.microsoft.com/VisualStudio/feedback/details/595054/visual-c-2010-express-cannot-open-visual-c-6-0-projects )

Of course in VC++ 2005 Express it can be opened 

[BigChimp]

<<edited>>
Freetds stable source.
Regular file open (via explorer)/VS2010Pro Service pack 1. Then it goes through the upgrade process.

I'll have a look again & I could post the .sln file (and whatever else it generates, if it's reasonable)
<<edit: mmm, posting the sln file won't help, 2010 has a new format>>

[ludob]

Opening FreeTDS.dsw from explorer with VS2008Pro -> prompt to convert project to the new format. No problems encountered.

[Lacak2]

Thanks, then problem must be related to Express versions, which I have used.

In case of 2010 it is known problem, which seems be fixed by SP1 in VS2010
In case of 2008 I do not known.

But now I have downloaded VC++ 2008 Express SP1 and all is ok (so I guess, that it was fixed in SP1)
I expect same story with VS2010 (there is also SP1 available)

[d.ioannidis]

Hi where can i find the latest sources of the TMSSQLConnection ?

[mdbs99]

Hi,
LacaK, good good job!
I'm very impressed with this project and how it progressed!

I should make some performance tests to LacaK, but I didn't do. Very sorry because that. 

Well, how I can help now? 
Do you have a SVN to get the improvements?

Thanks for share.

[Lacak2]

Hi where can i find the latest sources of the TMSSQLConnection ?

Attached ZIP (GNU libiconv2.dll is required see readme.txt for download location)
If there will be no big objections, I plan post RC2 also into bug report

[Lacak2]

LacaK, good good job!
I'm very impressed with this project and how it progressed!

Also thanks to others like Reinier and Ludo

I should make some performance tests to LacaK, but I didn't do. Very sorry because that. 

It is OK, IMO most of performance critical code is in FreeTDS (and of course in SQL Server), which we do not develop. So we have only little chance to affect overal performance on freepascal side

Do you have a SVN to get the improvements?

No, until sources will not be merged into standard freepascal fcl-db SVN ... you can send diffs to me and I will do merging manualy (If I will agree with changes  )

[BigChimp]

If there will be no big objections, I plan post RC2 also into bug report

No objections at all!

Hope it gets included into fcl-db; seems like a good way to work with SQL Server/Sybase...

[d.ioannidis]

Hi

 i get EDatabaseError 'transaction not set' if i open, close and reopen the connection.

Used a TSQLConnector, TSQLTransaction, TSQLQuery and a TButton. The TButton OnClick event have just

Code: [Select]

SQLConnector1.Connected := not SQLConnector1.Connected
Debian Squeeze amd64
FreeTDS 0.82-7
Lazarus rev. 33816 from branches/fixes_0_9_30 rev. 33816
Free Pascal from branches/fixes_2_6 rev. 19693
MS SQL Server 2005 i386

[Lacak2]

i get EDatabaseError 'transaction not set' if i open, close and reopen the connection.

IMO it is now fixed in trunk http://bugs.freepascal.org/view.php?id=20694

[mdbs99]

Hi where can i find the latest sources of the TMSSQLConnection ?

Attached ZIP (GNU libiconv2.dll is required see readme.txt for download location)
If there will be no big objections, I plan post RC2 also into bug report

I tested that new version and everything worked. 

[mdbs99]

I think I found a possible bug:
If you call StartTransaction, the DataSets on the Form are closed.
The connection still open, but you should Close/Open the DataSets to use them.