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 youre creating a desktop application, Im guessing you have to allow your client to access your database location. But since youre using Access, I guess youll 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 youre client can access your application and your database from that shared folder right? If thats the case then shouldnt you be changing your connection string property?

It is true that your application are running in the clients computer. But then your application will look for the database in the clients computer. Isnt 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. Youll see the "Tasks" page. Click "Adjust Zone Security".

Maybe thats 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 PlausiblyDamps 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. Youll 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 youll get the drift. You simply set your "Local Intranet Zone" closer to "Full Trust".

I believe youre dealing with basic windows file sharing here. I dont if thisll 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:

startup alert from microsoft:

error for connecting:

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

 

[amir100]

Im really confused here.

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.