MsSQL FreeTDS With Azure Connect

The BETA tester's forum for ZeosLib 7.2 Report problems. Ask for help, post proposals for the new version and Zeoslib 7.2 features here. This is a forum that will be edited once the 7.2.x version goes into RC/stable!!

My personal intention for 7.2 is to speed up the internals as optimal a possible for all IDE's. Hope you can help?! Have fun with testing 7.2
rzsistemas
Fresh Boarder
Fresh Boarder
Posts: 6
Joined: 21.04.2013, 18:21

MsSQL FreeTDS With Azure Connect

Postby rzsistemas » 01.07.2015, 01:32

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 connection to connect to a different database.

In microsoft I found https://msdn.microsoft.com/en-us/librar ... 36282.aspx

Transact-SQL statements

The Transact-SQL USE command is not currently supported for switching between databases. Establish a connection directly to the target database.

in ZDBCDbLib i Found
procedure TZDBLibConnection.Open;
var
LogMessage: RawByteString;
begin
if not Closed then
Exit;

InternalLogin;

LogMessage := 'USE '+ ConSettings^.Database;

---
How I can conect to azure database ?

Return to “ZeosLib 7.2 Betatest Forum”

Who is online

Users browsing this forum: No registered users and 1 guest