HomeFlySpeed SQL QueryConnection problem to MSSQL server since version 2.9.4

Connection problem to MSSQL server since version 2.9.4


Hi people,

today I updated my Flyspeed SQL Query Tool to version 2.9.4

And now I can't connect to my MSSQL server with the native MSSQL driver. Everytime I try to connect, I reveive the following message: [AnyDAC][Phys][ODBC][Microsoft][ODBC Driver Manager] Der Datenquellenname wurde nicht gefunden, und es wurde kein Standardtreiber angegeben (translated: Data source name not found and no standard driver named.)

Connecting with the general ODBC driver, the problem does not occur.

What can be done to solve the problem?


Best regards
Joerg
Joerg Kreusel | email
August 24 2011, 09:08 AM
Open the Connection Properties dialog and change Connection type from "MS SQL Server" to "Generic ADO connection", after that set "MS SQL Server (TransactSQL)" value for the SQL Syntax option. After that define the rest of connection options via the Connection String (on clicking the Ellipsis button you will be able to define them via standard Link Options dialog).
Sergey Smagin | email
1 week since original post
Seems the problem is solved! First tests running succesfully! Famous.
If any other problems will occur, I let you know.

Best regards
Joerg
Joerg Kreusel | email
1 week since original post
This topic is closed