Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Connection String with SqlCeConnection
Message
 
To
08/08/2003 09:12:18
Alvin Lourdes
Children and Youth Services Cluster
Toronto, Ontario, Canada
General information
Forum:
ASP.NET
Category:
.NET Compact Framework
Miscellaneous
Thread ID:
00817896
Message ID:
00818277
Views:
14
What is the error?

The way I would do it is this:

1. Connect to the sql box from a desktop. This will tell you if your connection string is correct. Use this as a guide: http://www.able-consulting.com/dotnet/adonet/Data_Providers.htm#SQLClientManagedProvider

2. Using the connection string that works on your mobile device. This will tell you if you have connectivity problems with your device. It might be that you will not be able to connect using the server name. You might have to use the ip address of the sql server in the connection string.


>David,
>
>SqlConnection thisConnection = new SqlConnection();
>thisConnection.ConnectionString = @"Server = TAP1;" +
>"Integrated Security = SSPI;" +
>"Connection Timeout = 5;";
>
>thisConnection.Open();
>
>
>This generates an error. Please let me know if you see the problem with the connection string.
>
>Thanks,
>
>Alvin
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform