> 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)