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

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

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

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

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

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

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

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

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

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