[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1265
  • Last Modified:

Visual Studio Smart Device application will not connect to specified server

I'm new to Visual Studio.  I have a inventory form intended for a handheld computer that will connect to the server SQL database via wireless.  Although the database shows in the explorer and server windows and I can preview data, when I run debug the the application will not connect to the database.  Here's my VB code for the connection string.  Thank you in advance for your help, it's greatly appreciated.
<Global.System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Private Sub InitConnection()
            Me._connection = New Global.System.Data.SqlClient.SqlConnection
            Me._connection.ConnectionString = "data source=DC1; user id=xx; pwd=xxxxx; initial catalog=Jeff;database=Jeff; Integrated Security=True;"
        End Sub

Open in new window

0
jeff-h
Asked:
jeff-h
  • 2
  • 2
1 Solution
 
GaryHoffCommented:
I am having a similar problem.  I get an sqlexception number 6, with no useful message (compact framework limitation I suppose)
0
 
GaryHoffCommented:
I solved my problem.  See http://blogs.msdn.com/sql_protocols/archive/2005/10/22/483684.aspx.
In my case in the SQL Configuration Manager -> SQL Server 2005 Services, the SQL Server Browser was not running.
0
 
jeff-hAuthor Commented:
Thanks, it worked!
0
 
jeff-hAuthor Commented:
Thanks a lot!  I've been stuck on that for a week.
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now