Search results matching tag 'Access'

Error in connecting Access and asp.net

Md Eqbal Ansari — Tue, 15 Dec 2009 05:00:00 GMT

hi....

I want to do simple job...

connecting asp.net to access ..

I have already did it several times but this time I am getting error.

please help me.

my code is

protected void Page_Load(object sender, EventArgs e)

{

OleDbConnection con= new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;DataSource=E:\\MyWebSite\\Student.mdb");

DataSet dbset = new DataSet();

string sql = "select * from LoginTable";

OleDbDataAdapter adr = new OleDbDataAdapter(sql, con);

con.Open();

adr.Fill(dbset);

con.Close();

}

I am getting the following error:-

Could not find installable ISAM.

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: Could not find installable ISAM.

Source Error:

Line 21:         OleDbDataAdapter adr = new OleDbDataAdapter(sql, con);
Line 22: //        con.Open();
Line 23:         adr.Fill(dbset);
Line 24:   //      con.Close();  
Line 25:

I have Install Visual Studio 2008 right now..

Displaying Yes and No for Database Fields

STEVE.com — Sun, 29 Nov 2009 05:00:00 GMT

I have a database that has several Yes or No fields. When I insert a Label control into my site and connect it to the Yes or No field it displays "True" for Yes and "False" for No. I would like to display them with the text Yes or No. I have tried the following:

<asp:Label id="myLabel" runat="server" Text='<%# Eval("myBooleanColumn") == "true" ? "Yes" : "No" %>' />

but no matter if my database info is yes or no it will only display "Yes"

Any ideas?

Re: help opening connection to access database c#

pritam.ahire — Fri, 27 Nov 2009 05:00:00 GMT

i have test this page with access db nd it is working fine,keep ur access

db file in app_code folder and then run program

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.OleDb;
using System.Web.Configuration;

