I've downloaded free driver for 32/64 bit ODBC-connection from Microsoft (http://www.microsoft.com/downloads/deta ... laylang=en)
for connecting to Access database and Ican run script from outside MLServer ok but not from the vbscript plugin. I've downloaded MLDatabase and the same problem here. Has anyone else this problem? Suggestion for solution?
Example script that runs ok outside MLSERVER
Code: Select all
'script to test connection
Const adOpenStatic = 3
Const adLockOptimistic = 3
Const adUseClient = 3
Set objConnection = CreateObject("ADODB.Connection")
Set objRecordset = CreateObject("ADODB.Recordset")
'Works ok outside MLServer
"Provider = Microsoft.ACE.OLEDB.12.0;" & _
"Data Source = Switchking.mdb"
'Open via DSN works ok outside MLServer
objRecordset.CursorLocation = adUseClient
objRecordset.Open "SELECT * FROM MLRF",objConnection,adOpenStatic, adLockOptimistic
strSearchCriteria = "ID = '17'"
If objRecordset.EOF Then
Msgbox "Record cannot be found."
Msgbox "Record found."