Re: problem with connecting to sql server via a wireless application

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:1F5FCD5E-80FB-4C7E-A6A7-4770790B8A3E@xxxxxxxxxxxxxxxx
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_ServerVersion() 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_MANAGEMENTDataSet1TableAdapters.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

.

Relevant Pages

  • Re: Connecting to SQL Server 2008 Express from Visual Studio .net (c#)
    ... I have SQL Server Express 2008 installed, ... I'm coding in C# .net for windows mobile 5. ... If I view the properties of the data connection I created, ... This occurs whether I'm using an emulator, or a windows mobile device ...
    (microsoft.public.vsnet.general)
  • Re: SQL Server 2008 Express connection from Visual Studio 2009 (C# .net)
    ... I've just built and deployed this project to the windows mobile device ... I have SQL Server Express 2008 installed, ... If I view the properties of the data connection I created, ...
    (microsoft.public.sqlserver.server)
  • Problem with Login Control
    ... I have setup a SQL 2005 DB with ASP.NET membership tables. ... button I get a connection error: ... An error has occurred while establishing a connection to the server. ... under the default settings SQL Server does not allow remote connections. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Error "SQL Server does not allow remote connections"
    ... The application could not connect to the sql server db. ... network is blocking the connection. ... SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 ... integratedSecurity, SqlConnection owningObject) +737554 ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Connection from remote computer to network SQL Server
    ... There is no firewall on the W2K machine acting as the SQL server. ... I tried making the SQL machine a "trusted" on the router. ... connection works. ... To find the IP address of your computer inside the network, ...
    (microsoft.public.access.adp.sqlserver)