Hi,
Is is correct to say that if I download the connector
http://dev.mysql.com/downloads/connector/odbc/5.1.html
and use MariaDB, I can use MySQL with xHarbour without buying any other server licence? Or do I need someting else?
Thanks,
Marc
Marc
SQL Server Express is a free edition of SQL Server ideal for developing and powering desktop, web and small server applications.
http://www.microsoft.com/sqlserver/en/u ... press.aspx
The beauty of using Ms Sql server is that you can use ADO SqlOleDB which is loaded on every Microsoft computer .. you will not need to download any clients or worry about configuring ODBC.
Deploy your app and use it from any Windows computer nothing else is needed.
Rick Lipkin
Marc:
If you use MariaDb then you don't need MySql and viceversa, and yes !, you need the
connector to use MariaDB or MySql with ADO.
I have a medium size app developed with ADO, xHarbour, FW and MySql, I made a test
with MariaDB and no change was necessary, all the code has been accepted.
Regards
Rick Lipkin wrote:Marc
SQL Server Express is a free edition of SQL Server ideal for developing and powering desktop, web and small server applications.
http://www.microsoft.com/sqlserver/en/u ... press.aspx
The beauty of using Ms Sql server is that you can use ADO SqlOleDB which is loaded on every Microsoft computer .. you will not need to download any clients or worry about configuring ODBC.
Deploy your app and use it from any Windows computer nothing else is needed.
Rick Lipkin
Armando wrote:Marc:
If you use MariaDb then you don't need MySql and viceversa, and yes !, you need the
connector to use MariaDB or MySql with ADO.
I have a medium size app developed with ADO, xHarbour, FW and MySql, I made a test
with MariaDB and no change was necessary, all the code has been accepted.
Regards
Marc:
As I know, the connector is free but MySql is Freeware, here is the link for mariaDB, perhaps is your best option.
Best regards
Local oRsRepair,cSql,oErr
Public xConnect
xPROVIDER := "SQLOLEDB"
xSOURCE := "YOURSQLSERVERNAME"
xCATALOG := "YOURDATABASENAME"
xUSERID := "user" // this username has to have permission
xPASSWORD := "password" // to login to the database
xCONNECT := 'Provider='+xPROVIDER+';Data Source='+xSOURCE+';Initial Catalog='+xCATALOG+';User Id='+xUSERID+';Password='+xPASSWORD
cSql := "Select * from YOURTABLE"
oRsRepair := TOleAuto():New( "ADODB.Recordset" )
oRsRepair:CursorType := 1 // opendkeyset
oRsRepair:CursorLocation := 3 // local cache
oRsRepair:LockType := 3 // lockoportunistic
TRY
oRsRepair:Open( cSQL,xCONNECT )
CATCH oErr
MsgInfo( "Error in Opening REPAIR table" )
RETURN(.F.)
END TRY
xbrowse( oRsRepair )
oRsRepair:CLose()