After i upload the site i got an error on a page which was working on
the localhost.the error is
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Oracle][ODBC]Option value changed.
/arabic/adv_result.asp, line 244
this line is where i open the recordset. the connection to the database
is the same connection for the localhost and the hosting server.
this is the code i have problem in it:
<%'the connection to the orcale database server
set con=server.createobject("adodb.connection")
con.open "DSN=micn_db;UID=mic_news;PWD=micn;"
counts=0 'the variable which holds the numbers of records
s_text=request("text") 'the variable which holds the string i'm
searching for in the database
'the recordset in which i receive the data
set rs_search=server.createobject("adodb.recordset")
'i use this recordset to count the records i get
set rs_searchc=server.createobject("adodb.recordset")
'the sql statement i use
sql_search="select n_data.news_title, n_data.news_id,
n_data.news_date,n_source_lkp.source_desc from
mic_news.n_data,n_source_lkp where (n_source_lkp.source_desc like
'%"&s_text&"%') and n_data.area_id=1 and ((n_data.news_ref_date >=
'07/06/2005') or (n_data.news_ref_date <='21/07/2005')) and
n_source_lkp.source_id = n_data.source_id order by news_priority,
news_date; "
'here is wher i get the error in the opening of the recordset
rs_search.open sql_search,con,2,3
'to count the records i get from the previous sql statment
rs_searchc.open sql_search,con,1,3
'to display the data
if not rs_search.eof then
counts=counts+(rs_searchc.recordcount)
%>
<tr>
<%do until rs_search.eof%>
<tr>
<td><a
href="newscont.asp?n_id=<%=rs_search(1)%>"><%=rs_s earch(0)%></a>
</td>
</tr><tr>
<td><font size="2"
color="#C0C0C0"><%=rs_search(3)%>   ; <%=rs_search(2)%> </font></td>
</tr>
<%
rs_search.movenext
loop
end if
rs_search.close
rs_searchc.close
%>
i want to know why did this code work on the localhost and it didn't
work on the hosting server.
Note: the database server is the same hosting server and i use it also
on the localhost. and all the other asp pages work fine on both
environment (localhost and the hosting server).