Re: Error 0x800A0BB9 When Reconnecting in same process instance

The link looks promising. What I noticed in the article you sent is I'm
using Jet40 instead of Jet30 for the MS Access 95 database. I will try
switching database engines to see if that clears things up.

-harrier

"Ralph" wrote:


"harrier" <harrier@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:2DE00EE8-DE55-47CF-8C6C-CF855A971033@xxxxxxxxxxxxxxxx
I have an application in C++ 2003 that connects to an Access 95 database.
The database cannot be converted to 2003 because it cannot be opened in
the
primary application (3rd party) the database is for. So cross the
converting
the database thing off your list(s) immediately.

Generally the process flow for users is to open the database, run a
process
against the data then terminate the application. I recently added a
feature
to compact the database but I have to close the connection in order to
perform the compact. After compacting I reconnect to the database and get
the following error on the Connect call:

Error: 0x800A0BB9
Arguments are of the wrong type, are out of acceptable range, or are in
conflict with one another.

I've tracked down that if I comment out a call to Connection.OpenSchema()
the problem goes away. What I do is call OpenSchema and look at the list
of
tables. There are seven table names I look for to ensure it's a valid
application database as opposed to a generic MDB file.

Any ideas?

-harrier

Not enough information for more than a couple of hints.

Most of the time the error is exactly what it is reporting - some place you
have confused datatypes, perhaps using a long where a string is required, an
array instead of a string, etc.

This is easy to do as data items like recordset values are Variants - often
ETC will allow a particular datatype to work in some contexts but not in
others.

It is also possible to get into issues when using 'newer' data access
libraries/engines/providers with 'older' database formats. See if this sheds
some light...
http://support.microsoft.com/kb/303528/

-ralph




.

Relevant Pages

  • Re: A little Rolodex [revised]
    ... including alpha sort and searching for any embedded string, ... In this application, a database is a directory, ... you may optionally provide any alternate UCASE program, ... NN -> first store NN as key length ...
    (comp.sys.hp48)
  • Re: return multiple rows from sql statement
    ... strings from input values is almost certainly a safe path to SQL ... Also, being a MySQL function, it knows what MySQL needs or uses. ... All characters that are entered in the fields make their way into the database unaltered. ... The insert of what surprisinlgly was NOT a syntax error, but a string called "mysql_insert_id" into an integer field resulted in the value zero being put in. ...
    (comp.lang.php)
  • Re: Code to delete/unlink Linked tables
    ... Public intLinkODBCTables As Variant, intLinkDB2Tables As Variant ... Public strLinkBackendDB As String, strLinkDSNname As String, strLinkLibName ... ' MsgBox "This database is in MDE format...I will delete/recreate ODBC ... Public Sub fncLinkDB2Table() ...
    (microsoft.public.access.modulesdaovba)
  • Re: Establish connection with and transferring data to Access
    ... The specific problem with your code is that you need to quote string ... Dim vConnection As New ADODB.Connection ... Experiment with the object model or check the documentation for the ... Doug's code opens and writes to an existing database. ...
    (microsoft.public.word.vba.general)
  • Re: Invalid variant type conversion
    ... because within regular programming, there would be no agreement upon what ... applications built by standard Delphi controls, ... NULL is the same as "" in a database. ... >> The empty string tells it all. ...
    (comp.lang.pascal.delphi.misc)
Loading