Re: DateCreated

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Al Reid (areidjr_at_reidDASHhome.com)
Date: 11/05/04 

Date: Fri, 5 Nov 2004 13:21:42 -0500

"Rob Kings" <greeneggsandham@greymouse.co.uk> wrote in message news:2v1tj8F2gve17U1@uni-berlin.de...
> Al
>
> Sorry, I really do appreciate all the help. I'll start from the top. I've an
> Access database. Its in Access2000 format, but doesn't have to be. I've a
> whole load of tables in there and I was opening it using a connectstring
> like
>
> DRIVER={Microsoft Access Driver (*.mdb)};UID=admin;DBQ=D:\Mydata\Project.mdb
>
> This has all been working fine and dandy. For the most part my application
> doesn't use any databound controls. I execute some SQL and get the data into
> an array and use this to poulate a VSFlexgrid. Having said that, the main
> form (which is read-only) is done that way, though quite why its different
> from all the rest escapes me, something to do with the quick
> searching/ordering capabilities of the Flexgrid I think)
>
> All I want to do now is to add a field to the splash screen to show the data
> the datbase was created. Since the tables are periodically
> deleted/re-created the DateCreated seemed like a good idea. However,
> whichever way I tried they came back as Null.
>
> If I change the connect string then that bit works, but:
>
> a) The main form is broken
>
> b) I'd really need to thoroughly test the rest of the app (which is > 20,000
> non-blank, non-comment lines in 72 modules)
>
> So, as you can see, I'm a triffle reluctant.
>
> Cheers
>
> Rob
>
> > You really haven't provided a whole lot of information. I don't use
> > databound controls so I am not sure how or why that would be a
> > problem. However, here is a simple answer. Create a new Connection
> > object/ConnectionString for the OpenSchema method, use the info and
> > then destroy it.
> >
> >
>
>

Rob,

I can't help you. First, you haven't indicated what breaks or what error you get when you change the connection string and any code
to demonstrate it. I really don't understand what you mean by the main form is broken. Secondly, you seem to have ignored or
discounted my suggestion to use a separate Connection Object for use with the OpenSchema method.

I have a single database application, that I wrote, that connects to any database using any valid connection string and uses that
connection to query, Insert, Update, Create, Drop... tables. Other than limitations imposed by the database or provider, the
application works without any problems. It can connect to Access, Oracle, MSSQL using both OLEDB and ODBC Drivers.

If you can provide some specifics, perhaps I can help, otherwise, I hope that someone else can provide some additional insight. 

-- 
Al Reid
How will I know when I get there...
If I don't know where I'm going?

Relevant Pages

  • Re: [SOLVED] Cannot display provider-specific login prompt
    ... scenario where the program wouldn't have to know about the database, ... ConnectionStringBuilder up to a PropertyGrid for the end user to populate), ... details of the connection, for the sake of the program being able to connect ... information about the connection string that I will need. ...
    (microsoft.public.dotnet.framework.adonet)
  • Complicated Connection Problems bewteen ADP and SQL Server
    ... This database ... expertise for getting the user workstations talking to the SQL Server. ... connection would fail and the adp wouldn't be able to talk to the server. ... might be in my ADO connection string. ...
    (microsoft.public.access.adp.sqlserver)
  • Complicated Connection Problem between ADP and SQL Server
    ... This database ... expertise for getting the user workstations talking to the SQL Server. ... connection would fail and the adp wouldn't be able to talk to the server. ... might be in my ADO connection string. ...
    (microsoft.public.sqlserver.connect)
  • Re: trying to automate a process we perform manually
    ... loan files) that's about 220mb large. ... I then rename it to a text file and import it into an Access database. ... connection to your data source. ...
    (microsoft.public.sqlserver.dts)
  • Re: Problems in loading data from an access database into an array
    ... Suppose your database has a table called which has columns called ... Dim oleCSB As New OleDbConnectionStringBuilder ... 'associate the connection string just built with the ole connection ...
    (microsoft.public.dotnet.framework.adonet)