 | |
#41
 
| |||
| |||
|
Re: problem with connecting to sql server via a wireless applicati -
02-28-2008
, 04:50 PM
|
Sorry. I don't know much about Visual Studio. My only other suggestion is to turn on the SQL Server Browser Service on the SQL Server computer. SQL Server Express listens on dynamic ports, and it's possible it is not using port 1433. Remove ",1433" from the string, and the Browser Service should provide the correct port, if it's not 1433. -- Rick Byham (MSFT) This posting is provided "AS IS" with no warranties, and confers no rights. "Hezal" <Hezal (AT) discussions (DOT) microsoft.com> wrote in message news:FB510836-1F18-4FDD-AEE3-E962DB82B325 (AT) microsoft (DOT) com... The string is automatically created by visual studio therefore when I remove one slash it complains about unrecognised escape sequence.. "Rick Byham, (MSFT)" wrote: You have too many slashes. HEZAL-PC\\SQLEXPRESS should be HEZAL-PC\SQLEXPRESS -- Rick Byham (MSFT) This posting is provided "AS IS" with no warranties, and confers no rights. "Hezal" <Hezal (AT) discussions (DOT) microsoft.com> wrote in message news:1F5FCD5E-80FB-4C7E-A6A7-4770790B8A3E (AT) microsoft (DOT) com... Hi, I have created a SQL Server 2005 database in VS 2005 and I am using windows mobile to access directly to SQL Server. I use Vista and Windows Mobile device centre for the connection between the device and the PC. I have enabled remote connections for TCP/IP and named pipes. I have also checked the firewall settings and made an exception for sqlsrv.exe Building it is fine but When I debug the application, the status says deployed successfully then it gives me the following error : SqlException was unhandled- int returnValue = this.Adapter.Fill(dataTable); When I comment out the line that calls this 'Fill' method the It displays the column heading but no data in it off course.. So I am very confused whether this is a connection error or not... The code is automatically generated by visual studio. The connection string I use is: "Data Source=HEZAL-PC\\SQLEXPRESS,1433;Initial Catalog=MEDITERRANEAN _RESTAURANT_MANAGEMENT;Integrated Security=True;" Here is the stack trace: at System.Data.SqlClient.SqlConnection.get_ServerVers ion() at System.Data.SqlClient.SqlConnection.Open() at System.Data.Common.DbDataAdapter.QuietOpen() at System.Data.Common.DbDataAdapter.FillInternal() at System.Data.Common.DbDataAdapter.Fill() at System.Data.Common.DbDataAdapter.Fill() at Orders.MEDITERRANEAN__RESTAURANT_MANAGEMENTDataSet 1TableAdapters.Customer_DetailsTableAdapter.Fill() at Orders.Form1.Form1_Load() at System.Windows.Forms.Form.OnLoad() at System.Windows.Forms.Form._SetVisibleNotify() at System.Windows.Forms.Control.set_Visible() at System.Windows.Forms.Application.Run() at Orders.Program.Main() Sorry for the information overload.. I need some help urgently as I have spent days reading searching but nothing helped  Can anyone help me please? Thanks |
#42
| |||
| |||
|
Thanks for the reply Rick. I appreciate it  I tried your suggestion but it still gives error. I realised while debugging the following message: "SQL Server does not exist or access denied." "Rick Byham, (MSFT)" wrote: Sorry. I don't know much about Visual Studio. My only other suggestion is to turn on the SQL Server Browser Service on the SQL Server computer. SQL Server Express listens on dynamic ports, and it's possible it is not using port 1433. Remove ",1433" from the string, and the Browser Service should provide the correct port, if it's not 1433. -- Rick Byham (MSFT) This posting is provided "AS IS" with no warranties, and confers no rights. "Hezal" <Hezal (AT) discussions (DOT) microsoft.com> wrote in message news:FB510836-1F18-4FDD-AEE3-E962DB82B325 (AT) microsoft (DOT) com... The string is automatically created by visual studio therefore when I remove one slash it complains about unrecognised escape sequence.. "Rick Byham, (MSFT)" wrote: You have too many slashes. HEZAL-PC\\SQLEXPRESS should be HEZAL-PC\SQLEXPRESS -- Rick Byham (MSFT) This posting is provided "AS IS" with no warranties, and confers no rights. "Hezal" <Hezal (AT) discussions (DOT) microsoft.com> wrote in message news:1F5FCD5E-80FB-4C7E-A6A7-4770790B8A3E (AT) microsoft (DOT) com... Hi, I have created a SQL Server 2005 database in VS 2005 and I am using windows mobile to access directly to SQL Server. I use Vista and Windows Mobile device centre for the connection between the device and the PC. I have enabled remote connections for TCP/IP and named pipes. I have also checked the firewall settings and made an exception for sqlsrv.exe Building it is fine but When I debug the application, the status says deployed successfully then it gives me the following error : SqlException was unhandled- int returnValue = this.Adapter.Fill(dataTable); When I comment out the line that calls this 'Fill' method the It displays the column heading but no data in it off course.. So I am very confused whether this is a connection error or not... The code is automatically generated by visual studio. The connection string I use is: "Data Source=HEZAL-PC\\SQLEXPRESS,1433;Initial Catalog=MEDITERRANEAN _RESTAURANT_MANAGEMENT;Integrated Security=True;" Here is the stack trace: at System.Data.SqlClient.SqlConnection.get_ServerVers ion() at System.Data.SqlClient.SqlConnection.Open() at System.Data.Common.DbDataAdapter.QuietOpen() at System.Data.Common.DbDataAdapter.FillInternal() at System.Data.Common.DbDataAdapter.Fill() at System.Data.Common.DbDataAdapter.Fill() at Orders.MEDITERRANEAN__RESTAURANT_MANAGEMENTDataSet 1TableAdapters.Customer_DetailsTableAdapter.Fill() at Orders.Form1.Form1_Load() at System.Windows.Forms.Form.OnLoad() at System.Windows.Forms.Form._SetVisibleNotify() at System.Windows.Forms.Control.set_Visible() at System.Windows.Forms.Application.Run() at Orders.Program.Main() Sorry for the information overload.. I need some help urgently as I have spent days reading searching but nothing helped Can anyone help me please? Thanks |
#43
| |||
| |||
|
|
Thanks for the reply Rick. I appreciate it I tried your suggestion but it still gives error. I realised while debugging the following message: "SQL Server does not exist or access denied." "Rick Byham, (MSFT)" wrote: Sorry. I don't know much about Visual Studio. My only other suggestion is to turn on the SQL Server Browser Service on the SQL Server computer. SQL Server Express listens on dynamic ports, and it's possible it is not using port 1433. Remove ",1433" from the string, and the Browser Service should provide the correct port, if it's not 1433. -- Rick Byham (MSFT) This posting is provided "AS IS" with no warranties, and confers no rights. "Hezal" <Hezal (AT) discussions (DOT) microsoft.com> wrote in message news:FB510836-1F18-4FDD-AEE3-E962DB82B325 (AT) microsoft (DOT) com... The string is automatically created by visual studio therefore when I remove one slash it complains about unrecognised escape sequence.. "Rick Byham, (MSFT)" wrote: You have too many slashes. HEZAL-PC\\SQLEXPRESS should be HEZAL-PC\SQLEXPRESS -- Rick Byham (MSFT) This posting is provided "AS IS" with no warranties, and confers no rights. "Hezal" <Hezal (AT) discussions (DOT) microsoft.com> wrote in message news:1F5FCD5E-80FB-4C7E-A6A7-4770790B8A3E (AT) microsoft (DOT) com... Hi, I have created a SQL Server 2005 database in VS 2005 and I am using windows mobile to access directly to SQL Server. I use Vista and Windows Mobile device centre for the connection between the device and the PC. I have enabled remote connections for TCP/IP and named pipes. I have also checked the firewall settings and made an exception for sqlsrv.exe Building it is fine but When I debug the application, the status says deployed successfully then it gives me the following error : SqlException was unhandled- int returnValue = this.Adapter.Fill(dataTable); When I comment out the line that calls this 'Fill' method the It displays the column heading but no data in it off course.. So I am very confused whether this is a connection error or not... The code is automatically generated by visual studio. The connection string I use is: "Data Source=HEZAL-PC\\SQLEXPRESS,1433;Initial Catalog=MEDITERRANEAN _RESTAURANT_MANAGEMENT;Integrated Security=True;" Here is the stack trace: at System.Data.SqlClient.SqlConnection.get_ServerVers ion() at System.Data.SqlClient.SqlConnection.Open() at System.Data.Common.DbDataAdapter.QuietOpen() at System.Data.Common.DbDataAdapter.FillInternal() at System.Data.Common.DbDataAdapter.Fill() at System.Data.Common.DbDataAdapter.Fill() at Orders.MEDITERRANEAN__RESTAURANT_MANAGEMENTDataSet 1TableAdapters.Customer_DetailsTableAdapter.Fill() at Orders.Form1.Form1_Load() at System.Windows.Forms.Form.OnLoad() at System.Windows.Forms.Form._SetVisibleNotify() at System.Windows.Forms.Control.set_Visible() at System.Windows.Forms.Application.Run() at Orders.Program.Main() Sorry for the information overload.. I need some help urgently as I have spent days reading searching but nothing helped Can anyone help me please? Thanks |
#44
| |||
| |||
|
|
Thanks for the reply Rick. I appreciate it I tried your suggestion but it still gives error. I realised while debugging the following message: "SQL Server does not exist or access denied." "Rick Byham, (MSFT)" wrote: Sorry. I don't know much about Visual Studio. My only other suggestion is to turn on the SQL Server Browser Service on the SQL Server computer. SQL Server Express listens on dynamic ports, and it's possible it is not using port 1433. Remove ",1433" from the string, and the Browser Service should provide the correct port, if it's not 1433. -- Rick Byham (MSFT) This posting is provided "AS IS" with no warranties, and confers no rights. "Hezal" <Hezal (AT) discussions (DOT) microsoft.com> wrote in message news:FB510836-1F18-4FDD-AEE3-E962DB82B325 (AT) microsoft (DOT) com... The string is automatically created by visual studio therefore when I remove one slash it complains about unrecognised escape sequence.. "Rick Byham, (MSFT)" wrote: You have too many slashes. HEZAL-PC\\SQLEXPRESS should be HEZAL-PC\SQLEXPRESS -- Rick Byham (MSFT) This posting is provided "AS IS" with no warranties, and confers no rights. "Hezal" <Hezal (AT) discussions (DOT) microsoft.com> wrote in message news:1F5FCD5E-80FB-4C7E-A6A7-4770790B8A3E (AT) microsoft (DOT) com... Hi, I have created a SQL Server 2005 database in VS 2005 and I am using windows mobile to access directly to SQL Server. I use Vista and Windows Mobile device centre for the connection between the device and the PC. I have enabled remote connections for TCP/IP and named pipes. I have also checked the firewall settings and made an exception for sqlsrv.exe Building it is fine but When I debug the application, the status says deployed successfully then it gives me the following error : SqlException was unhandled- int returnValue = this.Adapter.Fill(dataTable); When I comment out the line that calls this 'Fill' method the It displays the column heading but no data in it off course.. So I am very confused whether this is a connection error or not... The code is automatically generated by visual studio. The connection string I use is: "Data Source=HEZAL-PC\\SQLEXPRESS,1433;Initial Catalog=MEDITERRANEAN _RESTAURANT_MANAGEMENT;Integrated Security=True;" Here is the stack trace: at System.Data.SqlClient.SqlConnection.get_ServerVers ion() at System.Data.SqlClient.SqlConnection.Open() at System.Data.Common.DbDataAdapter.QuietOpen() at System.Data.Common.DbDataAdapter.FillInternal() at System.Data.Common.DbDataAdapter.Fill() at System.Data.Common.DbDataAdapter.Fill() at Orders.MEDITERRANEAN__RESTAURANT_MANAGEMENTDataSet 1TableAdapters.Customer_DetailsTableAdapter.Fill() at Orders.Form1.Form1_Load() at System.Windows.Forms.Form.OnLoad() at System.Windows.Forms.Form._SetVisibleNotify() at System.Windows.Forms.Control.set_Visible() at System.Windows.Forms.Application.Run() at Orders.Program.Main() Sorry for the information overload.. I need some help urgently as I have spent days reading searching but nothing helped Can anyone help me please? Thanks |
#45
| |||
| |||
|
|
Thanks for the reply Rick. I appreciate it I tried your suggestion but it still gives error. I realised while debugging the following message: "SQL Server does not exist or access denied." "Rick Byham, (MSFT)" wrote: Sorry. I don't know much about Visual Studio. My only other suggestion is to turn on the SQL Server Browser Service on the SQL Server computer. SQL Server Express listens on dynamic ports, and it's possible it is not using port 1433. Remove ",1433" from the string, and the Browser Service should provide the correct port, if it's not 1433. -- Rick Byham (MSFT) This posting is provided "AS IS" with no warranties, and confers no rights. "Hezal" <Hezal (AT) discussions (DOT) microsoft.com> wrote in message news:FB510836-1F18-4FDD-AEE3-E962DB82B325 (AT) microsoft (DOT) com... The string is automatically created by visual studio therefore when I remove one slash it complains about unrecognised escape sequence.. "Rick Byham, (MSFT)" wrote: You have too many slashes. HEZAL-PC\\SQLEXPRESS should be HEZAL-PC\SQLEXPRESS -- Rick Byham (MSFT) This posting is provided "AS IS" with no warranties, and confers no rights. "Hezal" <Hezal (AT) discussions (DOT) microsoft.com> wrote in message news:1F5FCD5E-80FB-4C7E-A6A7-4770790B8A3E (AT) microsoft (DOT) com... Hi, I have created a SQL Server 2005 database in VS 2005 and I am using windows mobile to access directly to SQL Server. I use Vista and Windows Mobile device centre for the connection between the device and the PC. I have enabled remote connections for TCP/IP and named pipes. I have also checked the firewall settings and made an exception for sqlsrv.exe Building it is fine but When I debug the application, the status says deployed successfully then it gives me the following error : SqlException was unhandled- int returnValue = this.Adapter.Fill(dataTable); When I comment out the line that calls this 'Fill' method the It displays the column heading but no data in it off course.. So I am very confused whether this is a connection error or not... The code is automatically generated by visual studio. The connection string I use is: "Data Source=HEZAL-PC\\SQLEXPRESS,1433;Initial Catalog=MEDITERRANEAN _RESTAURANT_MANAGEMENT;Integrated Security=True;" Here is the stack trace: at System.Data.SqlClient.SqlConnection.get_ServerVers ion() at System.Data.SqlClient.SqlConnection.Open() at System.Data.Common.DbDataAdapter.QuietOpen() at System.Data.Common.DbDataAdapter.FillInternal() at System.Data.Common.DbDataAdapter.Fill() at System.Data.Common.DbDataAdapter.Fill() at Orders.MEDITERRANEAN__RESTAURANT_MANAGEMENTDataSet 1TableAdapters.Customer_DetailsTableAdapter.Fill() at Orders.Form1.Form1_Load() at System.Windows.Forms.Form.OnLoad() at System.Windows.Forms.Form._SetVisibleNotify() at System.Windows.Forms.Control.set_Visible() at System.Windows.Forms.Application.Run() at Orders.Program.Main() Sorry for the information overload.. I need some help urgently as I have spent days reading searching but nothing helped Can anyone help me please? Thanks |
#46
| |||
| |||
|
|
Thanks for the reply Rick. I appreciate it I tried your suggestion but it still gives error. I realised while debugging the following message: "SQL Server does not exist or access denied." "Rick Byham, (MSFT)" wrote: Sorry. I don't know much about Visual Studio. My only other suggestion is to turn on the SQL Server Browser Service on the SQL Server computer. SQL Server Express listens on dynamic ports, and it's possible it is not using port 1433. Remove ",1433" from the string, and the Browser Service should provide the correct port, if it's not 1433. -- Rick Byham (MSFT) This posting is provided "AS IS" with no warranties, and confers no rights. "Hezal" <Hezal (AT) discussions (DOT) microsoft.com> wrote in message news:FB510836-1F18-4FDD-AEE3-E962DB82B325 (AT) microsoft (DOT) com... The string is automatically created by visual studio therefore when I remove one slash it complains about unrecognised escape sequence.. "Rick Byham, (MSFT)" wrote: You have too many slashes. HEZAL-PC\\SQLEXPRESS should be HEZAL-PC\SQLEXPRESS -- Rick Byham (MSFT) This posting is provided "AS IS" with no warranties, and confers no rights. "Hezal" <Hezal (AT) discussions (DOT) microsoft.com> wrote in message news:1F5FCD5E-80FB-4C7E-A6A7-4770790B8A3E (AT) microsoft (DOT) com... Hi, I have created a SQL Server 2005 database in VS 2005 and I am using windows mobile to access directly to SQL Server. I use Vista and Windows Mobile device centre for the connection between the device and the PC. I have enabled remote connections for TCP/IP and named pipes. I have also checked the firewall settings and made an exception for sqlsrv.exe Building it is fine but When I debug the application, the status says deployed successfully then it gives me the following error : SqlException was unhandled- int returnValue = this.Adapter.Fill(dataTable); When I comment out the line that calls this 'Fill' method the It displays the column heading but no data in it off course.. So I am very confused whether this is a connection error or not... The code is automatically generated by visual studio. The connection string I use is: "Data Source=HEZAL-PC\\SQLEXPRESS,1433;Initial Catalog=MEDITERRANEAN _RESTAURANT_MANAGEMENT;Integrated Security=True;" Here is the stack trace: at System.Data.SqlClient.SqlConnection.get_ServerVers ion() at System.Data.SqlClient.SqlConnection.Open() at System.Data.Common.DbDataAdapter.QuietOpen() at System.Data.Common.DbDataAdapter.FillInternal() at System.Data.Common.DbDataAdapter.Fill() at System.Data.Common.DbDataAdapter.Fill() at Orders.MEDITERRANEAN__RESTAURANT_MANAGEMENTDataSet 1TableAdapters.Customer_DetailsTableAdapter.Fill() at Orders.Form1.Form1_Load() at System.Windows.Forms.Form.OnLoad() at System.Windows.Forms.Form._SetVisibleNotify() at System.Windows.Forms.Control.set_Visible() at System.Windows.Forms.Application.Run() at Orders.Program.Main() Sorry for the information overload.. I need some help urgently as I have spent days reading searching but nothing helped Can anyone help me please? Thanks |
#47
| |||
| |||
|
|
Thanks for the reply Rick. I appreciate it I tried your suggestion but it still gives error. I realised while debugging the following message: "SQL Server does not exist or access denied." "Rick Byham, (MSFT)" wrote: Sorry. I don't know much about Visual Studio. My only other suggestion is to turn on the SQL Server Browser Service on the SQL Server computer. SQL Server Express listens on dynamic ports, and it's possible it is not using port 1433. Remove ",1433" from the string, and the Browser Service should provide the correct port, if it's not 1433. -- Rick Byham (MSFT) This posting is provided "AS IS" with no warranties, and confers no rights. "Hezal" <Hezal (AT) discussions (DOT) microsoft.com> wrote in message news:FB510836-1F18-4FDD-AEE3-E962DB82B325 (AT) microsoft (DOT) com... The string is automatically created by visual studio therefore when I remove one slash it complains about unrecognised escape sequence.. "Rick Byham, (MSFT)" wrote: You have too many slashes. HEZAL-PC\\SQLEXPRESS should be HEZAL-PC\SQLEXPRESS -- Rick Byham (MSFT) This posting is provided "AS IS" with no warranties, and confers no rights. "Hezal" <Hezal (AT) discussions (DOT) microsoft.com> wrote in message news:1F5FCD5E-80FB-4C7E-A6A7-4770790B8A3E (AT) microsoft (DOT) com... Hi, I have created a SQL Server 2005 database in VS 2005 and I am using windows mobile to access directly to SQL Server. I use Vista and Windows Mobile device centre for the connection between the device and the PC. I have enabled remote connections for TCP/IP and named pipes. I have also checked the firewall settings and made an exception for sqlsrv.exe Building it is fine but When I debug the application, the status says deployed successfully then it gives me the following error : SqlException was unhandled- int returnValue = this.Adapter.Fill(dataTable); When I comment out the line that calls this 'Fill' method the It displays the column heading but no data in it off course.. So I am very confused whether this is a connection error or not... The code is automatically generated by visual studio. The connection string I use is: "Data Source=HEZAL-PC\\SQLEXPRESS,1433;Initial Catalog=MEDITERRANEAN _RESTAURANT_MANAGEMENT;Integrated Security=True;" Here is the stack trace: at System.Data.SqlClient.SqlConnection.get_ServerVers ion() at System.Data.SqlClient.SqlConnection.Open() at System.Data.Common.DbDataAdapter.QuietOpen() at System.Data.Common.DbDataAdapter.FillInternal() at System.Data.Common.DbDataAdapter.Fill() at System.Data.Common.DbDataAdapter.Fill() at Orders.MEDITERRANEAN__RESTAURANT_MANAGEMENTDataSet 1TableAdapters.Customer_DetailsTableAdapter.Fill() at Orders.Form1.Form1_Load() at System.Windows.Forms.Form.OnLoad() at System.Windows.Forms.Form._SetVisibleNotify() at System.Windows.Forms.Control.set_Visible() at System.Windows.Forms.Application.Run() at Orders.Program.Main() Sorry for the information overload.. I need some help urgently as I have spent days reading searching but nothing helped Can anyone help me please? Thanks |
#48
| |||
| |||
|
|
Thanks for the reply Rick. I appreciate it I tried your suggestion but it still gives error. I realised while debugging the following message: "SQL Server does not exist or access denied." "Rick Byham, (MSFT)" wrote: Sorry. I don't know much about Visual Studio. My only other suggestion is to turn on the SQL Server Browser Service on the SQL Server computer. SQL Server Express listens on dynamic ports, and it's possible it is not using port 1433. Remove ",1433" from the string, and the Browser Service should provide the correct port, if it's not 1433. -- Rick Byham (MSFT) This posting is provided "AS IS" with no warranties, and confers no rights. "Hezal" <Hezal (AT) discussions (DOT) microsoft.com> wrote in message news:FB510836-1F18-4FDD-AEE3-E962DB82B325 (AT) microsoft (DOT) com... The string is automatically created by visual studio therefore when I remove one slash it complains about unrecognised escape sequence.. "Rick Byham, (MSFT)" wrote: You have too many slashes. HEZAL-PC\\SQLEXPRESS should be HEZAL-PC\SQLEXPRESS -- Rick Byham (MSFT) This posting is provided "AS IS" with no warranties, and confers no rights. "Hezal" <Hezal (AT) discussions (DOT) microsoft.com> wrote in message news:1F5FCD5E-80FB-4C7E-A6A7-4770790B8A3E (AT) microsoft (DOT) com... Hi, I have created a SQL Server 2005 database in VS 2005 and I am using windows mobile to access directly to SQL Server. I use Vista and Windows Mobile device centre for the connection between the device and the PC. I have enabled remote connections for TCP/IP and named pipes. I have also checked the firewall settings and made an exception for sqlsrv.exe Building it is fine but When I debug the application, the status says deployed successfully then it gives me the following error : SqlException was unhandled- int returnValue = this.Adapter.Fill(dataTable); When I comment out the line that calls this 'Fill' method the It displays the column heading but no data in it off course.. So I am very confused whether this is a connection error or not... The code is automatically generated by visual studio. The connection string I use is: "Data Source=HEZAL-PC\\SQLEXPRESS,1433;Initial Catalog=MEDITERRANEAN _RESTAURANT_MANAGEMENT;Integrated Security=True;" Here is the stack trace: at System.Data.SqlClient.SqlConnection.get_ServerVers ion() at System.Data.SqlClient.SqlConnection.Open() at System.Data.Common.DbDataAdapter.QuietOpen() at System.Data.Common.DbDataAdapter.FillInternal() at System.Data.Common.DbDataAdapter.Fill() at System.Data.Common.DbDataAdapter.Fill() at Orders.MEDITERRANEAN__RESTAURANT_MANAGEMENTDataSet 1TableAdapters.Customer_DetailsTableAdapter.Fill() at Orders.Form1.Form1_Load() at System.Windows.Forms.Form.OnLoad() at System.Windows.Forms.Form._SetVisibleNotify() at System.Windows.Forms.Control.set_Visible() at System.Windows.Forms.Application.Run() at Orders.Program.Main() Sorry for the information overload.. I need some help urgently as I have spent days reading searching but nothing helped Can anyone help me please? Thanks |
#49
| |||
| |||
|
|
Thanks for the reply Rick. I appreciate it I tried your suggestion but it still gives error. I realised while debugging the following message: "SQL Server does not exist or access denied." "Rick Byham, (MSFT)" wrote: Sorry. I don't know much about Visual Studio. My only other suggestion is to turn on the SQL Server Browser Service on the SQL Server computer. SQL Server Express listens on dynamic ports, and it's possible it is not using port 1433. Remove ",1433" from the string, and the Browser Service should provide the correct port, if it's not 1433. -- Rick Byham (MSFT) This posting is provided "AS IS" with no warranties, and confers no rights. "Hezal" <Hezal (AT) discussions (DOT) microsoft.com> wrote in message news:FB510836-1F18-4FDD-AEE3-E962DB82B325 (AT) microsoft (DOT) com... The string is automatically created by visual studio therefore when I remove one slash it complains about unrecognised escape sequence.. "Rick Byham, (MSFT)" wrote: You have too many slashes. HEZAL-PC\\SQLEXPRESS should be HEZAL-PC\SQLEXPRESS -- Rick Byham (MSFT) This posting is provided "AS IS" with no warranties, and confers no rights. "Hezal" <Hezal (AT) discussions (DOT) microsoft.com> wrote in message news:1F5FCD5E-80FB-4C7E-A6A7-4770790B8A3E (AT) microsoft (DOT) com... Hi, I have created a SQL Server 2005 database in VS 2005 and I am using windows mobile to access directly to SQL Server. I use Vista and Windows Mobile device centre for the connection between the device and the PC. I have enabled remote connections for TCP/IP and named pipes. I have also checked the firewall settings and made an exception for sqlsrv.exe Building it is fine but When I debug the application, the status says deployed successfully then it gives me the following error : SqlException was unhandled- int returnValue = this.Adapter.Fill(dataTable); When I comment out the line that calls this 'Fill' method the It displays the column heading but no data in it off course.. So I am very confused whether this is a connection error or not... The code is automatically generated by visual studio. The connection string I use is: "Data Source=HEZAL-PC\\SQLEXPRESS,1433;Initial Catalog=MEDITERRANEAN _RESTAURANT_MANAGEMENT;Integrated Security=True;" Here is the stack trace: at System.Data.SqlClient.SqlConnection.get_ServerVers ion() at System.Data.SqlClient.SqlConnection.Open() at System.Data.Common.DbDataAdapter.QuietOpen() at System.Data.Common.DbDataAdapter.FillInternal() at System.Data.Common.DbDataAdapter.Fill() at System.Data.Common.DbDataAdapter.Fill() at Orders.MEDITERRANEAN__RESTAURANT_MANAGEMENTDataSet 1TableAdapters.Customer_DetailsTableAdapter.Fill() at Orders.Form1.Form1_Load() at System.Windows.Forms.Form.OnLoad() at System.Windows.Forms.Form._SetVisibleNotify() at System.Windows.Forms.Control.set_Visible() at System.Windows.Forms.Application.Run() at Orders.Program.Main() Sorry for the information overload.. I need some help urgently as I have spent days reading searching but nothing helped Can anyone help me please? Thanks |
#50
| |||
| |||
|
|
Thanks for the reply Rick. I appreciate it I tried your suggestion but it still gives error. I realised while debugging the following message: "SQL Server does not exist or access denied." "Rick Byham, (MSFT)" wrote: Sorry. I don't know much about Visual Studio. My only other suggestion is to turn on the SQL Server Browser Service on the SQL Server computer. SQL Server Express listens on dynamic ports, and it's possible it is not using port 1433. Remove ",1433" from the string, and the Browser Service should provide the correct port, if it's not 1433. -- Rick Byham (MSFT) This posting is provided "AS IS" with no warranties, and confers no rights. "Hezal" <Hezal (AT) discussions (DOT) microsoft.com> wrote in message news:FB510836-1F18-4FDD-AEE3-E962DB82B325 (AT) microsoft (DOT) com... The string is automatically created by visual studio therefore when I remove one slash it complains about unrecognised escape sequence.. "Rick Byham, (MSFT)" wrote: You have too many slashes. HEZAL-PC\\SQLEXPRESS should be HEZAL-PC\SQLEXPRESS -- Rick Byham (MSFT) This posting is provided "AS IS" with no warranties, and confers no rights. "Hezal" <Hezal (AT) discussions (DOT) microsoft.com> wrote in message news:1F5FCD5E-80FB-4C7E-A6A7-4770790B8A3E (AT) microsoft (DOT) com... Hi, I have created a SQL Server 2005 database in VS 2005 and I am using windows mobile to access directly to SQL Server. I use Vista and Windows Mobile device centre for the connection between the device and the PC. I have enabled remote connections for TCP/IP and named pipes. I have also checked the firewall settings and made an exception for sqlsrv.exe Building it is fine but When I debug the application, the status says deployed successfully then it gives me the following error : SqlException was unhandled- int returnValue = this.Adapter.Fill(dataTable); When I comment out the line that calls this 'Fill' method the It displays the column heading but no data in it off course.. So I am very confused whether this is a connection error or not... The code is automatically generated by visual studio. The connection string I use is: "Data Source=HEZAL-PC\\SQLEXPRESS,1433;Initial Catalog=MEDITERRANEAN _RESTAURANT_MANAGEMENT;Integrated Security=True;" Here is the stack trace: at System.Data.SqlClient.SqlConnection.get_ServerVers ion() at System.Data.SqlClient.SqlConnection.Open() at System.Data.Common.DbDataAdapter.QuietOpen() at System.Data.Common.DbDataAdapter.FillInternal() at System.Data.Common.DbDataAdapter.Fill() at System.Data.Common.DbDataAdapter.Fill() at Orders.MEDITERRANEAN__RESTAURANT_MANAGEMENTDataSet 1TableAdapters.Customer_DetailsTableAdapter.Fill() at Orders.Form1.Form1_Load() at System.Windows.Forms.Form.OnLoad() at System.Windows.Forms.Form._SetVisibleNotify() at System.Windows.Forms.Control.set_Visible() at System.Windows.Forms.Application.Run() at Orders.Program.Main() Sorry for the information overload.. I need some help urgently as I have spent days reading searching but nothing helped Can anyone help me please? Thanks |
 |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.