Error on data adapter
-
Could someone tell me what I am doing wrong? I am trying to add access into visual basic. I have changed the server for access (Microsoft Jet 4.0 OLE DB Provider). I have done the test connection - all is well. I have added the dataGrid to the web form- Named it MyDG1. I clicked on OldDbDataAdapter and added the connection where the access page is. I have done the Query builder, generate dataset (which I called MyDS). I selected the the dataset and Previewed it - all is well when I filled it in. I assigned a table to the DataView - Shopping Products (my access page). I assigned the DataSource property on the DataGrid as DataView1. In the page_load handler I added OleDbDataAdaper1.Fill(MyDS1) Page.DataBind() I build it - all is good; however when I view in browser that is when I get my error. Here is my error. Server Error in '/WebApplication1/WebApplication1/Unit5' Application. -------------------------------------------------------------------------------- Unspecified error Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.OleDb.OleDbException: Unspecified error Source Error: Line 83: Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Line 84: 'Put user code to initialize the page here Line 85: OleDbDataAdapter1.Fill(MyDS1) Line 86: Page.DataBind() Line 87: End Sub Source File: c:\inetpub\wwwroot\WebApplication1\WebApplication1\Unit5\WebForm1.aspx.vb Line: 85 Stack Trace: [OleDbException (0x80004005): Unspecified error] System.Data.OleDb.OleDbConnection.ProcessResults(Int32 hr) +20 System.Data.OleDb.OleDbConnection.InitializeProvider() +57 System.Data.OleDb.OleDbConnection.Open() +203 System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection, ConnectionState& originalState) +44 System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +304 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +77 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) +38 Unit5.WebForm1.Page_Load(Object sender, EventArgs e) in c:\inetpub\wwwroot\WebApplication1\WebApplic
-
Could someone tell me what I am doing wrong? I am trying to add access into visual basic. I have changed the server for access (Microsoft Jet 4.0 OLE DB Provider). I have done the test connection - all is well. I have added the dataGrid to the web form- Named it MyDG1. I clicked on OldDbDataAdapter and added the connection where the access page is. I have done the Query builder, generate dataset (which I called MyDS). I selected the the dataset and Previewed it - all is well when I filled it in. I assigned a table to the DataView - Shopping Products (my access page). I assigned the DataSource property on the DataGrid as DataView1. In the page_load handler I added OleDbDataAdaper1.Fill(MyDS1) Page.DataBind() I build it - all is good; however when I view in browser that is when I get my error. Here is my error. Server Error in '/WebApplication1/WebApplication1/Unit5' Application. -------------------------------------------------------------------------------- Unspecified error Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.OleDb.OleDbException: Unspecified error Source Error: Line 83: Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Line 84: 'Put user code to initialize the page here Line 85: OleDbDataAdapter1.Fill(MyDS1) Line 86: Page.DataBind() Line 87: End Sub Source File: c:\inetpub\wwwroot\WebApplication1\WebApplication1\Unit5\WebForm1.aspx.vb Line: 85 Stack Trace: [OleDbException (0x80004005): Unspecified error] System.Data.OleDb.OleDbConnection.ProcessResults(Int32 hr) +20 System.Data.OleDb.OleDbConnection.InitializeProvider() +57 System.Data.OleDb.OleDbConnection.Open() +203 System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection, ConnectionState& originalState) +44 System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +304 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +77 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) +38 Unit5.WebForm1.Page_Load(Object sender, EventArgs e) in c:\inetpub\wwwroot\WebApplication1\WebApplic
-