Re: Sqlserverce class not working when VB.Net application is running from network drive

On Jan 8, 3:05 pm, "Ginny Caughey [MVP]"
<ginny.caughey.onl...@xxxxxxxxxxxxxx> wrote:
If only one process is running the app *at a time* on the mapped drive, I
would have though that might work. The (known) issue is that if more than
one app attempts to connect to a sdf file on a network share, the first app
that connections opens that file with an exclusive handle so no other apps
can access it.

--
Ginny Caughey
Device Application Development MVP

<srikumari.madd...@xxxxxxxxx> wrote in message

news:9068c932-1d0e-466f-b4ca-0f61b20e2f94@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
On Jan 8, 2:26 pm, "Ginny Caughey [MVP]"





<ginny.caughey.onl...@xxxxxxxxxxxxxx> wrote:
Instead of mapping the drive to point to a different machine, does it work
if you just copy everything to that machine and run it there? I really
can't
tell what the problem is from your description, but I'm guessing it could
be
a sharing violation.

--
Ginny Caughey
Device Application Development MVP

<srikumari.madd...@xxxxxxxxx> wrote in message

news:fa155fa9-85c7-45af-8e9a-df3b9ad5a8bd@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
On Jan 8, 10:59 am, "Ginny Caughey [MVP]"

<ginny.caughey.onl...@xxxxxxxxxxxxxx> wrote:
If you don't already have a try...catch block around the SqlCeConnection
code, add that and see if you can trap exactly what the error is. Use
the
debugger to see if there is any InnerException your should be aware of..

The only thing that is generally different about a network drive
location
for a SSC database is that only a single connection is supported at a
time.
Lack of adequate rights can also be an issue. If you're running the app
from
a local machine where your app works if the sdf file is also local, then
I
assume all the DLLs you need are present. But if you're actually running
the
app from a network machine, then an incomplete SSC installation could
also
be an issue.

--
Ginny Caughey
Device Application Development MVP

<srikumari.madd...@xxxxxxxxx> wrote in message

news:4ec87347-ba09-4fc5-9542-46ac50b14dae@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
On Jan 7, 10:34 am, "Ginny Caughey [MVP]"

<ginny.caughey.onl...@xxxxxxxxxxxxxx> wrote:
How do you know it is not working? Do you get any error message? Is it
possible that the database is already in use when you attempt to
connect
to
it on the network drive? Is the application running from the same
location
as the database file or on a different computer?

--
Ginny Caughey
Device Application Development MVP

<srikumari.madd...@xxxxxxxxx> wrote in message

news:7e4d0146-1d05-4b20-99c2-0c0eff427890@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

I have VB.net application which has SQL Server Compact Edition 2005
Database as backend. In VB.net coding i am using Sqlserverce classes
to connect this database. It works well when I run the application
in
local drives. But its not working when I run the application from
network drives. I tried with strong names and security policies.
Still
not working. Can anybody help me to resolve this Issue. Its urgent
Plzzzzzzzzz.

Thanks
Srikumari.- Hide quoted text -

- Show quoted text -

Hi
Thanks for your reply. It gives the error
"Application has encountered a problem and needs to close. We are
sorry for the inconvenience."
1st I couldnt locate where the error exists. So I commented the code
line by line and tried to find out which line of code is causing the
problem. I gor the error at SqlCeConnection varible declaration
itself. Same case with all the Sqlce classes. I already added the
necessary references also. I commented the database connection code.
I tried only with variable declaration. This itself causing the error.
Please help me to resolve this issue.

Thnaks,
Srikumari.- Hide quoted text -

- Show quoted text -

Thanks Ginny

I tried with the try catch block. Still the error is same.
Let me explain you what I did.
On System A I installed my application. Database is also on System A's
folder where the executable is. If I run the application from System
A , it works fine and it connects to the database also.
Now I mapped the System A's folder where the application exists on to
System B. (Both the systems are in network and sharing permission is
also there.)
Now I am running the application from System B. Then that error
"Application has encountered a problem and needs to close. We are
sorry for the inconvenience."
exists.

In the code if I dont use any Sqlserverce classess then it works fine
in System B also. The error exists only when I use Sqlserverce
classess.
But those are needed to connect to the database.

Help me to solve this plz.

Thnaks,
Srikumari.- Hide quoted text -

- Show quoted text -

Ya it works fine If I copy everything onto System B and run it.
Sharing permissions are there for both the systems. (I am able to
access all other folders bewteen the 2 systems. So there is no sharing
problem)
In my case the application needs to be run from the network drive  as
per the client requirement. They have nearly 50 systems in network and
they want to install application on to only one system and run it from
all other systems. So this mapping the drive is needed.
one more thing, I installed the necessary software Dot Net Compact
Framework and SqlServer Compact Edition 2005 on to System B.
In some articles I read that this is bcoz of some Security issues and
they asked to set some Full Trust options which I did. Even then the
same error I got.
In some articles they asked to try by creating strong name which I
tried and got the same error.

Thanks
Srikumari.- Hide quoted text -

- Show quoted text -

Only one process is running the application at a time on the mapped
drive.
There is only one attempt at a time to connect the database. If one
attemt work fine then I will try with multiple attempts.
I have this error with one attempt at a time.
.

Relevant Pages

  • Re: Webservices - the way to go...?
    ... about your lack of secure network connectivity your between a rock and a ... To summarize the posts so far: you have a winform app. ... using a webservices data layer to handle all the database interactions. ... Upgrade your database to SQL Server. ...
    (microsoft.public.dotnet.general)
  • Re: .NET new executable
    ... Since there is no network access avaialble, I want to send my app to each ... then you update the data into database. ... If all you are trying to do is send some data to your SQL server, ...
    (microsoft.public.dotnet.general)
  • Re: I need help in asking the right questions
    ... the way your app is written can either put off the inevitable for a while or lead you to it faster. ... if your app uses a lot of queries on network tables you are going to find it slowing down sooner rather than later. ... If you are going to use this app for any length of time and will keep adding a lot of data, the answer is to convert the back end to a CS database. ... it slows down terribly when moving from record to record. ...
    (comp.databases.paradox)
  • Re: Couldnt Lock File Error
    ... I have a VB App which is deployed onto a number of client PC's. ... would be related to 2 apps trying to hit the database at the same time. ... when we were thrilled if our app even connected to the network. ... a particular Jet engine can become confused at times. ...
    (microsoft.public.vb.general.discussion)
  • Re: Sql Server Compact Edition - Lost Data
    ... It's simply copying your .sdf file to the output directory when you run the app from within the IDE. ... check the file output options for your database ".sdf" file. ... You are just creating a new database from the old one everytime your run the app. ...
    (microsoft.public.sqlserver.ce)