Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Enum. ODBCs available
Message
De
13/06/2007 10:15:12
 
 
À
13/06/2007 09:46:15
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 XP SP2
Network:
Windows XP
Database:
MySQL
Divers
Thread ID:
01232563
Message ID:
01232578
Vues:
14
This message has been marked as a message which has helped to the initial question of the thread.
Hi,

this should do the trick ..
DECLARE SHORT SQLDrivers IN odbc32;
    INTEGER   EnvironmentHandle,;
    INTEGER   Direction,;
    STRING  @ DriverDescription,;
    INTEGER   BufferLength1,;
    INTEGER @ DescriptionLengthPtr,;
    INTEGER   DriverAttributes,;
    INTEGER   BufferLength2,;
    INTEGER   AttributesLengthPtr 


LOCAL lnRet, lnEnvHandle, lcDriver, lnBufferLen, lnCount, laDrivers[1]
lnEnvHandle = VAL(SYS(3053))
lnBufferLen = 1024
lcDriver = REPLICATE(CHR(0),lnBufferLen)
lnRet = SQLDrivers(lnEnvHandle, 2, @lcDriver, lnBufferLen, @lnBufferLen, 0, 0, 0)

lnCount = 1
DO WHILE lnRet = 0
	DIMENSION laDrivers[lnCount]
	laDrivers[lnCount] = LEFT(lcDriver,lnBufferLen)
	lnCount = lnCount + 1 
	lnBufferLen = 1024
	lcDriver = REPLICATE(CHR(0),lnBufferLen)
	lnRet = SQLDrivers(lnEnvHandle, 1, @lcDriver, lnBufferLen, @lnBufferLen, 0, 0, 0)
ENDDO

?'MySql ODBC driver is ' + IIF(ASCAN(laDrivers,'MySQL',1,-1,1,1+4+8) > 0,'installed','not installed')
Regards
Christian
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform