Can't get ODBC DSN to work using example

Originally posted by : Victor Tellez (vtellez@hgservices.com)I'm using the example.Paging certain # of records usingStored Procedure, Command Object and MS-SQL ServerI have IIS 5, and SQL 2000 I can't seem to get the correct setup for the DSN in the paging3.asp file to work.

Originally posted by : HeatherP (vhe009@aol.com)------------HeatherP 8/28/01Did you try the DSN Less connection First? You might want toHere is an example:Cut and paste this code into notepad and call it DatabaseConnect.aspWhen ever you are trying to access this particular database, you use afor asp at the begining of the file then you can access the database using SQL like thisim strSQLstrSQL = "SELECT Column1, Column2, Column3, FROM tblColumns ORDER BY Price DESC"'Create a recordset object instance, and execute the SQL StatementDim objRSSet objRS = Server.CreateObject("ADODB.Recordset")objRS.Open strSQL, objConn

Originally posted by : Jordan (jordan.michaels@wwcc.ctc.edu)Thanks for posting this Heather.I've tried it though and I get an odd error:Error Type:Microsoft OLE DB Provider for ODBC Drivers (0x80004005)[Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x92c Thread 0x910 DBC 0x204806c Jet'./catalog/test.asp, line 13Any idea what this could mean and how to fix it?Thanks in advance,Jordan------------HeatherP at 8/28/2001 3:05:00 PM------------HeatherP 8/28/01Did you try the DSN Less connection First? You might want toHere is an example:Cut and paste this code into notepad and call it DatabaseConnect.aspWhen ever you are trying to access this particular database, you use afor asp at the begining of the file then you can access the database using SQL like thisim strSQLstrSQL = "SELECT Column1, Column2, Column3, FROM tblColumns ORDER BY Price DESC"'Create a recordset object instance, and execute the SQL StatementDim objRSSet objRS = Server.CreateObject("ADODB.Recordset")objRS.Open strSQL, objConn