Hello all. I have a section of code that someone was kind enough to help me out with, and it worked great on the localhost. The problem started when I uploaded the application the my remote server. The rest of the application is working fine, it is just failing on the following section. This is the error:



Microsoft OLE DB Provider for ODBC Driverserror '80004005'
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified /PickDateLast1.asp, line 38


... and this is the code: (line 38 happens to be the section in red)

 
<%
'Delete any records form the Temp_Date table with current Session(MM_Username)
Dim oConn, oRS, sQry
Dim sConn
set oConn = Server.CreateObject("ADODB.Connection")
'Relpace Xxxxx with the name of your dsn
sConn = "Data Source=Timesheet;"
oConn.Open sConn
Set oRS = Server.CreateObject("ADODB.Recordset")
Set oRS.ActiveConnection = oConn
'SQL RecordSet 
'Change tablename to the name of the table in your database
sQry = "DELETE * FROM Temp_Date WHERE UserName =  '" & SesUserName & "' "
oRS.Open sQry
%>

I would appreciate any suggestions.

Thanks in advance,

Parallon

The dsn doesn't exist on the server