public partial class AccessDatabase : System.Web.UI.Page
{
    private OleDbDataAdapter Objda;
    private OleDbConnection Objcn;
    protected void Page_Load(object sender, EventArgs e)
    {
          
           
         //Get connection string from Web.Config  
         Objcn = new OleDbConnection(WebConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
         Objcn.Open();
         Objda = new OleDbDataAdapter("select * from info", Objcn);
         DataSet ds = new DataSet();
         Objda.Fill(ds, "info");
         dataGrid.DataSource = ds.Tables[0];
         dataGrid.DataBind(); 
    }
}

Looking for ASP.NET/C# freelance job

Ficher — Tue, 24 Nov 2009 05:00:00 GMT

I would like to propose my services in web development to you.

Technical skills:

ASP.NET, C#
MS Integration Services, MS Office Sharepoint Services
MS SQL, MySql, Access, Sybase

Warehouse system architecture
Netezza

DotNetNuke, nopCommerce
Javascript libraries: jQuery, Mootools

Best regards,
Dmitry.

tregubenko at gmail dot com

Problem with OLEDB and IIS

carlosrah — Tue, 17 Nov 2009 05:00:00 GMT

Hello,

I have an web application running on Windows Server 2003. Sometimes it throws an exception that i really don't know how to fix it. it's really extrange because it's not constant, it happens sometime.

When i go to the server Event Viewer i can see some errors like this:

EventType clr20r3, P1 aspnet_wp.exe, P2 2.0.50727.3082, P3 492b8702, P4 mscorlib, P5 2.0.0.0, P6 492b834a, P7 11eb, P8 18, P9 system.outofmemoryexception, P10 NIL.
aspnet_wp.exe (PID: 1988) stoped unexpected

The web application calls an Access database with the following line of code:

Dim oCnnAccess As New OleDb.OleDbConnection

Dim sCadConexion As String = "Data Source=""" & RutaAccessTemporal & """;Provider=""Microsoft.Jet.OLEDB.4.0"";Mode=Share Deny None"
            oCnnAccess.ConnectionString = sCadConexion
            oCnnAccess.Open()

RutaAccessTemporal = Path to the .mdb

What should i look for? i really don't see the problem, and the application works fine, but sometimes i throws the exceptions.

Thanks to all....

Carlos Aparicio

SQL query: Inserting multiple results into a new table

lorengphd1 — Fri, 13 Nov 2009 05:00:00 GMT

I have a MS ACCESS 2000 sql query that returns several results, sometimes up to 30 or so. I want to insert these results into a new table all at once, each with their own unique ID [once in the new table]. How is this accomplished?

Thanks!

Loren

Re: How to bypass CompanyWeb

mathew7535 — Sat, 31 Oct 2009 04:00:00 GMT

If I am not wrong, then you need to host your site. mean to say if any body type

www.companyweb.com then your site will appear. For this you need to create

an application in IIS and redirect your url to that particular ip.

If I am going in right direction then let me know, more information will be provided @ www.developersword.com

enjoy

Working with Access in the App_Data directory

john6630 — Sat, 24 Oct 2009 04:00:00 GMT

I have an Access database which I created in the App_Data directory. I added the following to the Web.Config file:

I create the connection as follows (credit to www.moretechtips.net for the following data access code):

Public Sub Init()
        If ConnString = "" Then
            ConnString = ConfigurationManager.ConnectionStrings(ConnStringID).ConnectionString
            Provider = ConfigurationManager.ConnectionStrings(ConnStringID).ProviderName
        End If
        If Conn Is Nothing Then
            PFactory = DbProviderFactories.GetFactory(Provider)
            Conn = PFactory.CreateConnection
            Conn.ConnectionString = ConnString
            Cmd = PFactory.CreateCommand
            Cmd.Connection = Conn
        End If
    End Sub

If I break execution and look at ConnString at this point I see the exact string from the Web.Config file. The "|DataDirectory|" has not been replaced by the actual path to the database. That may be ok, I do not know.

I try to access the database with this code:

Public Function ExecuteNonQuery() As Integer
        Dim rows As Integer
        Conn.Open()
        rows = Cmd.ExecuteNonQuery()
        Conn.Close()
        Return rows
    End Function

At the "Conn.Open()" command I get the following error:

"Can not find installable ISAM".

I am sure I am missing something simple but do not know where to begin. I added a reference to System.Data to my project but that had not affect.

Any help greatly appreciated.

TIA

John

Displaying data from access database on intranet while people have Access version open

jpmoriarty — Wed, 14 Oct 2009 04:00:00 GMT

Hope you guys can help me. I have a "back end" database on a network, which I then have a number of employees who use a "front end" on their local machines to connect to the database. They're putting information into the database.

I also have an ASP based intranet site that's used to display what's in the database - never to write information to it, but to pull information out of it. At the moment the ASP script connects to the actual backend db file. The problem is that if one of my colleagues has their front end open and is putting new info into the db, the intranet fails as it says the db is already open (File in use). I thought if I created another front end that connected to the tables in the back end specifically for the asp pages that'd help, but it's still saying the file is in use.

Is there any way I can be pulling data out of the db through my asp scripts whilst other people are adding info in (through split tables etc) using access? Does the fact that the ASP script won't be writing (and doesn't need to) make it any easier?

Grateful for any advice you can provide!

Re: Rewriting an Access Project (ADP) - Web or WPF - Suggestions and Tips please

dministrator — Fri, 25 Sep 2009 04:00:00 GMT

Thank you for taking time for writing such an involved response. Very helpful. Thank you.

Some more points about this application:

Technical expertise is not an issue as we have people, myself included, working on everything from BizTalk, WCF, WWF and many other Microsoft technologies.

I do not know the full history behind this Access application which I inherited, but one of the clincher in favor of using Access + Citrix seems to be that, Access had everything they needed within one platform: Reporting, UI forms, interface to SQL Server Database etc.

The terminals are all windows dumb-terminals, or as we like to call them - 'unwise terminals'. The application is represented by a short cut on the desktop; when dbl-clicked will launch the Access ADP project via Citrix. I don't think any of the terminals have IE installed right now.

If you have more to add on this topic, please do so. Thanks again for your response.