Fox Me Up


ok first off here is some info about my webserver:
i dont no if you needed the information but maybe you do


General server information:
Operating system Linux


Kernel version 2.6.17.11-grsechg
Machine Type i686
Apache version 1.3.37 (Unix)
PERL version 5.8.7
Path to PERL /usr/bin/perl
Path to sendmail /usr/sbin/sendmail


PHP version 4.4.4
MySQL version 4.1.21-standard
cPanel Build 10.9.0-CURRENT 117
Theme cPanel X v2.6.0
Documentation Click to View



i pay about 8$ a month for it.

i used phpMyAdmin
to create a table and the fields which worked great.

after i did that i created a simple web page to submit information into the file. which worked great.

now is there anyway from visual foxpro that i can connect to this database and have it all come back to me in a nice cursor or have it come back to me in anything
i have never done anything with vfp and the internet so assume i dont know much.

any suggestions will be much appreciated. plz help me :)






Re: application and webdata interacting.

Alex Feldstein


See these articles by Rick Strahl:

Building distributed Web Applications with Visual FoxPro

http://www.west-wind.com/presentations/wchttp.htm

Internet enabling Visual FoxPro applications

http://www.west-wind.com/presentations/internetenabling/InternetEnabling.htm






Re: application and webdata interacting.

dni

To connect to database you need to have MySQL ODBC driver installed and to build a connection string.





Re: application and webdata interacting.

Fox Me Up

" To connect to database you need to have MySQL ODBC driver installed and to build a connection string. "


can you please tell me how to do all that




Re: application and webdata interacting.

Alex Feldstein

I understood you wanted to connect from the client side. From server side, you need the ODBC driver (or OleDB Provider) .

See here for connection string examples:

http://www.carlprothman.net/Default.aspx tabid=90#ODBCDriverForMySQL

http://www.carlprothman.net/Default.aspx tabid=87#OLEDBProviderForMySQL





Re: application and webdata interacting.

Fox Me Up

ok i downloaded and installed
MySQL ODBC 3.51 Driver

now im trying to configure the connection but i keep getting this error


[MySQL][ODBC 3.51 Driver]Access denied for user 'kyle_Kyle'@'131.91.236.13' (using password: YES)

i dont get it... all the info seems to be correct




Re: application and webdata interacting.

Fox Me Up

Alex Feldstein wrote:

I understood you wanted to connect from the client side. From server side, you need the ODBC driver (or OleDB Provider) .

See here for connection string examples:

http://www.carlprothman.net/Default.aspx tabid=90#ODBCDriverForMySQL

http://www.carlprothman.net/Default.aspx tabid=87#OLEDBProviderForMySQL



i do want to connect from the client side.




Re: application and webdata interacting.

dni

Driver={MySQL ODBC 3.51 Driver};Server=localhost;Database=myDataBase;User=myUsername;Password=myPassword;Option=3;




Re: application and webdata interacting.

Fox Me Up

ok but why would it be local host    shouldnt it be the ip address to my server


on php my admin it says connection strings like this for the following


Connection Strings
Perl $dbh = DBI->connect("DBI:mysql:kyle_KMPRODBF:localhost","kyle_Kyle","<PASSWORD HERE>");
PHP $dbh=mysql_connect ("localhost", "kyle_Kyle", "<PASSWORD HERE>") or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ("kyle_KMPRODBF");

i cant connect for some reason.





Re: application and webdata interacting.

AndyKr

Yes, it should be your domain: See www.connectionstrings.com for the examples:

But you need to specify the Driver, Domain, Port, Database and User Name/Password/Mode like this:

Driver={Driver};Server=data.domain.com;Port=3306;Database=X;User=Y;Password=Z;Option=3;






Re: application and webdata interacting.

Fox Me Up

i think the problem is because i can never go on the server side because i purchase this from a web hosting company... do i need to get my own server in order for it to work




Re: application and webdata interacting.

Alex Feldstein

 Fox Me Up wrote:
i think the problem is because i can never go on the server side   because i purchase this from a web hosting company... do i need to get my own server in order for it to work

No. If you have a contract with a good web hoster, you either have your own server there or you are co-located in their servers. In any case you should get the following minimum services:

- web server

- database server (MySQL in your case)

- FTP access so you can work remotely as web and data base admin

This way you can work on the server side as if you were there.

They provide the other ancillary servies you do not need to worry about, connectivity, firewall, backups, etc.

 





Re: application and webdata interacting.

Fox Me Up

i installed MySQL ODBC 3.51 Driver on my local computer not my server. how would i install it on my web hosting server

i think my problem is im 19 with only a couple years experience. www.kmprofessional.com (view power point) if you want to see some of my vfp work.