|
SQL Server 2005 Support
|
|
 Re: SQL Server 2005 Support
Hi Bokarius,
On Fri, 2007-12-14 at 02:52 -0800, Konstantin Bokarius wrote:
> Does Mono have SQL Server 2005 support yet? Which SQL Client
> available today would be the best bet?
>
SQLServer 2005 is yet to be supported in Mono and all prior versions are
very much supported.
V. Varadhan
--
Veerapuram Varadhan < vvaradhan@...>
_______________________________________________
Mono-list maillist - Mono-list@...
http://lists.ximian.com/mailman/listinfo/mono-list
|
|
Re: SQL Server 2005 Support
|
|
Re: SQL Server 2005 Support
|
|
Re: SQL Server 2005 Support
What does your connection string look like? I had to use the port number to connect. My connection string looks like this: Net=dbmssocn;Server=xxx.xxx.xx.xxx, 1226;Database=[mydatabase];User ID=[myusername];Password=[mypassword];
where the x's are my ip address and 1226 is the port
_______________________________________________
Mono-list maillist - Mono-list@...
http://lists.ximian.com/mailman/listinfo/mono-list
|
|
Re: SQL Server 2005 Support
Some parts of this message have been removed.
Learn more about Nabble's security policy.
Here is my code:
private static string strConnect = "Server=10.10.1.152;"
+
"Database=TESTDB;" +
"User ID=userid;" +
"Password=pwd;";
private static SqlConnection dbCon;
private static IDbCommand dbCmd;
private static IDataReader dbReader;
...
dbCon = new
SqlConnection(strConnect);
dbCon.Open();
Here is the error I get:
Unhandled Exception: System.Data.SqlClient.SqlException: Server does not exist
or connection refused. ---> Mono.Data.Tds.Protocol.TdsInternalException:
Server does not exist or connection refused. --->
System.Net.Sockets.SocketException: Connection refused
at System.Net.Sockets.Socket.Connect (System.Net.EndPoint remote_end)
[0x00000]
at Mono.Data.Tds.Protocol.TdsComm..ctor (System.String dataSource, Int32
port, Int32 packetSize, Int32 timeout, TdsVersion tdsVersion) [0x00000] --- End
of inner exception stack trace ---
I have tried specifying the port (1433) and using Net=dbmssocn; and I still get
the same error.
What does your connection
string look like? I had to use the port number to connect. My connection string
looks like this:
Net=dbmssocn;Server=xxx.xxx.xx.xxx, 1226;Database=[mydatabase];User ID=[myusername];Password=[mypassword];
where the x's are my ip address and 1226 is the port
_______________________________________________
Mono-list maillist - Mono-list@...
http://lists.ximian.com/mailman/listinfo/mono-list
|
|
Re: SQL Server 2005 Support
Hi, It looks like either the service is not running in the default port or its protected with firewall. Thanks Nagappan On Dec 15, 2007 5:37 PM, Konstantin Bokarius < bokarius@...> wrote:
Here is my code:
private static string strConnect = "Server=10.10.1.152;"
+
"Database=TESTDB;" +
"User ID=userid;" +
"Password=pwd;";
private static SqlConnection dbCon;
private static IDbCommand dbCmd;
private static IDataReader dbReader;
...
dbCon = new
SqlConnection(strConnect);
dbCon.Open();
Here is the error I get:
Unhandled Exception: System.Data.SqlClient.SqlException: Server does not exist
or connection refused. ---> Mono.Data.Tds.Protocol.TdsInternalException:
Server does not exist or connection refused. --->
System.Net.Sockets.SocketException: Connection refused
at System.Net.Sockets.Socket.Connect (System.Net.EndPoint remote_end)
[0x00000]
at Mono.Data.Tds.Protocol.TdsComm..ctor (System.String dataSource, Int32
port, Int32 packetSize, Int32 timeout, TdsVersion tdsVersion) [0x00000] --- End
of inner exception stack trace ---
I have tried specifying the port (1433) and using Net=dbmssocn; and I still get
the same error.
What does your connection
string look like? I had to use the port number to connect. My connection string
looks like this:
Net=dbmssocn;Server=xxx.xxx.xx.xxx, 1226;Database=[mydatabase];User ID=[myusername];Password=[mypassword];
where the x's are my ip address and 1226 is the port
_______________________________________________
Mono-list maillist - Mono-list@...
http://lists.ximian.com/mailman/listinfo/mono-list
-- Linux Desktop Testing Project - http://ldtp.freedesktop.org
http://nagappanal.blogspot.com
_______________________________________________
Mono-list maillist - Mono-list@...
http://lists.ximian.com/mailman/listinfo/mono-list
|
|
Re: SQL Server 2005 Support
Some parts of this message have been removed.
Learn more about Nabble's security policy.
The service is running and it is not protected by a firewall as
I can telnet to port 1433 on 10.10.1.152 from the system running Mono.
When I change the connect string to connect to 10.10.1.150 running
an older version of MS SQL it works fine, only when I point it to 10.10.1.152 MS
SQL 2005 do I see the error.
From: Nagappan A
[mailto:nagappan@...]
Sent: Saturday, December 15, 2007 8:45 PM
To: Konstantin Bokarius
Cc: Austin Winstanley; Mono-list@...
Subject: Re: [Mono-list] SQL Server 2005 Support
Hi,
It looks like either the service is not running in the default port or its
protected with firewall.
Thanks
Nagappan
On Dec 15, 2007 5:37 PM, Konstantin Bokarius <bokarius@...> wrote:
Here is my code:
private static string strConnect =
"Server=10.10.1.152;"
+
"Database=TESTDB;" +
"User ID=userid;" +
"Password=pwd;";
private static SqlConnection dbCon;
private static IDbCommand dbCmd;
private static IDataReader dbReader;
...
dbCon = new SqlConnection(strConnect);
dbCon.Open();
Here is the error I get:
Unhandled Exception: System.Data.SqlClient.SqlException: Server does not exist
or connection refused. ---> Mono.Data.Tds.Protocol.TdsInternalException:
Server does not exist or connection refused. --->
System.Net.Sockets.SocketException: Connection refused
at System.Net.Sockets.Socket.Connect (System.Net.EndPoint remote_end)
[0x00000]
at Mono.Data.Tds.Protocol.TdsComm..ctor (System.String dataSource, Int32
port, Int32 packetSize, Int32 timeout, TdsVersion tdsVersion) [0x00000] --- End
of inner exception stack trace ---
I have tried specifying the port (1433) and using Net=dbmssocn; and I still get
the same error.
What does your connection string look like? I
had to use the port number to connect. My connection string looks like this:
Net=dbmssocn;Server=xxx.xxx.xx.xxx, 1226;Database=[mydatabase];User
ID=[myusername];Password=[mypassword];
where the x's are my ip address and 1226 is the port
_______________________________________________
Mono-list maillist - Mono-list@...
http://lists.ximian.com/mailman/listinfo/mono-list
--
Linux Desktop Testing Project - http://ldtp.freedesktop.org
http://nagappanal.blogspot.com
_______________________________________________
Mono-list maillist - Mono-list@...
http://lists.ximian.com/mailman/listinfo/mono-list
|
|
Re: SQL Server 2005 Support
try port 1226 On Dec 16, 2007 4:33 PM, Konstantin Bokarius < bokarius@...> wrote:
The service is running and it is not protected by a firewall as
I can telnet to port 1433 on 10.10.1.152 from the system running Mono.
When I change the connect string to connect to 10.10.1.150 running
an older version of MS SQL it works fine, only when I point it to 10.10.1.152 MS
SQL 2005 do I see the error.
From: Nagappan A
[mailto:nagappan@...]
Sent: Saturday, December 15, 2007 8:45 PM
To: Konstantin Bokarius
Cc: Austin Winstanley; Mono-list@...
Subject: Re: [Mono-list] SQL Server 2005 Support
Hi,
It looks like either the service is not running in the default port or its
protected with firewall.
Thanks
Nagappan
On Dec 15, 2007 5:37 PM, Konstantin Bokarius <bokarius@...> wrote:
Here is my code:
private static string strConnect =
"Server=10.10.1.152;"
+
"Database=TESTDB;" +
"User ID=userid;" +
"Password=pwd;";
private static SqlConnection dbCon;
private static IDbCommand dbCmd;
private static IDataReader dbReader;
...
dbCon = new SqlConnection(strConnect);
dbCon.Open();
Here is the error I get:
Unhandled Exception: System.Data.SqlClient.SqlException: Server does not exist
or connection refused. ---> Mono.Data.Tds.Protocol.TdsInternalException:
Server does not exist or connection refused. --->
System.Net.Sockets.SocketException: Connection refused
at System.Net.Sockets.Socket.Connect (System.Net.EndPoint remote_end)
[0x00000]
at Mono.Data.Tds.Protocol.TdsComm..ctor (System.String dataSource, Int32
port, Int32 packetSize, Int32 timeout, TdsVersion tdsVersion) [0x00000] --- End
of inner exception stack trace ---
I have tried specifying the port (1433) and using Net=dbmssocn; and I still get
the same error.
What does your connection string look like? I
had to use the port number to connect. My connection string looks like this:
Net=dbmssocn;Server=xxx.xxx.xx.xxx, 1226;Database=[mydatabase];User
ID=[myusername];Password=[mypassword];
where the x's are my ip address and 1226 is the port
_______________________________________________
Mono-list maillist - Mono-list@...
http://lists.ximian.com/mailman/listinfo/mono-list
--
Linux Desktop Testing Project - http://ldtp.freedesktop.org
http://nagappanal.blogspot.com
_______________________________________________
Mono-list maillist - Mono-list@...
http://lists.ximian.com/mailman/listinfo/mono-list
|
|
Re: SQL Server 2005 Support
I recall one MS SQL 2005 I installed needed to be configured to allow remote connections. On Dec 16, 2007 4:33 PM, Konstantin Bokarius < bokarius@...> wrote:
The service is running and it is not protected by a firewall as
I can telnet to port 1433 on 10.10.1.152 from the system running Mono.
When I change the connect string to connect to 10.10.1.150 running
an older version of MS SQL it works fine, only when I point it to 10.10.1.152 MS
SQL 2005 do I see the error.
From: Nagappan A
[mailto:nagappan@...]
Sent: Saturday, December 15, 2007 8:45 PM
To: Konstantin Bokarius
Cc: Austin Winstanley; Mono-list@...
Subject: Re: [Mono-list] SQL Server 2005 Support
Hi,
It looks like either the service is not running in the default port or its
protected with firewall.
Thanks
Nagappan
On Dec 15, 2007 5:37 PM, Konstantin Bokarius <bokarius@...> wrote:
Here is my code:
private static string strConnect =
"Server=10.10.1.152;"
+
"Database=TESTDB;" +
"User ID=userid;" +
"Password=pwd;";
private static SqlConnection dbCon;
private static IDbCommand dbCmd;
private static IDataReader dbReader;
...
dbCon = new SqlConnection(strConnect);
dbCon.Open();
Here is the error I get:
Unhandled Exception: System.Data.SqlClient.SqlException: Server does not exist
or connection refused. ---> Mono.Data.Tds.Protocol.TdsInternalException:
Server does not exist or connection refused. --->
System.Net.Sockets.SocketException: Connection refused
at System.Net.Sockets.Socket.Connect (System.Net.EndPoint remote_end)
[0x00000]
at Mono.Data.Tds.Protocol.TdsComm..ctor (System.String dataSource, Int32
port, Int32 packetSize, Int32 timeout, TdsVersion tdsVersion) [0x00000] --- End
of inner exception stack trace ---
I have tried specifying the port (1433) and using Net=dbmssocn; and I still get
the same error.
What does your connection string look like? I
had to use the port number to connect. My connection string looks like this:
Net=dbmssocn;Server=xxx.xxx.xx.xxx, 1226;Database=[mydatabase];User
ID=[myusername];Password=[mypassword];
where the x's are my ip address and 1226 is the port
_______________________________________________
Mono-list maillist - Mono-list@...
http://lists.ximian.com/mailman/listinfo/mono-list
--
Linux Desktop Testing Project - http://ldtp.freedesktop.org
http://nagappanal.blogspot.com
_______________________________________________
Mono-list maillist - Mono-list@...
http://lists.ximian.com/mailman/listinfo/mono-list
_______________________________________________
Mono-list maillist - Mono-list@...
http://lists.ximian.com/mailman/listinfo/mono-list
|
|
Re: SQL Server 2005 Support
Is SQL 2005 (TDS 8) now supported in Mono 1.9.1? I ask because I am experiencing problems using bigint datatypes in ADO.NET. I believe this problem was reported in 2005 as an incompatibility between Mono's SqlClient (TDS 7.0) and TDS 8.0 in SQL Server, but a patch was posted. Was this patch applied to the trunk.
Thanks!
|
|
Re: SQL Server 2005 Support
|
