Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Connecting to CMS MySql database via ODBC
Message
From
05/04/2007 04:03:08
 
 
To
05/04/2007 03:03:47
Vladimir Zhuravlev
Institute of the Physics of Earth,Russia
Moscow Region, Russia
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:
01212358
Views:
12
Hi Vladimir,
I know the drill connecting remotely to database;
My question was about general acceptance by providers to alow
direct read/write access to databases hosted at their premises.

Nonetheless, Thks for answer :)

>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 ;
> )
*****************
Srdjan Djordjevic
Limassol, Cyprus

Free Reporting Framework for VFP9 ;
www.Report-Sculptor.Com
Previous
Reply
Map
View

Click here to load this message in the networking platform