I apologize for this message being in the wrong area, but I am in dire straits.

I am attempting to create an Active Server Page using VBScript. This page is called from the submit of an HTML form consisting of user entered data. The VBScript takes this data via request("FormFieldName"), makes a connection to a System DSN to an Access Database, and performs an INSERT INTO into a specific table.

Very simple task to perform. Or so I thought.

Doing a test on a local server, this principle worked fine. Although, the application located on a different server doesn't. Specifically, the app can't seem to make an ODBC connection to the database.

Sample script to establish connection is :

set cn=Server.CreateObject("ADODB.Connection")
set cm=Server.CreateObject("ADODB.Command")
cn.Open "DSN=DSNname"

Is there something I may be missing??? Or what?