Please help with hosting

[stephen_uk]

Does anyone know if asp and mysql work well together?

Many Thanks

Stephen

[digiphreak]

yeah they work fine

[wOOmba]

PHP is better.

[monster]

Agreed!

Which ever route you choose ensure to review coding practice documents before implementing your software - a little time planning for future growth upfront can (and most likely will!) save you alot of time and thus money down the road

[stephen_uk]

Could eny one please help?

I have installed MySQL and MyODBC successfully.



If i try to create a system DSN and test it the following message appears:

[MySQL][ODBC 3.51 Driver]Can't connect to MySQL server on 'localhost' (10022)



If I try to use the DSN in the code to connect to thye database I get the following error:

Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[MySQL][ODBC 3.51 Driver]Can't connect to MySQL server on 'localhost' (10022)

Can anyone please help it would be very much appreiciated

Many Thanks

[usahostme]

yes they work fine.. for more info go to usahostme.com ans ask your questions, I am sure somebody will help you..

[monster]

I'm guessing you have this fixed by now, but that sounds like its one of the following:
- mysql server is not running
- mysql server does not have the user configured properly to access it
- connection information is not configured properly in your application (username, password, host, connection method)

Originally Posted by stephen_uk

Could eny one please help?

I have installed MySQL and MyODBC successfully.



If i try to create a system DSN and test it the following message appears:

[MySQL][ODBC 3.51 Driver]Can't connect to MySQL server on 'localhost' (10022)



If I try to use the DSN in the code to connect to thye database I get the following error:

Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[MySQL][ODBC 3.51 Driver]Can't connect to MySQL server on 'localhost' (10022)

Can anyone please help it would be very much appreiciated

Many Thanks

[stephen_uk]

Nope still not fixed :-)

Its seems to be running ok and I can access the databases using the mysql control centre?

Thanks for the Help

[guteru]

My guess is the mysql server is not running on "localhost" - are you sure that is the right hostname?

If you have a windows hosting account it is not unusual for the hosting company to actually have the mysql running on a seperate linux machine. So your hostname could very well be something like "mysql-server1.hostingco.com" - check the hosting company's help center/FAQ. If they dont have a help center try a new hosting company, too!

[stephen_uk]

MySQL is running on my laptop which is not connected to the net, i can run MySQL and add databases and tables. Does this mean it is not connected to another host?

Thanks for the help!