NEWBIE: Database question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I am having a difficult time making a connection to a database that sits on
a network share. If I map this network share locally I am able to connect to
the database.. The vb.net desktop program I am trying to write needs access
to this database but since this program will be run by many different people
across different networks how can I go about making sure that they don't
have any access permission issues?

I apologize for the vagueness of this post I just don't know exactly what I
need to do in order to connect to this database and I am getting frustrated.

many thanks in advance,

devin
 
Hi Devin,

I think you are talking about a database like MsAccess

Why not do a fileinfo before it to see if it exist, it does not matter if it
exist or that the user cannot reach it, for your program it has to be there.

If it not exist you can show a message and close then I think.

My first thought by this.

Cor
I am having a difficult time making a connection to a database that sits on
a network share. If I map this network share locally I am able to connect to
the database.. The vb.net desktop program I am trying to write needs access
to this database but since this program will be run by many different people
across different networks how can I go about making sure that they don't
have any access permission issues?

I apologize for the vagueness of this post I just don't know exactly what I
need to do in order to connect to this database and I am getting
Click to expand...
frustrated.
 
erm, well you could do this !

PSEUDO

Try
Dim the ConnectionObject
Catch ex As Exception
Messagbox.show("Could not connect to database, please pray for
guidence!")
End Try

Regards - OHM

Thanks Cor. I'll give it a shot and see if that helps.

cheers,

devin
Click to expand...

Regards - OHM# (e-mail address removed)
 
Hi OHM,

I did think about that also, but I think that doing it with a fileinfo is
more precise, than you can leave the try for other things.

Just a thought.

Cor
 
Try
Dim the ConnectionObject
Catch ex As Exception
Messagbox.show("Could not connect to database, please pray for
guidence!")
End Try
Click to expand...

Perfect. It worked. Thanks OHM!
 
Back
Top