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

[Daniel Waterbly]

Suresh,

    Thanks for the tip.  I am however using the direct IP address to the 
server, and yes, it is connecting to a MSSQL server instance.

    -Dan Waterbly

----- Original Message ----- 
From: "tsureshkumar" <tsureshkumar at novell.com>
To: "Daniel Waterbly" <dwaterbly at msn.com>
Cc: <mono-list at lists.ximian.com>
Sent: Friday, June 24, 2005 1:49 AM
Subject: Re: [Mono-list] MSSQL from Linux using Mono - Error


> 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.
>