how share access for clients?

[hamid]

Hi,

my application connect to a database (ms access) and fill a textbox

i wanna share my application and database for clients, that clients create a shortcut to my app and run my app. but it dosnt work with database and return error for permission and faild zone (internet)

please let me know all necessary works for shared my app for clients

[amir100]

Are you creating a web application or a desktop application? If you're creating a desktop application, I'm guessing you have to allow your client to access your database location. But since you're using Access, I guess you'll have trouble with your connection string configuration.

[hamid]

it s win application and clients have full access to shared folder

but what shall i do to fix this error?

[PlausiblyDamp]

Are you running your application locally or from the server itself? If you are running the application from the server you will need to adjust the permissions for the Local Intranet Zone - easiest way is via the Framework Configuration tool you should have in your Administrative Tools folder.

[hamid]

i run application from other computer in same workgroup (clients).

also in server itself (not local)

ok, i find .net framework 2.0 configuration from administrator tools, but how can i change permission?

[amir100]

it s win application and clients have full access to shared folder

but what shall i do to fix this error?

 

So you're client can access your application and your database from that shared folder right? If that's the case then shouldn't you be changing your connection string property?

 

It is true that your application are running in the client's computer. But then your application will look for the database in the client's computer. Isn't that the case? Or are you using Data Source to connect to your database instead connecting directly to it?

[amir100]

i run application from other computer in same workgroup (clients).

also in server itself (not local)

ok, i find .net framework 2.0 configuration from administrator tools, but how can i change permission?

 

Iterate to "My Computer". Click on the "Runtime Security Policy" node. You'll see the "Tasks" page. Click "Adjust Zone Security".

 

Maybe that's what PlausiblyDamp are trying to refer.

[hamid]

below is my connection string

        private string constr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\\\servername\\sharedfolder\\MainDb.mdb; " +
           "User Id=admin;;Password=;";

it work localy but dont work from clients or server itself !!!

[amir100]

Have you tried PlausiblyDamp's suggestion?

[hamid]

cource but what i shall change from .net framework 2.0 configuration ?

and another is when i run app from clients, windows alert security message and take it on application icon!! why?

[amir100]

Iterate to "My Computer". Click on the "Runtime Security Policy" node. You'll see the "Tasks" page. Click "Adjust Zone Security".

 

A new window should appear. Follow the steps until you can see options for security zones such as "My Computer", "Local Intranet Zone", etc. From here I think you'll get the drift. You simply set your "Local Intranet Zone" closer to "Full Trust".

 

I believe you're dealing with basic windows file sharing here. I don't if this'll work but you could try turning off windows firewall or any other firewall you have in your client and your computer.

 

Hope this helps.

[hamid]

i did it and set local zone to lowest permisiion but dosnt work !!!

when run application:

http://i18.tinypic.com/2zqcwtf.jpg

 

startup alert from microsoft:

http://i18.tinypic.com/4c24ldi.jpg

 

error for connecting:

http://i16.tinypic.com/4dg2j9j.jpg

 

is there any article or sample about network programming by c#.net and ms access or sql server?

[amir100]

I'm really confused here. :D

 

Have you tried accessing your .mdb file directly? Did you have trouble accessing it?

 

Was your server included in your "Local Intranet Zone"? If not the your server would still be considered a site from the Internet. That way changing the security level in your "Local Intranet Zone" will not effect anything.

 

Hope this helps.