Re: problem connecting to ADO programmatically

Chris.Cheney wrote:

However, I still think it is worth using a simpler connection string!

Trouble again....

The original string, from the wizard, is:
'Provider=Microsoft.Jet.OLEDB.4.0;Password="";User ID=Admin;Data
Source=I:\Development\CAP\CapWatch\CAPWATCH 24 MAY 07.MDB;Mode=Share
Deny None;Extended Properties="";Jet OLEDB:System database="";Jet
OLEDB:Registry Path="";Jet OLEDB:Database Password="";Jet OLEDB:Engine
Type=4;Jet OLEDB:Database Locking Mode=0;Jet OLEDB:Global Partial Bulk
Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database
Password="";Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt
Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet
OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False'

I am placing this string into ConnectString, on the fly:
'Provider=Microsoft.Jet.OLEDB.4.0;DataSource=I:\Development\CAP\CapWatch
\CAPWATCH 24 MAY 07.MDB;User ID=admin;Password=""'

Note two things: I observed that the last parameter in the list from
the wizard does not end with a semicolon, so eliminated that, though it
appears to make no real difference to the problem. Second, apart from
the specific filename and path, this is the same as the set of strings
you suggested.

And now I am back to the original error message. This issue of the
ConnectString appears to me to be a point of considerable fragility....

--

Bill
.

Relevant Pages

  • Re: problem connecting to ADO programmatically
    ... The original string, from the wizard, is: ... I am placing this string into ConnectString, ... ConnectString appears to me to be a point of considerable fragility.... ...
    (borland.public.delphi.database.ado)
  • Re: Wizard Control Issue
    ... i think the Wizard should be able to work for your requirements. ... Tim I checked the code, these tags are opened and closed properly ... string MiddleName = string.Empty; ... string Country = string.Empty; ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Creating and setting registry key value
    ... I won't help debug code that is not written by a wizard. ... You could have used a pointer if a literal string were ... >why I want to edit the registry directly. ... Unicode-aware or not, but if it isn't, it would be an exceedingly poor choice of type. ...
    (microsoft.public.vc.mfc)
  • RE: Multiple table dataset
    ... This is a bit beyond wizard, but here is a quick sample in C# and VB.NET ... string connString = ""; ... Dim connString As String = "" ... >>> orders and orderDetails associated with the customer. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Create DSN-Less link to Foxpro table
    ... I'm afraid I have absolutely no experience using FoxPro, ... Dim wk As DAO.Workspace ... Dim ConnectString As String ...
    (microsoft.public.access.externaldata)