Connecting to mySQL database

[Papa Bear]

Hi All

I have got a web site running OK for 3 years using a DSN to connect to a mySQL database. I am no tying to connect DSNless, but get "500 - Internal server error." NO other message. Can any body see what I am doing wrong! The second line worked untill yesterday when my hosting company "UPGRADED" my hosting package forcing me to go this route (which I should have done ages ago).

set DBconn=server.createobject("adodb.connection")
'DBconn.open "dsn=someDSN"
DBConn.open "driver={MySQL ODBC 3.51 Driver};server=123.345.789.123;uid=userID;pwd=password;DATABASE=PoyntonDB;"

 

[guitarzan]

First, see faq333-5427 to get a better error message than "500 - Internal server error.

 

[Papa Bear]

Thanks for the tip guitarzan.

I have copied my code to another host, and it works from there!! So the fault lies with my current hosting company. Left it with them

 

[ChrisHirst]

Are both systems hosted on Linux/Unix?

Because database names are case sensitive for mysql on linux systems whereas mysql on windows is not.

Chris.

Indifference will be the downfall of mankind, but who cares?
Time flies like an arrow, however, fruit flies like a banana.