Connection string problemm - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

Other SQL Server 2008 Topics

Connection string problemm

Author

Topic

benseb
Starting Member

3 Posts

Posted - 2009-06-26 : 08:42:08

Hi

I'm using Visual Studio 2009 to connect to SQL Server Express 2008

I can connect using the built in 'server explorer' and creating a connection, but when I try to build a project and deploy on either a Windows Mobile 5 device, or using the emulator I get problems

I have the connection string as

Data Source = 192.168.1.74\\SQLEXPRESS,1433;Initial Catalog=bentest;User Id=scanner;Password=sc109843;

I have verified that I can connect using these settings using SQL Express Management Studio (using same login details).

As the Windows Mobile device is connected via docking station and USB, I'm thinking it must be a networking issue. However I can browse the net fine from the device, using the same docking connection

I have enabled TCP/IP for this connection, and I can connect from another PC direct using SQL Express Management Studio.

Any ideas?

Thanks

Ben

NeilG
Aged Yak Warrior

530 Posts

Posted - 2009-06-26 : 10:17:38

have you enabled the remote connection in the surface area configuration program, remote connection are turn off by default

benseb
Starting Member

3 Posts

Posted - 2009-06-26 : 10:23:39

Yes, I found the error was down to Windows Mobile Centre. In conneection settings you need to enable 'DMA' for connections to allow network tcp/ip traffic.

Very hidden away!

NeilG
Aged Yak Warrior

530 Posts

Posted - 2009-06-26 : 10:28:08

I'm sure some progammers like to hide features just to make the working day more frustrating sometimes

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources