connection problem when trying to directly connect to SQL Server

H

Hezal

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top