ODBC mysql problem



Simple asp code on a web page

Set oConn = Server.CreateObject("ADODB.Connection")
oConn.open "dsn=ds_tickotto;Initial Catalog=tickotto;UID=root;pwd=*****"

The set oconn works but when I hit oConn.open the page just hangs for a very
long time then fails with no error message.

this is a system dns data source on the web server, which, by the way works
when I test it in the odbc connections control panel.

Is this a permissions issue? It worked on our old server.

Thanks for any help


.