Typically, there are 2 major reasons why you receive this error.
- The ASP scripting has some sort of loop or incorrect DSN connection statement.
- Something with the DSN or driver is incorrectly configured.
Here are a few steps that you can go through to debug this error:
- Please take a look at the ASP script that calls the database. The database call should be using a DSN (Data Source Name). Here is one example of how to connect to a database using a DSN. Confirm that the scripting logic is correct as well.<%
- set rs=Server.CreateObject(“adodb.Recordset”)
- connect=”DSN=EXAMPLENAME”
- sqlstmt = “SELECT * from table WHERE condition=’value’ order by column”
- rs.open sqlstmt, connect
- %>
- Confirm that the DSN is setup by going into the SMT/cpanel as webadmin@yourdomain. Click clicking Additional Services, then Manage, then Manage ODBC DSN. From this interface, you can see which DSNs have been created or add one if you do not currently have one.
- If these steps have not proven helpful, then you can submit a Trouble Ticket to Customer Service at //order.aitcom.net