I've written an ASP to transfer data between a flash app and an Access database. However now the database was moved to MS SQL server 7 and the ASP no longer connects. I'm using a DSN and all the names have been changed in the ASP. I've never worked with SQL server before and I don't know how to get this working. If anyone knows how to do this please help.

The code looks like this right now:

Set conn = Server.CreateObject("ADODB.Connection")
conn.ConnectionTimeout = 1
conn.CommandTimeout = 1
conn.open dsnName