[Mono-list] Connecting Remote SQL Server through C#

[sarim shah]

Hi........... V. Varadhan

Thanks for your corporate.

as per your requirement i am sending you the detail as you required below. 

1 we are using MSSQL server 2005
2 mono version is 1.9.1
3 yes remote connection is enabled in the server
4 yes ip is resolving and we have connected through MSSQL ODBC.

and you can see below program code.....	

SqlConnection v_objCon;

        

v_objCon = new SqlConnection("Server=SVR-DB-SQL,1433;Initial
Catalog=TestDB;UserID=sa;Password=dbPass");

       try

        {

        	v_objCon.Open();

                v_objCon.Close();

                v_objCon.Dispose();

                MessageBox.Show("DB Connection test Successfull!");

        }

        catch (Exception l_objex)

            {

                ..
		..

            }

 

Veerapuram Varadhan wrote:
> 
> Hi Sarim,
> 
> On Tue, 2009-06-09 at 04:53 -0700, sarim shah wrote:
>> I have a c# application which needs to connect with MSSQL Server remotely
>> from linux through mono, but I am having the following error;
>> 
>> "server does not exist or connection refused".
>> 
>> There seems to be no connectivity issue as I've tried creating a DSN
>> using
>> easysoft ODBC which was connected successfully to that remote MSSQL
>> Server.
>> Can I use that DSN with my existing C# application?
> 
> 1) Which version of MSSQL server that you are trying to connect to?  
> 2) Which version of mono are you running?  
> 3) Is remote-connection enabled in the server?
> 4) Is server-hostname/ip resolvable from the linux box?
> 5) Can you attach a simple program that gives you this error?
> 
> 
> V. Varadhan
> 
> _______________________________________________
> Mono-list maillist  -  Mono-list at lists.ximian.com
> http://lists.ximian.com/mailman/listinfo/mono-list
> 
> 

-- 
View this message in context: http://www.nabble.com/Connecting-Remote-SQL-Server-through-C--tp23941326p23978282.html
Sent from the Mono - General mailing list archive at Nabble.com.