Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: afzal afzal
  Where is afzal afzal?
 mumbai
 India
 afzal afzal
 Tags
Subject: mysql connection
Thread ID: 288897 Message ID: 288897 # Views: 32 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Foxite Downloads
Date: Saturday, December 25, 2010 1:14:08 PM         
   


******************************************************
* Author Afzal - India *
******************************************************
&& Note Write this codes or juz copy paste into mysqlcon.prg name


SET TALK OFF
SET SAFETY OFF
SET EXCLUSIVE OFF

dbname = 'mydatabasename'
username = 'mysqlusername'
pass = 'mysqlpassword'


dbcon = "Driver={MySQL ODBC 3.51 Driver};Server=localhost;Database=dbname; User=username;Password=pass;Option=3;"

zcon = SQLSTRINGCONNECT(dbcon)
dberror(zcon)
SQLSETPROP(zcon,"DispLogin",3)

RETURN zcon

this is ezy code n after tht use zcon as public variable

4 more detail contact on afzal@programmer.net, or follow me on hack2born@twitter.com

ENTIRE THREAD

mysql connection Posted by afzal afzal @ 12/25/2010 1:14:08 PM