Link to home
Create AccountLog in
Avatar of SweetsJamRock
SweetsJamRockFlag for Jamaica

asked on

database connection erro over the network VB

Guys i am getting another SQL DB ERROR as shown in the image  when connecting to the program over the network from a workstation.

[SQL DATABASE PROGRAM ]  running from WINDOWS 2003 ENTERPRISE SERVER
program written in vs2010
dabatabse using -> sql 2008
language using -> VISUAL BASIC

*note:  the program loads OK on the workstation but gives the SQL ERROR when loading the form with the database attached.

guys i need your help urgently with this 1.

i remember i had a similar problem with C# and you guys help to fixed it, but i follow that instruction and it does not seem to work with VB.



sqlconnection-error.doc
Avatar of rimmena
rimmena

Have you had a look at this article ? It may solve your issues:

http://blogs.msdn.com/b/shawnfa/archive/2003/06/20/57023.aspx

Looks like the problem is that you are running it from a network share.
Avatar of Ryan McCauley
.NET blocks network connectivity if you're running the program from an untrusted location, like a network share - in this case, the .NET Framework can't trust the location that the application is running, so it won't allow any network access (though access to local resources should work fine). If this is the first place in your application that you're attempting to access something not on your local computer, then that's your answer.

You can either move the EXE locally, or you can execute a command to trust the network share you're running from:

http://www.eggheadcafe.com/software/aspnet/30579489/making-a-network-folder-a-trusted-location.aspx
ASKER CERTIFIED SOLUTION
Avatar of SweetsJamRock
SweetsJamRock
Flag of Jamaica image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of SweetsJamRock

ASKER

This answer helps to identify some of the area that should be configure