Re: Workgroup file information file error: OleDB to Access file

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Paul Clement (UseAdddressAtEndofMessage_at_swspectrum.com)
Date: 01/31/05 

Date: Mon, 31 Jan 2005 12:04:40 -0600

On Mon, 31 Jan 2005 07:46:45 -0800, "Paul Keister" <bogus_info_bogus@bogus_pjpm.biz> wrote:

¤ "Paul Clement" <UseAdddressAtEndofMessage@swspectrum.com> wrote in message
¤ news:pqgsv0psnfa9cnv8rj67ded11evj9oks0l@4ax.com...
¤ >
¤ > Any chance the files are read-only or you don't have the appropriate
¤ > permissions to open the
¤ > database? I'm assuming that this is a VB.NET app and not an ASP.NET app.
¤ >
¤ >
¤ > Paul ~~~ pclement@ameritech.net
¤ > Microsoft MVP (Visual Basic)
¤
¤ Yes, this is a .NET app, not and ASP.NET app. It's actually C#.NET. This
¤ is a good thought, but this was not the problem. Here's what's wrong:
¤ there's a typo in the connection string. It should be, "OLEDB:System
¤ Database," not, "OLE DB:System Database." Doah!
¤
¤ I'm glad nobody noticed this. I feel dumb enough already. This is further
¤ confirmation of one of my long-standing theories: the worst bugs are caused
¤ by the dumbest mistakes. In other words, if you find yourself spending
¤ hours on a problem, don't look for subtle explanations, look for glaring
¤ errors!
¤

I have to admit I missed it too and syntax was the first thing I looked for. ;-)

Paul ~~~ pclement@ameritech.net
Microsoft MVP (Visual Basic)

Relevant Pages

  • Re: Portable Database Choice
    ... I searched this group quite a bit looking for database alternatives and did find the options below from this search. ... I'm posting this in the hope it can be of use to other developers in a position similar to mine where I needed a low cost alternative to Pocket Access. ... One app requires synchronization between desktop and mobile device, the other requires a push of data from the desktop to mobile. ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: Portable Database Choice
    ... > database alternatives and did find the options below from this search. ... One app requires ... > push of data from the desktop to mobile. ... > Both of these apps used Pocket Access on the device with Peter Foot's ...
    (microsoft.public.dotnet.framework.compactframework)
  • Portable Database Choice
    ... database alternatives and did find the options below from this search. ... of data from the desktop to mobile. ... The read-only app requires speedy lookup of data in a flat table ... Both of these apps used Pocket Access on the device with Peter Foot's ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: Sqlserverce class not working when VB.Net application is running from network drive
    ... one app attempts to connect to a sdf file on a network share, ... possible that the database is already in use when you attempt to ...
    (microsoft.public.sqlserver.ce)
  • Re: Workgroup file information file error: OleDB to Access file
    ... "Paul Clement" wrote in message ... > permissions to open the ... I'm assuming that this is a VB.NET app and not an ASP.NET app. ... Database," not, "OLE DB:System Database." ...
    (microsoft.public.dotnet.framework.adonet)