Hi!:D
Hope somebody here can help me before i tear all my hair out... (you know the filing, a?)

Here's my problem:
I am developing a web page, where only a part will have asp (for news). And the whole things works fine on my local server, but not on my remote server.
I can access the admin pages also on the remote server, can add new data, update them... But when i want to access the asp page where the data should appear, I get an error and the page doesn't display.

The error message says:
Microsoft JET Database Engine error '80004005'

'D:\inetpub\wwwroot_novo\fakulteta\studentske_stra ni\bibliotekarstvo\database\bink.mdb' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.

/fakulteta/studentske_strani/bibliotekarstvo/bink_asp2/oglasna.asp, line 9

In line 9 of the page that does not display says: rsPosts_cmd.ActiveConnection = MM_connBink_STRING

And my string is written like this:
Dim MM_connBink_STRING
MM_connBink_STRING = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("/database/bink.mdb") & " ; User ID=; Password=;"

Does anyone has any idea how to solve this problem??? I would be most grateful... I suspect that the problem is somewhere in the path as according to my logic and the structure of the page the following link is not correct (it should also contain the text in red]:

'D:\inetpub\wwwroot_novo\fakulteta\studentske_stra ni\bibliotekarstvo\bink_asp2\database\bink.mdb'

What do you think?

I would really need to see the code to determine what the problem really is. If its already working on other pages it certainly isn't the ODBC connection on the remote server.

How do you call the database on each page. Are you using includes. Having the code would help me better give a solution to your problem.

mmmmmmm Access connection strings, reminds me of headaches....

The first error tells you the problem is on line 9, therefore there is a real good chance its your connection string. Try:

MM_connBink_STRING = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("/database/bink.mdb")

The above connection string is from a woring site, should do it for you. connectionstring.com is the lace to go for the best advice. After reading your last comment you have clearly found the problem, its a path issue in your connection string...

Wind is your friend
Matt

mat41: tried your suggestion, but unfortunately it doesn't work. I can not even access my admin pages as it gives me an error:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0xc24 Thread 0x568 DBC 0xc70e8b4 Jet'.

/fakulteta/studentske_strani/bibliotekarstvo/bink_asp2/admin/Default.asp, line 24

Will try looking on that web page.

mperry:
well it's working only on my local server, so i don't know... may be the connection string. At least when i couldn't access the admin pages I had to change my string (found the solution on this forum) and than it almost worked.

Here is the code from my "oglasna.asp", the page where news I add on admin pages should appear:

<%@LANGUAGE="VBSCRIPT"%>

<%
Dim rsPosts
Dim rsPosts_cmd
Dim rsPosts_numRows

Set rsPosts_cmd = Server.CreateObject ("ADODB.Command")
rsPosts_cmd.ActiveConnection = MM_connBink_STRING
rsPosts_cmd.CommandText = "SELECT dtePostDate, intCatID, intPostID, memPostText, txtPostTitle FROM tblObvestila ORDER BY dtePostDate DESC"
rsPosts_cmd.Prepared = true

Set rsPosts = rsPosts_cmd.Execute
rsPosts_numRows = 0
%>
<%
Dim rsCategories
Dim rsCategories_cmd
Dim rsCategories_numRows

Set rsCategories_cmd = Server.CreateObject ("ADODB.Command")
rsCategories_cmd.ActiveConnection = MM_connBink_STRING
rsCategories_cmd.CommandText = "SELECT intCatID, txtCatName FROM tblCategory ORDER BY intCatSort ASC"
rsCategories_cmd.Prepared = true

Set rsCategories = rsCategories_cmd.Execute
rsCategories_numRows = 0
%>
<%
Dim Repeat1__numRows
Dim Repeat1__index

Repeat1__numRows = -1
Repeat1__index = 0
rsPosts_numRows = rsPosts_numRows + Repeat1__numRows
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">

<%=(rsCategories.Fields.Item("txtCatName").Value)% ></p>

    <%
While ((Repeat1__numRows <> 0) AND (NOT rsPosts.EOF))
%>
      <div id="post">

        <p class="date"><%=(rsPosts.Fields.Item("dtePostDate" ).Value)%></p>
        <p class="obvestilo"><b><%=(rsPosts.Fields.Item("txtP ostTitle").Value)%></b><br />
            <%= Replace(rsPosts.Fields.Item("memPostText").Value, Chr(10), "<br />")%></p>
      </div>
      <%
  Repeat1__index=Repeat1__index+1
  Repeat1__numRows=Repeat1__numRows-1
  rsPosts.MoveNext()
Wend
%

I just tries the simplest solution and it actually works.

I changed my connection string datasource:

Data Source='D:\inetpub\wwwroot_novo\fakulteta\students ke_strani\bibliotekarstvo\bink_asp2\database\bink. mdb'

So I took the path given by the error and added the missing \bink_asp2\. Everything works now, so this was actually the problem. But I don't know if the solution is really good as it largely depends on the location of the folder on the server. Is there any better way or is this it?