none
Cannot connect to a remote databse on the LAN RRS feed

  • Question

  • hi all,

    i'm developing a windows application by C#. net2 and i need to connect to remote database server in the same LAN,

    my data base is Foxpro data base and i'm using oledb connection

    the connection string is as follows :

    "Provider=VFPOLEDB.1;Data Source=\\server1\shared folder name\db.dbc;Collating Sequence=MACHINE;"

     

    i cannot connect to the remote database server unless i made a shared folder there containing the DB and give access right for this shared folder to the users who will use my windows application and this is a problem

    because not all users have the access right to open and view the database files

    i need a solution without using a shared folder , is there somthing wrong in the connection string or is there some window security authintication missed...

    can any body give me the answer ?

    thx alot

     

    Sunday, February 3, 2008 1:33 PM

All replies

  • Hello,

     

    Sorry, but i think that your question would better be answered on a FoxPro Forum

     

    http://forums.microsoft.com/MSDN/default.aspx?ForumGroupID=17&SiteID=1

     

    I know there is a site with connection or connectionstring in its name where , for every provider, your can find the syntax of the connectionstring and explanations for each keyword. But i don't remember its name

     

    Error i found it: http://www.connectionstrings.com/?carrier=visualfoxpro

     

    Are you sure that FoxPro databases are accessible outside from the computer where the database resides ?

     

    I'm not a specialist of FoxPro, maybe i'm doing an error

     

    Have a nice day

    Sunday, February 3, 2008 1:57 PM
  • I don't quite understand why what you're experiencing is a problem.  If you want to give multiple users access to your database, you have to put it some place that can be shared.  A user who doesn't have the rights to open and view your database shouldn't be able to run a program that opens and views your database either.  What is it you want?

    Sunday, February 3, 2008 11:57 PM
  •  

    By setting the DB folder to a shared folder on my LAN this means that all the users that using my application can open and view all the DB tables by opening the folder and explore any table they want, and this is a problem because the data is confidential and not all users can view all data there is a restriction on each user , so the solution of shared folder is not a suitable for my case i need to connect to the DB without making a shared folder

    Monday, February 4, 2008 9:04 AM
  • Does FoxPro enable you to set permissions by database object (e.g. table)? Or, do you have to provide access to all objects in the file? This is typically a limitation of file based database systems.

     

    BTW, you don't have to provide everybody with access to the folder. You can create an NT group in your domain that provides permissions to the file or folder and then add only those users to the group who need to have access.

     

    Monday, February 4, 2008 2:25 PM