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

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@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

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.
.

Relevant Pages

  • RE: Can Access do this
    ... I'm not sure what you mean about network drives, ... need a central location to access the database. ... Microsoft Access Support ... Microsoft Security Bulletin MS03-026? ...
    (microsoft.public.access.security)
  • Re: Sqlserverce class not working when VB.Net application is running from network drive
    ... for a SSC database is that only a single connection is supported at a time.. ... If you're running the app from ... In VB.net coding i am using Sqlserverce classes ... network drives. ...
    (microsoft.public.sqlserver.ce)
  • Re: Sqlserverce class not working when VB.Net application is running from network drive
    ... for a SSC database is that only a single connection is supported at a time. ... In VB.net coding i am using Sqlserverce classes ... >> network drives. ...
    (microsoft.public.sqlserver.ce)
  • Re: Sqlserverce class not working when VB.Net application is running from network drive
    ... 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. ... 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. ... 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. ... > network drives. ...
    (microsoft.public.sqlserver.ce)
  • Re: Release of GNADE 1.5.2
    ... Michael> Dear all the GNU Ada Database Development Environment Version ... This release of the GNADE project is intended for building with GNAT ... The GNADE project installation procedure provides for theses product ... 566413 1.3.5a static libraries not build for adbc Makefile modified ...
    (comp.lang.ada)
Loading