Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: chris smith
  Where is chris smith?
 Yorkshire CH CH
 Barbados
 chris smith
 To: Cetin Basoz
  Where is Cetin Basoz?
 Izmir
 Turkey
 Cetin Basoz
 Tags
Subject: RE: updateing a mySQL database
Thread ID: 311071 Message ID: 311138 # Views: 32 # Ratings: 0
Version: Visual FoxPro 6 Category: Off-topic
Date: Wednesday, June 29, 2011 4:27:06 AM         
   


> >
> > Hello Cetin Thanks for your speedy response
> >
> > More Questions...the conection string is the tricky part for me I can use remote desktop and a VPN to connect to the file server and by extension connect to the mySQL database (OBDlC connector and Server IP from the VPN)
> > However I want to connect to the database via the internal alone and not throught the a remote desktop connection
> >
> > I hope that it clear what i want to do...
> >
> > thanks alot
> >
> > Chris Smithhi
>
> With backends like mySQL, MS SQL and such you don't need VPN. In connection string the server might be a URI or TCP/IP address of a server in the other end of world. I don't use mysql but MSSQL. Here are some sample connection strings:
>
>
handle = SQLStringConnect("Driver={SQL Server Native Client 10.0};server=www.discountasp.net;database=myDatabase;uid=cetin;pwd=basoz") 
> 
> 
> handle = SQLStringConnect("Driver={SQL Server Native Client 10.0};server=190.180.170.160;database=myDatabase;uid=cetin;pwd=basoz") 

>
> It is not a connection to a file server but service (unlike VF



P database mysql, mssql ... are service based).
>
> PS: You can for example get hosting from discountasp.net and connect to it as above. I had data there in the past.
>
> Cetin Basoz
>
> .Net has got better.Think about moving - check my blog:
> My Blog
> Blog (mirror) - sounds to be down


hi Cetin please can you tell me a good guide for setting up a server to be access over the inernet
Chris Smith

ENTIRE THREAD

updateing a mySQL database Posted by chris smith @ 6/28/2011 4:07:52 PM
RE: updateing a mySQL database Posted by Cetin Basoz @ 6/28/2011 4:45:36 PM
RE: updateing a mySQL database Posted by chris smith @ 6/28/2011 8:14:28 PM
RE: updateing a mySQL database Posted by Cetin Basoz @ 6/28/2011 10:58:08 PM
RE: updateing a mySQL database Posted by chris smith @ 6/29/2011 4:27:06 AM
RE: updateing a mySQL database Posted by Cetin Basoz @ 6/29/2011 7:09:54 PM
RE: updateing a mySQL database Posted by Cody Leaf @ 6/29/2011 7:44:54 PM
RE: updateing a mySQL database Posted by Mike Yearwood @ 6/29/2011 4:36:13 PM
RE: updateing a mySQL database Posted by chris smith @ 6/29/2011 5:34:17 PM