What I need to do is very simple, I need to duplicate an Access 97 database into a MySql database. I have mysql and myodbc installed on a Win 98 machine (Development machine) and everything works fine. The problem I have is that MyODBC bombs when trying to connect to the actual Unix webserver. I get the following message:
[TCX}[MyODBC]Access denied for user: <!-- e --><a href="mailto:'[email protected]">'[email protected]</a><!-- e -->' (Using password: YES)(#2000)
I am pretty sure that this is a problem in the way the host entry in the Mysql database is setup on the unix server. However I have not been able to figure out how the host record should be created. Any suggestions on how to correct this problem?
And I guess I should add that I live in a stone age area where DSL and cable access are but a pipe-dream, so therefore my ip number changes upon every connection.
Thanks for any help.
Ray
[TCX}[MyODBC]Access denied for user: <!-- e --><a href="mailto:'[email protected]">'[email protected]</a><!-- e -->' (Using password: YES)(#2000)
I am pretty sure that this is a problem in the way the host entry in the Mysql database is setup on the unix server. However I have not been able to figure out how the host record should be created. Any suggestions on how to correct this problem?
And I guess I should add that I live in a stone age area where DSL and cable access are but a pipe-dream, so therefore my ip number changes upon every connection.
Thanks for any help.
Ray