Cannot Connect to MySQL RunTime with D2006 / MyDAC 4.40
Posted: Mon 25 Sep 2006 18:02
i have an app in which i can open MyConnection Designtime fine.
when i try to open it runtime, i get an error 10061 and then Lost
Connection to MySQL Server During Connection. Interestingly, i
have another app which works fine and the connection has the
same settings (check the dfm file). The settings are:
object MySQLConnection: TMyConnection
Database = 'afpconf'
Username = 'TheUser'
Password = 'happy'
Server = '192.168.1.2'
LoginPrompt = False
Left = 600
Top = 432
end
and
object MySQLConnection: TMyConnection
Database = 'afpconf'
Username = 'TheUser'
Password = 'happy'
Server = '192.168.1.2'
LoginPrompt = False
Left = 169
Top = 13
end
if i leave it connected in design time and then
run it, i get the same error which, this time seems
to occur before the datamodulecreate event.
the working app does not have the mysqlconnection
in a datamodule whereas the problem app does.
I am running MySQL 4.1. I have BDS2006E with
update 2 and hotfix 1, 3, 5. i have MyDAC 4.40.0.18
and SDAC 3.80 (which is not used in these apps).
This application ran a year ago under D2005E (if that
helps). In fact, it just ran correctly on a different computer
which has D2005E on it and MyDAC 4.00.16
Both computers have the same LibMySQL.DLL and LibMySQL_C.DLL
files on them.
when i try to open it runtime, i get an error 10061 and then Lost
Connection to MySQL Server During Connection. Interestingly, i
have another app which works fine and the connection has the
same settings (check the dfm file). The settings are:
object MySQLConnection: TMyConnection
Database = 'afpconf'
Username = 'TheUser'
Password = 'happy'
Server = '192.168.1.2'
LoginPrompt = False
Left = 600
Top = 432
end
and
object MySQLConnection: TMyConnection
Database = 'afpconf'
Username = 'TheUser'
Password = 'happy'
Server = '192.168.1.2'
LoginPrompt = False
Left = 169
Top = 13
end
if i leave it connected in design time and then
run it, i get the same error which, this time seems
to occur before the datamodulecreate event.
the working app does not have the mysqlconnection
in a datamodule whereas the problem app does.
I am running MySQL 4.1. I have BDS2006E with
update 2 and hotfix 1, 3, 5. i have MyDAC 4.40.0.18
and SDAC 3.80 (which is not used in these apps).
This application ran a year ago under D2005E (if that
helps). In fact, it just ran correctly on a different computer
which has D2005E on it and MyDAC 4.00.16
Both computers have the same LibMySQL.DLL and LibMySQL_C.DLL
files on them.