Re: freetds and mssql 2008 with name instance and dynamic port allocation?

On Jul 16, 2010, at 20:22, Lukasz Szybalski wrote:

>> Server          = servername
>> Instance = instancename_production
>> What are my options here at this point?

Here's the documentation on the ODBC options:
http://www.freetds.org/userguide/odbcconnattr.htm

So it seems to say that if you want to have an ODBC-only configuration, you'll have to specify the instance name by appending it to the Server option.

Server = servername\instancename_production

> How is freetds discovering the port location, when using dynamic ports, and how do I set it up?

It's using UDP on port 1434.