stands for Microsoft's ActiveX Data Objects.
Questions tagged [adox]
69 questions
0
votes
1 answer
How to set column Properties in SQL Server
I have to create a Copy of a Database on SQL Server.
On this way I got a connection to the new DB
ADODB.Connection connection = new ADODB.Connection();
OleDbConnectionStringBuilder builder = new…
Bird75
- 27
- 8
0
votes
1 answer
COMException when adding ForeignKey to the table using ADOX for AccessDB
I get this exception: Invalid field definition 'NalogID' in definition of index or relationship.
Exception is fired when I append the table in the code below to the catalog
I can't figure out what parameter goes in the 3rd place (this is what Visual…
solujic
- 924
- 1
- 18
- 43
0
votes
1 answer
#import ADOX conflict with managed dll using ADO
I have a legacy C++ application using /clr calling a managed dll (written in C#)
The app uses #import to reference ADOX. The dll also references ADOX.
Everything is fine until I add a reference to my dll to the C++ project. Then I get hundreds of…
Phil J Pearson
- 547
- 6
- 11
0
votes
1 answer
Use ADOX or ADOX and ADODB to query and edit data
I am trying to figure out how to use ADO and ADODB to get data and view it while also being able to determine the PK so that I can alter data.
My plan is to use ADODB to display some data to an end user in Excel, if the user wants to edit the data…
Geoff
- 256
- 2
- 5
- 20
0
votes
3 answers
how to set the AutoIncrement-property of table column in adox?
as i explain in the title, i cant set the property to the column:
Catalog cat = new Catalog();
Table tableCustomer = new Table();
Table tableAddresses = new Table();
try
{
//Create the…
Orientos
- 151
- 3
- 15
0
votes
1 answer
how to add foreign key to access table using adox
I am trying to creat a database with two tables. i want to add in a foreign key in one of them.
but the following code is not working, i debug it and i found that the only problem is in adding the foreign key.
private static bool creatDatabase()
…
Orientos
- 151
- 3
- 15
0
votes
0 answers
How to create a View in an Access database using C# form application?
What I'd like to do is create a Form in an MS Access database using C#, so I don't have to manually re-create the Form each time a new instance of the database is created.
What I can do successfully is use ADOX to create an Access DB, create an…
0
votes
2 answers
create table in access database using Adox in vb
I'm using a Windows form application in Visual Basic 2012 to create a new Microsoft Access database using .ADOX. I can create the database but can't create a table in the database.
My code is :
Imports ADOX
Imports System.Data.OleDb
Public Class…
Dan
- 7
- 4
0
votes
1 answer
Populate a column created by ADOX with a list C#
I created a table in my database with ADOX. I wish to populate my columns with a list. How can I do this? One list is a string which should populate "ScheduleName" column and one list is an integer list which should populate "SchedulePace" column.…
George Boulton
- 101
- 12
0
votes
1 answer
find ip of connected MYSQL database in VB.net
I need to return the ip connection data of an ODBC Mysql connection
to visually verify that I am connected successfully to the right database on the correct server using VB.net.
In VB6 I used to parse the ADOX.Catalog.ActiveConnection string but…
user2749453
- 1
- 1
0
votes
0 answers
How do I create an Access 2010 database and configure the tables and column?
I have been trying to create an Access 2010 database for a few days now and I get all sorts of errors each attempt I make. I have the drivers installed already and I have made references to ADOX and ADODB. The most recent error I have encountered is…
Ozma64
- 23
- 1
- 7
0
votes
2 answers
ADOX Rearrange Or Insert Columns Rather than Append them in Access Vb6, VB.Net or CSharp
I need to insert a field in the middle of current fields of a database table. I'm currently doing this in VB6 but may get the green light to do this in .net. Anyway I'm wondering since Access gives you the ability to "insert" fields in the table…
dblwizard
- 595
- 7
- 26
0
votes
1 answer
ADOX error when compiling code with reference to ADOX module
I get a error with ADOX when compiling, and I don't know what's causing it.
Here is my code:
ADOX.Catalog cat = new ADOX.Catalog();
cat.Create("Provider=Microsoft.ACE.OLEDB.12.0;" +
"Data Source=" + db + ";" +
…
user2758012
- 21
- 4
0
votes
1 answer
How to release ADOX CoCatalog after creating a database?
I create new MS Access database using the following (C++ Builder XE2):
CatalogPtr cat = CoCatalog::Create();
cat->Create(strConn.c_bstr());
The problem is that lock file is created and I want to delete it. I know I need to release the "cat" object…
Tracer
- 2,544
- 2
- 23
- 58
0
votes
0 answers
ADOX - How to add Query inside MS Access database?
I'm using C++ Builder and having trouble adding query inside MS Access (2003) database. I use this code:
CatalogPtr cat = CoCatalog::Create();
VARIANT myConnectionString;
myConnectionString.vt = VT_BSTR;
myConnectionString.bstrVal =…
Tracer
- 2,544
- 2
- 23
- 58