MySql Connection Problem
lazarus / 16-Databases

----------------------------------------------------------------------
codeman · 2014-12-01 16:22

I use this MySql host provider : freemysqlhosting.net
Firstly i got an error that "libmysql.dll"  can not be loaded but i
fixed that , i added that lib to my project's folder but now i get
another error which says "Access Violation" , what should i do?


My code
Code: [Select]   conn.HostName:='sql2.freemysqlhosting.net';
    conn.DatabaseName:='sql259998';
    conn.UserName:='sql259998';
    conn.Password:='*******';
    conn.Transaction:=trans;   // ACCESS VIOLATION HERE
    trans.Database:=conn;
    trans.Active:=true;
    sql.Database:=conn;
    sql.Transaction:=trans;
    sql.UsePrimaryKeyAsKey:=False;
    conn.Open;

----------------------------------------------------------------------
TheOddOne · 2014-12-01 16:46

Have you made sure that youve allowed your ip address to access the
database via cpanel? Usually its under the heading remote mysql.

----------------------------------------------------------------------
codeman · 2014-12-01 18:40

Quote from: ThatGuyY on December 01, 2014, 05:46:41 pmHave you made
sure that youve allowed your ip address to access the database via
cpanel? Usually its under the heading remote mysql.

I donwloaded and connected successfuly with Mysql Administrator Client
if it helps..
I use mySQL comp. not IBConn or ODBC.. is it the correct one..
Also when i turn "Connected" property to true (of mysql connector) i
get Access violation msg.

----------------------------------------------------------------------
minesadorada · 2014-12-02 10:05

This topic prompted me to get a free account with freemysqlhosting and
give it a try.

I can report that it works fine under Windows using the unit 
mysql56conn.  The file libmysql.dll should be in the same directory as
the compiled (32-bit) app.

@the O.P. - you need to set the port property to 3306.