Parser Error in connecting to Access database on server

[Listener]

I've been working on this for several days with no luck. When I run locally, I have no problems, but when I change the code to access the database on the server (DATA Source=" & server.MapPath("_database/mydb.mdb"))


I receive this message:

<%@ Page Language="VB" %>
Line 2: <%@ Register TagPrefix="wmx" Namespace="Microsoft.Matrix.Framework.Web.UI" Assembly="Microsoft.Matrix.Framework, Version=0.6.0.0, Culture=neutral, PublicKeyToken=6f763c9966660626" %>
http://community.discountasp.net/emoticons/freaked.gif

Can someoneplease help?

Thanks,

[Listener]

Sorry, I forgot to mention that I copied the dlls from the C:\Program Files\Microsoft ASP.NET Web Matrix\v0.5.464\Framework directory to the bin directory and am still receiving the error message. Any help is appreciated.

[bruce]

what is the error? i think you forgot to post the complete error.

Bruce

DiscountASP.NET
www.DiscountASP.NET (http://www.DiscountASP.NET)

[joelnet]

The error mentioned above has nothing to do with mappath or the mdb. Please post complete error message and (even better) a URL to an example of the problem.



Joel Thoms

DiscountASP.NET
http://www.DiscountASP.NET

[Listener]

Thanks for your fast response.

Here is the entire error message:


Server Error in '/' Application.
Parser Error
Description: An error occurred during the parsing of a resource required to service this request. Please review the following specific parse error details and modify your source file appropriately.

Parser Error Message: File or assembly name Microsoft.Matrix.Framework, or one of its dependencies, was not found.

Source Error:

Line 1: <%@ Page Language='VB' %>
Line 2: <%@ Register TagPrefix='wmx' Namespace='Microsoft.Matrix.Framework.Web.UI' Assembly='Microsoft.Matrix.Framework, Version=0.6.0.0, Culture=neutral, PublicKeyToken=6f763c9966660626' %>
Line 3: <script runat='server'>
Line 4:


Source File: E:\web\levelsolut1\htdocs\free.aspx Line: 2

Assembly Load Trace: The following information can be helpful to determine why the assembly 'Microsoft.Matrix.Framework' could not be loaded.

=== Pre-bind state information ===
LOG: DisplayName = Microsoft.Matrix.Framework, Version=0.6.0.0, Culture=neutral, PublicKeyToken=6f763c9966660626
(Fully-specified)
LOG: Appbase = file:///E:/web/levelsolut1/htdocs
LOG: Initial PrivatePath = bin
Calling assembly : (Unknown).
===

LOG: Publisher policy file is not found.
LOG: No redirect found in host configuration file (C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\aspn et.config).
LOG: Using machine configuration file from C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\confi g\machine.config.
LOG: Post-policy reference: Microsoft.Matrix.Framework, Version=0.6.0.0, Culture=neutral, PublicKeyToken=6f763c9966660626
LOG: Attempting download of new URL file:///C:/WINDOWS/Microsoft.NET/Framework/v1.1.4322/Temporary ASP.NET Files/root/736b207d/2708ebd6/Microsoft.Matrix.Framework.DLL.
LOG: Attempting download of new URL file:///C:/WINDOWS/Microsoft.NET/Framework/v1.1.4322/Temporary ASP.NET Files/root/736b207d/2708ebd6/Microsoft.Matrix.Framework/Microsoft.Matrix.Framework.DLL.
LOG: Attempting download of new URL file:///E:/web/levelsolut1/htdocs/bin/Microsoft.Matrix.Framework.DLL.
LOG: Attempting download of new URL file:///E:/web/levelsolut1/htdocs/bin/Microsoft.Matrix.Framework/Microsoft.Matrix.Framework.DLL.
LOG: Attempting download of new URL file:///C:/WINDOWS/Microsoft.NET/Framework/v1.1.4322/Temporary ASP.NET Files/root/736b207d/2708ebd6/Microsoft.Matrix.Framework.EXE.
LOG: Attempting download of new URL file:///C:/WINDOWS/Microsoft.NET/Framework/v1.1.4322/Temporary ASP.NET Files/root/736b207d/2708ebd6/Microsoft.Matrix.Framework/Microsoft.Matrix.Framework.EXE.
LOG: Attempting download of new URL file:///E:/web/levelsolut1/htdocs/bin/Microsoft.Matrix.Framework.EXE.
LOG: Attempting download of new URL file:///E:/web/levelsolut1/htdocs/bin/Microsoft.Matrix.Framework/Microsoft.Matrix.Framework.EXE.


Version Information: Microsoft .NET Framework Version:1.1.4322.2300; ASP.NET Version:1.1.4322.2300


and here is the url: http://www.levelsolutions.net/free.aspx

[joelnet]

The most common cause would be the library (dll) for Microsoft.Matrix.Framework is not in the 'bin' directory.


Joel Thoms

DiscountASP.NET
http://www.DiscountASP.NET

[Listener]

Thank you for your response. I found the dll and put it in the bin directory. Now I am receiving this error message related to the SQL statement. I suspect it has something to do with the quotation marks, but I cannot isolate it. Any help is appreciated.



Compilation Error


Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately.

Compiler Error Message: BC30205: End of statement expected.

Source Error:







Line 27:
Line 28: Function InsertInfo(ByVal code As String, ByVal fName As String, ByVal lName As String, ByVal phone As String, ByVal eMail As String, ByVal desc As String) As Integer
Line 29: Dim connectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0; Ole DB Services=-4; DATA Source=" &amp; server.MapPath("_database/LS_Contacts.mdb"))
Line 30: Dim dbConnection As System.Data.IDbConnection = New System.Data.OleDb.OleDbConnection(connectionString )
Line 31:
Source File: E:\web\levelsolut1\htdocs\Free.aspx Line: 29

[Listener]

Please disregard my earlier post. I played around with the syntax of the path and finally got this working! Thanks to you for your help and patience!