Database Programming issue

[WeCareTexas]

on http://wecaretexas.com/ListSearch.asp when you do a search I am receiving
and error. Until I tried to fix it I was getting a Microsoft Jet 4.0 error.

This site is being hosted on GoDaddy. Last week, there was a glitch on
another hosting company and I had to move the site and now it is broken and I
am clueless of how to resolve this issue.

Any help will be appreciated. I would like to have the site back up very
soon
--------------------------------------------------------------------------------------------
Here is the code with a issue:

<% if Request.QueryString("FN") <> "" then
dim con
dim rsMain
dim prjDesc
dim fnamelen
dim lnamelen

session("id")=""
set con=server.CreateObject("adodb.connection")
con.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & App.Path &
"\fpdb\lists.mdb"

'creating record set object
set rsMain = Server.CreateObject("ADODB.Recordset")
if rsMain.State=1 then rsMain.Close
if Request.QueryString("FN") <> "" then
rsMain.Open "select * from results where name like '"&
Request.QueryString("FN") &"%'",con
elseif Request.QueryString("FN") = "" then
end if
'Response.Write rsMain.Source

%>

 

[Mike Mueller]

You may want to move and or rename that database. Anyways it looks like that
directory is set for Execute or Script permissions only, and Read access is
denied.

The error page is telling you exactly where your current issue is- which
line of code is line #62?

 

[WeCareTexas]

Thank You,

Line 62: con.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" &
App.Path & "\fpdb\lists.mdb"

I will attempt to repermission the folders.

 

[WeCareTexas]

Thank You,

Line 62: con.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" &
App.Path & "\fpdb\lists.mdb"

I will attempt to repermission the folders.

 

[WeCareTexas]

http://wecaretexas.com/listsearch.asp?FN=gr this was the original error I
was getting.

 

[Thomas A. Rowe]

Contact your web host and ask them to run a server extensions health check and let FP correct the
permissions for the site.

--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage

http://www.Ecom-Data.com
==============================================

 

[WeCareTexas]

Thank you, that helped. The remaining issue is that the database is corrupt.
Advanced Access Repair in the demo mode fixed it, but I do not have that
type of money to purchase the software, so the primary Katrina database is
going to remain unavailable until further notice.

Thank you for the help.

 

[Mike Mueller]

You do have a backup of this file, and can re-upload it, right?

 

[Thomas A. Rowe]

Contact me via my site below.

--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage

http://www.Ecom-Data.com
==============================================