I'm traditionally a java developer but have been tasked with enhancing a classic ASP web app to persist data to a DB2 database. When trying to create an ODBC connection I keep getting the following error...

Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

The code from my ASP page looks like this...

Dim conn, rs, sql
Set conn = Server.CreateObject("ADODB.Connection")
Set rs = Server.CreateObject("ADODB.RecordSet")
conn.Open "Driver={IBM DB2 ODBC DRIVER}; Database=ECDEV; Hostname=XX.XX.X.XX; Port=50001; Protocol=TCPIP; Uid=XXXXXXXX; Pwd=XXXXXXXX;"
sql = "SELECT ........"
rs.Open sql, conn

The error comes on the open statement. This same connection string is being used by other applications and works fine. The only difference is that these other applications don't run on the same physical box as mine. But since I'm using a DSN-less connection should that matter? I don't think I've left anything out of the string that's required.

Any ideas on what could be causing the problem?