Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Boudewijn Lutgerink
  Where is Boudewijn Lutgerink?
 Hoonaardstraat, Driel
 Netherlands
 Boudewijn Lutgerink
 To: Mitesh Mota
  Where is Mitesh Mota?
 Mumbai
 India
 Mitesh Mota
 Tags
Subject: RE: Net Server Database
Thread ID: 122439 Message ID: 122472 # Views: 47 # Ratings: 2
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Tuesday, February 20, 2007 10:48:05 AM         
   


> Hi Experts,
>
> I am using SqlStringConnect() And SqlExec() in my program to access Local Server Database. I want to upload the database on Net Server (Internet / Website folder). I dont know what to specify in connection string.
>
> Right now i am using connection string as follows:
> DSN=MS Access Database
> DBQ=MyData.Mdb
> DefaultDir=C:\MyProgram\Data
> UID=ADMIN
> PWD=PASSWORD
> DriverId=25
> FIL=MS Access
> MaxBufferSize=2048
> PageTimeout=5
>
> What changes i have to make in this, if i want to access database on the net? Also the username and password specified in the connection string are of database, where to specify the username and password of net server account?
>
> Please give me the details for Sql Server database also.
>
> Thanks in Advance.
>
> Regards,
> Mitesh

Considering my last reply in thread 122325, I would like to start out with some questions.
WHY do you want to have you database accessible through a Webserver?
What logic is behind it. What is the requirement that makes this a MUST.

Following the previous question, what do you want to achieve. maybe there ARE alternatives.

My questions come from the concern that placing data on a webserver CAN be dangerous in that the data may be downloaded from the server by others who you might not want to even get their preying eyes on your data.

Boudewijn LutgeĀ®ink
http://www.vfpdevelopers-online.com
The attitude of "An eye for an eye and a tooth for a tooth" will make this world toothless and blind (Gandhi)

COMPLETE THREAD

Net Server Database Posted by Mitesh Mota @ 2/20/2007 5:24:49 AM
RE: Net Server Database Posted by Boudewijn Lutgerink @ 2/20/2007 10:48:05 AM
RE: Net Server Database Posted by Mitesh Mota @ 2/21/2007 5:42:53 AM
RE: Net Server Database Posted by tushar @ 2/21/2007 6:23:05 AM
RE: Net Server Database Posted by Mitesh Mota @ 2/22/2007 5:06:50 AM
RE: Net Server Database Posted by Ken Murphy @ 2/22/2007 1:21:22 PM
RE: Net Server Database Posted by Boudewijn Lutgerink @ 2/21/2007 10:00:18 AM
RE: Net Server Database Posted by Mitesh Mota @ 2/22/2007 5:02:54 AM