Re: Could not lock file Error

From: Val Mazur (group51a@hotmail.com)
Date: 11/26/02 

From: "Val Mazur" <group51a@hotmail.com>
Date: Tue, 26 Nov 2002 14:00:49 -0500

Hi,

Which database is it? Are you able to establish connection to it? 

--
Val Mazur
Microsoft MVP
"krishna c kanthety" <kkanthety@metrobat.com> wrote in message
news:uNjTepXlCHA.2144@tkmsftngp02...
> Val,
> I am getting the error when i am filling my dataset (Line 73:
> Me.OleDbDataAdapter1.Fill(DataSet11)
> .....i put a space in between order and by, still i am getting the same
> error..any ideas??
> thanks
> KC
>
> "Val Mazur" <group51a@hotmail.com> wrote in message
> news:edFTbVXlCHA.1924@tkmsftngp04...
> > Hi,
> >
> > Did you forget to add space in "order by" clause?
> >
> > Me.OleDbDataAdapter1.SelectCommand.CommandText = "SELECT
> >  DISTINCT Department FROM [Department Table] order by Department"
> >
> > --
> > Val Mazur
> > Microsoft MVP
> >
> >
> > "krishna c kanthety" <kkanthety@metrobat.com> wrote in message
> > news:uUKHs$VlCHA.2032@tkmsftngp02...
> > > Hi All,
> > > i am trying to connect to an Access Database that resides on the C
drive
> > of
> > > my computer and am trying to populate the dataset using the data i got
> > from
> > > the access database....
> > > now my problem is, while trying to populate the dataset, its giving me
> the
> > > following error
> > > Could not lock file.
> > > Line 72:         Me.OleDbDataAdapter1.SelectCommand.CommandText =
> "SELECT
> > > DISTINCT Department FROM [Department Table] orderby Department"
> > > Line 73:         Me.OleDbDataAdapter1.Fill(DataSet11)
> > > Line 74:         Dim dt As DataTable = New DataTable()
> > >
> > > can any body let me know where i went wrong..i gave the security
> > permissions
> > > for the file for ASPNET account..
> > >
> > > thanks in advance..Krishna Chaitanya Kanthety
> > >
> > >
> >
> >
>
>

Relevant Pages

  • Re: Reusable Database connection for Combo Box, list box and other query
    ... List boxes. ... languages you have an abstraction to the database where you can pass ... Here is code to populate one of my Combo boxes. ... I have one more and I have to repeat my Connection code each time: ...
    (microsoft.public.excel)
  • How to bind a DataSet to a ReportViewer object?
    ... I use DataSet which I get from Web Service and it doesn't maintain an active ... connection to the database. ... So that I can't populate table in Report.rdlc ...
    (microsoft.public.dotnet.languages.csharp)
  • Web Part Connections
    ... I have a WSS3.0 site and connecting to an SQL 2000 database. ... populate the textboxes of the insert view. ... When I hit insert however the Project field is always blank (as are ... selects the correct Project based on the web part connection. ...
    (microsoft.public.sharepoint.windowsservices)
  • Filling PDF Forms
    ... Are there any Ruby utilities out there for filling out PDF forms? ... I have PDF form that I would like to populate from a database. ...
    (comp.lang.ruby)
  • Re: ADO Connection Timeout
    ... so what happens when a connection failure forces one station to revert ... to a local database? ... Further, you *will* have contention issues, Jet does not support record ... to the central server, but you are willing to live with periods where it ...
    (microsoft.public.data.ado)