Hello everybody,

My site is working fine on local systems, but when I uploaded it to the hosting server, it gives following error.

Code:
ADODB.Command error '800a0e7d' 

Requested operation requires an OLE DB Session object, which is not supported by the current provider. 

/motorcarbeta/include/database.asp, line 35
This is how I am trying to fetch the data.

VB Code:
  1. Function ConnectDatabase()
  2.         If Not objConnection.State = adStateOpen Then
  3.             On Error Resume Next
  4.             objConnection.ConnectionString = ConnectionString
  5.             objConnection.Open()
  6.             objConnection.ConnectionString = ConnectionStringForOuterPages
  7.             objConnection.Open()
  8.         End If
  9.     End Function
  10.  
  11.     Function ExecuteReader(Sql)
  12.         Dim objCommand     
  13.         Dim objRecordset
  14.         Set objCommand = Server.CreateObject("Adodb.Command")
  15.         Set objRecordset = Server.CreateObject("Adodb.Recordset")
  16.        
  17.         objRecordset.CursorType = adOpenDynamic
  18.         objRecordset.LockType = adLockOptimistic
  19.         objRecordset.CursorLocation = adUseClient
  20.        
  21.         ConnectDatabase()
  22.         objCommand.ActiveConnection = objConnection
  23.         objCommand.CommandText = Sql
  24.         objCommand.CommandType = adCmdText
  25.         Set objRecordset = objCommand.Execute()
  26.  
  27.         Set ExecuteReader = objRecordset
  28.     End Function

Thanks.