Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Connecting to CMS MySql database via ODBC
Message
De
05/04/2007 04:03:08
 
 
À
05/04/2007 03:03:47
Vladimir Zhuravlev
Institute of the Physics of Earth,Russia
Moscow Region, Russie
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows Server 2003
Database:
MySQL
Divers
Thread ID:
01212345
Message ID:
01212358
Vues:
11
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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform