|
Hi everyone. For the last few days i´ve been searching for a solution to my problem. I´m trying to connect to a local desktop SQL Server 2000 in my development PC from a smartdevice emulator using VS 2008 with C#. I can navegate from the emulator and i can connect to a SQL CE database in the emulator. I've tried pocketc PC 2003 and Windows mobile 5 and 6, but makes no difference. I'm developing in a VMWare workstation using WXP x86 SP3 on a physical W7 x64 OS, and networking by WIFI, but since it´s a local connection, i don´t think that´s the problem. I've tried also named and IP connections. The physical handheld has no network device, so i must try to connect by USB port using activesync when the user cradles the device. The error i´m getting is "ConnectionRead (recv())." {"SqlException"} Number 11 Here´s my code: using System.Data.SqlClient; namespace SmartDeviceProject7 { public partial class Form1 : Form { public Form1() { InitializeComponent(); } Thanx in advance for any help. Néstor.
(comments are locked)
|
(comments are locked)
|
|
Problem solved!! My mistake. I thought i was using SQL server SP4 but i checked and i wasn´t. Installing the servicepack solved everything. Sorry for the inconvenience, and thank you for helping me.
(comments are locked)
|


Which version of VS2008 are you using? Is it Express Edition?
Hi Pavel and Mister Magoo, i´m using VS 2008 Pro with a SQL server 2000 SP4 with a unique instance and with mixed authentication.
The problem seems to be in an earlier instance of the connection process, because i got the same error no matter wich user or password i use in the connection string.
I´m trying now some suite of functions for the emulator "vxUtil" to see if i can ping the server from the emulator.
I´ve tried on a physical pc with WXP and got the same error, so it´s not the vmware, it has to be some connectivity issue but i'm really getting out of options...
Thank you for reading this!
If you are using a named instance, you have to include the instance name in the connection string like
Data Source=192.168.16.105\Instance_Name. Also check protocols you are using in the SQL Server Configuration Manager.I´ve tried with instance name, but no changes. Also tried changing default port of SQL 2000 to 1234 but still getting the same error.
My smartdevice cannot ping my PC, i need it to do it by ActiveSync since it´s a device without network card.
I think that´s my problem, but i cannot figure out how to solve this situation...