FW_OpenAdoConnection() question

[Marc Vanzegbroeck]

Hi,

Normally I use something like, and is working fine:

Code: Select all  Expand view

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

Code: Select all  Expand view

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"
   endif
 

The error is


I use FWH64-16.04 (build 3)

[Marc Vanzegbroeck]

I found the problem.

I use a connectionstring "{MySQL ODBC 5.2w Driver}".
This not included in the saProviders-array in addofuncs.prg

now I use

Code: Select all  Expand view

oCn   := FW_OpenAdoConnection(  "Driver={MySQL ODBC 5.2w Driver};Server=localhost;Port=3306;Database=MyDatabase;User=root;Password=MyPassword;Option=3;", .t. )

And it's working

[nageswaragunupudi]

Thanks for the information.
We shall now include 5.2w also.

Even otherwise, from 16.05 onwards, if FW_SetUnicode() is true, connection is made to Unicode driver and in that case connecting to 5.2w might succeed