I am using SQLCE and Visual Studio 2008.
I followed this tutorial.
I am needing the database to reside on one computer and be accessed by others. I did a build and into a shared folder called "app". The ip address of the host computer is 192.168.2.4.
This doesn't work and even if it did it doesn't solve the issue of remote connection but it's weird it won't even recognize it.
This doesn't work either.
The only error it shows is that that path does not exist. I also tried editing the app.config file as well.
This works when the destinations are as follows for the login form and the app.config file.
"Login Form"
I hope I have given enough information to receive help. If not let me know and I'll see what more I could give. Thanks.
I followed this tutorial.
I am needing the database to reside on one computer and be accessed by others. I did a build and into a shared folder called "app". The ip address of the host computer is 192.168.2.4.
This doesn't work and even if it did it doesn't solve the issue of remote connection but it's weird it won't even recognize it.
VB.NET:
Dim con As SqlCeConnection = New SqlCeConnection("Data Source=C:\Documents and Settings\Andrew\Desktop\app\Database1.sdf") 'This here, declares where the database is located
Dim Clear As Double
Dim myDA As SqlCeDataAdapter
Dim myDataSet As DataSet
Dim dt As New DataTable()
This doesn't work either.
VB.NET:
Dim con As SqlCeConnection = New SqlCeConnection("Data Source=\\192.168.2.4\app\Database1.sdf") 'This here, declares where the database is located
Dim Clear As Double
Dim myDA As SqlCeDataAdapter
Dim myDataSet As DataSet
Dim dt As New DataTable()
The only error it shows is that that path does not exist. I also tried editing the app.config file as well.
This works when the destinations are as follows for the login form and the app.config file.
"Login Form"
VB.NET:
Dim con As SqlCeConnection = New SqlCeConnection("Data Source=\Database1.sdf") 'This here, declares where the database is located
Dim Clear As Double
Dim myDA As SqlCeDataAdapter
Dim myDataSet As DataSet
Dim dt As New DataTable()
VB.NET:
<connectionStrings>
<add name="logintestapp.My.MySettings.Database1ConnectionString"
connectionString="Data Source=|DataDirectory|\Database1.sdf"
providerName="Microsoft.SqlServerCe.Client.3.5" />
</connectionStrings>
I hope I have given enough information to receive help. If not let me know and I'll see what more I could give. Thanks.