Re: How to get mysql installation path ?

[Jay Alverson]

Just an FYI, this works in VBScript...

dim adoConn
dim adoRS
dim MySQL_STRING
dim MyID

' "DRIVER={MySQL ODBC 5.1 Driver};SERVER=localhost;DATABASE=test;UID=Winbatch;PWD=WBTPassword;OPTION=35;"

set adoConn = CreateObject("ADODB.Connection")
set adoRS = CreateObject("ADODB.Recordset")
adoConn.open = "FileDSN=P:\MYSQL\Excel-Query\VBS-MySQL.dsn"
adoRS.ActiveConnection = adoConn

adoRS.Source = "select @@datadir"
adoRS.Open

msgbox adoRS.Fields("@@datadir"),,"Data directory"

Thanks, Jay