Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Connecting to CMS MySql database via ODBC
Message
From
05/04/2007 03:03:47
Vladimir Zhuravlev
Institute of the Physics of Earth,Russia
Moscow Region, Russia
 
 
To
05/04/2007 02:44:30
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows Server 2003
Database:
MySQL
Miscellaneous
Thread ID:
01212345
Message ID:
01212347
Views:
10
Here is the sample from www.foxclub.ru
Lparameters m.host, m.db, m.user, m.pass

m.host=Iif(Empty(m.host),"localhost",m.host)

m.db=iif(empty(m.db),'',m.db)
m.user=iif(empty(m.user),'',m.user)
m.pass=iif(empty(m.pass),'',m.pass)

SqlSetProp(0,"DispLogin",3)
SqlSetProp(0,"DispWarnings",.F.)


Return SQLStringConnect(;
"DRIVER=MYSQL3"+;
";SERVER="+m.Host+;
";DB="+m.DB+;
";OPTION=25"+;
";UID="+m.User+;
";PWD="+m.Pass ;
)
MVP-2006-2011, PHD in Math and Physics ,
host of www.foxclub.ru,
VFP lector at Interface and Microinform companies
Head science researcher of VNIIA Rosatom.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform