Search found 6 matches

by rzsistemas
01.07.2015, 01:32
Forum: ZeosLib 7.2 Forum
Topic: MsSQL FreeTDS With Azure Connect
Replies: 9
Views: 1605

MsSQL FreeTDS With Azure Connect

I use a dbLib to conect with SQL server and FreeTDS_MsSQL-7.0. This is working so far. But when I connect to azure i get the follow error: DBError : [40508] : General SQL Server error: Check messages from the SQL Server USE statement is not supported to switch between databases. Use a new connectio...
by rzsistemas
29.11.2014, 16:14
Forum: ZeosLib 7.1 stable Forum
Topic: FreeTDS with mssql 2008 connect on different port at 1433
Replies: 3
Views: 1050

Re: FreeTDS with mssql 2008 connect on different port at 143

"rautgigi" say: { 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 u...
by rzsistemas
27.06.2014, 01:00
Forum: ZeosLib 7.1 stable Forum
Topic: FreeTDS with mssql 2008 connect on different port at 1433
Replies: 3
Views: 1050

FreeTDS with mssql 2008 connect on different port at 1433

I get connect in SQL server 2008 with port 1433 over internet. But if i Try connect with diferrent port like(6060) for example over internet i Get the follow error:unable to conect adptative server is unavaliable. Unknow error i get connect over internet on port 6060 with "microsoft SQL manager...
by rzsistemas
30.11.2013, 01:32
Forum: ZeosLib 7.1 stable Forum
Topic: FreeTDS_MsSQL>=2005 connect on different port at 1433
Replies: 0
Views: 948

FreeTDS_MsSQL>=2005 connect on different port at 1433

I get connect in SQL server 2008 with port 1433. But if i Try connect with diferrent port (5001) for example over internet i Get the follow error:unable to conect adptative server is unavaliable. Unknow error i get connect over internet on port 5001 with "microsoft SQL manager studio" but ...
by rzsistemas
16.07.2013, 13:55
Forum: MS SQL Server
Topic: FreeTDS_MsSQL>=2005 + setting Connection timeout
Replies: 2
Views: 2444

before this post I try with this setting but don't work. I try timeout=2000 and time out=2000 but zeos try connect forever, I use Free DTS
by rzsistemas
21.04.2013, 18:30
Forum: MS SQL Server
Topic: FreeTDS_MsSQL>=2005 + setting Connection timeout
Replies: 2
Views: 2444

FreeTDS_MsSQL>=2005 + setting Connection timeout

I using FreeTDS_MsSQL>=2005 to connect with msSQL 2012 , and Works fine, but i need setup a timeout for this connections, how can i do it ?