Stack Overflow
Stack Overflow

Questions tagged [adox]

stands for Microsoft's ActiveX Data Objects.

69 questions
6
votes
1 answer

ADOX Multiple-step OLE DB operation generated errors

I have to make a program that turns off all Unicode compression and all "allow zero length" in an access database (.mdb) . The method for turning off Allow Zero Length works very well. However, the method for turning off Unicode compression does…
MadSeb
  • 7,958
  • 21
  • 80
  • 121
4
votes
1 answer

ADO.NET way for creating a linked table

I'm writing an application that uses ADO.NET OLEDB provider. Database is Access. Most of DB interaction is through DDL/DML SQL queries. I now need to create linked tables and there doesn't seem to be a way of doing that with ADO.NET alone. Neither…
sameerz
  • 61
  • 1
  • 3
4
votes
1 answer

COM Exception: "Class not registered" when trying to create an ADOX.Catalog

I have been trying to create an Access database via C#. I have already tried using code from this post and this post, which I have to admit, have been very helpful. Right now this is the part of my code which should create the Access database: …
SantLev
  • 140
  • 3
  • 15
4
votes
2 answers

"Nullable" property for ADOX table column?

I'm trying to create an Access file (.mdb) with C#. I'm exporting data from SQL for a legacy process. I got it working, the only problem I'm facing is setting columns to nullable. Here's what I have (removed most columns for brevity): private void…
John Straka
  • 1,874
  • 5
  • 28
  • 49
4
votes
1 answer

Can't set ADOX.Catalog.ActiveConnection to ADODB Connection coming from .NET

I've been tasked with the incremental porting of a legacy VB6 app (using MS Access as a database, don't ask) to .NET. This is going to be a long one, but I think it's better to give a bit of context. This app has a main MDI form with a menu, which…
s.m.
  • 7,895
  • 2
  • 38
  • 46
3
votes
3 answers

SQL/Schema comparison and upgrade

I have a simple situation. A large organisation is using several different versions of some (desktop) application and each version has it's own database structure. There are about 200 offices and each office will have it's own version, which can be…
Wim ten Brink
  • 25,901
  • 20
  • 83
  • 149
3
votes
1 answer

creating Access db with ADOX

I'm trying to create an Access database consisting of two tables. I'm getting System.Runtime.InteropServices.COMException on line 88 inside the following method. The exception occurs when I try to append a table to the Catalog object. Could…
Alan
  • 822
  • 1
  • 16
  • 39
3
votes
0 answers

COLUMNS_FLAGS field values for 'Columns' collection of OLE DB Schema Collections (ADO.NET)

I can't find COLUMN_FLAGS field values' enumeration for Columns collection of OLE DB Schema Collections (ADO.NET): Columns ColumnName DataType ... COLUMN_FLAGS Int64 for Microsoft.Jet.OLEDB.4.0 provider. Please post COLUMN_FLAGS field…
ShamilS
  • 1,410
  • 2
  • 20
  • 40
3
votes
2 answers

How to use ADOX to connect to existing Access database

From a quick google i found out how to use ADOX to create a new database and add some tabels and rows to it. Here is an example: using ADOX; ... ADOX.Catalog cat = new ADOX.Catalog(); cat.Create("Provider=Microsoft.ACE.OLEDB.12.0;Data…
Krimson
  • 7,386
  • 11
  • 60
  • 97
2
votes
0 answers

AdoX index.delete checks user_name incorrectly

We have an application that updates the database schema at times. We're using AdoX.Index.Delete to remove some indexes before we create newer indexes. It seems that adox is generating a sql statement that checks if the index exists in sysobjects and…
John Jackson
  • 31
  • 6
2
votes
0 answers

ADOX Exception: Class not Registered

I'm trying to create a database in C# using a Windows Forms App in Visual Studio 2017. No matter what I try, I'm getting the same error. I know everyone says it's an x64 thing, but I've set my platform to x86. Here's the…
Ben
  • 394
  • 7
  • 13
2
votes
1 answer

Is it possible to create a MS Access database using OLEDB?

I've seen a few answers to this, but all of them use ADOX which I don't exactly know how to use. Is it possible to do it entirely with OLEDB? If so, how? Thanks in advance
OrangeWall
  • 79
  • 1
  • 8
2
votes
1 answer

VBA - Using Typeof ... Is ADODB.Recordset Results in Compile Error

I am building a function with a set of supporting sub-functions to create ADOX.Catalog objects to help me build automation for Access database generation. I like to use late-binding for my applications because my user base doesn't always have the…
Yllzarith
  • 169
  • 1
  • 11
2
votes
1 answer

Corrupting Access databases when inserting values

Recently, a program that creates an Access db (a requirement of our downstream partner), adds a table with all memo columns, and then inserts a bunch of records stopped working. Oddly, there were no changes in the environment that I could see and…
Jon
  • 21
  • 1
  • 3
2
votes
1 answer

Python / ADOX: 'The specified module could not be found.' (win32 extensions)

I'm running pywin32 for python 2.5. I'm following the instructions for python ADO given at http://www.ecp.cc/pyado.html. Creating an ADODB.Recordset object works fine. But when I try to create an ADOX.Catalog object I get an error: >>>…
mph
  • 790
  • 7
  • 20
1
2 3 4 5