[Mono-list] MSSQL from Linux using Mono - Error

[tsureshkumar]

Daniel Waterbly wrote:
> Hello,
> 
>    I have been trying all day and night to connect to a MS SQL Server
> database from my redhat linux box.  I can connect just fine to a MySQL
> database, but it just won't fly with a MSSQL database.  Here is the code I
> am using:
>                string connectionString = 
> "server=<SERVER'SIP>;database=<DATABASE>;uid=<USER>;password=<PASSWORD>;";
> 
> Everything compiles fine and it runs just grand from my Windows XP box, but
> when I try mono sql.exe I get this:
> 
> Unhandled Exception: System.Net.Sockets.SocketException: Invalid arguments
> in <0x00208> System.Net.Sockets.Socket:Connect (System.Net.EndPoint
> remote_end)

looks like the MSSQL server is not reachable from your linux box. if you 
are using server's name in the connection string, check the DNS 
configuration.  Check by directly giving the IP address of the server in 
the connection string.

Are you using MSSQL server instance by any chance?

suresh.