Hi,
Normally I use something like, and is working fine:
to open my MariaDB-database.
Now I wanted to try this with FW_OpenAdoConnection(), but get an error opening the database:
I try with
The error is

I use FWH64-16.04 (build 3)
Normally I use something like, and is working fine:
oSQL:=CreateObject("ADODB.Connection")
oSQL:ConnectionString:="Driver={MySQL ODBC 5.1 Driver};Server=localhost;Port=3306;Database=MyDatabase;User=root;Password=MyPassword;Option=3;"
oSQL:Open()to open my MariaDB-database.
Now I wanted to try this with FW_OpenAdoConnection(), but get an error opening the database:
I try with
local oCn
local cServer   := "localhost"
local cDataBase  := "MyDatabase"
local cUser    := "root"
local cPassWord  := "MyPassword"
  oCn  := FW_OpenAdoConnection( { "MYSQL", cServer, cDataBase, cUser, cPassword }, .t. )
  if oCn == nil
   ? "Connection Fail"
   return nil
  else
   ? "Connected"
  endifThe error is
I use FWH64-16.04 (build 3)
Regards,
Marc
FWH32+xHarbour | FWH64+Harbour | BCC | DBF | ADO+MySQL | ADO+MariaDB | ADO+SQLite
Marc
FWH32+xHarbour | FWH64+Harbour | BCC | DBF | ADO+MySQL | ADO+MariaDB | ADO+SQLite