ActiveX Data Objects, a Microsoft middleware for accessing data sources. Allows to access data from various languages without knowing how the database is implemented. Successor of RDO (Remote Data Objects) and DAO (Data Access Objects), first introduced in 1996.
Questions tagged [adodb]
1825 questions
0
votes
1 answer
ADODB Connection.ConnectionString property doesn't return server name
I am using ActiveX Data Objects 6.1 library in Excel VBA to access a SQL Server 2012 database. I can connect and run queries fine, but once connected there appears to be no way to determine which server the connection object is connected to, as the…
aucuparia
- 2,021
- 20
- 27
0
votes
2 answers
Adodb Recordset function .MoveNext Causes Exception "UPDATE permission was denied"
I've run into a problem today that has stumped me.
Here is some sample code:
Dim objRec As ADODB.Recordset
Dim oRec As ADODB.Recordset
Dim oRecBuild As New ADODB.Recordset
cmd = New…
TopBanana9000
- 818
- 2
- 14
- 32
0
votes
1 answer
ADODB.connection open returning application defined or object defined error
I have the below code and it is returning an error:
Application defined or object defined error.
Public Sub TestConnection()
Dim conn
Set conn = New ADODB.connection
CONSTRING = "Provider=NZOLEDB;Data Source=location;Initial…
Michael Wa
- 111
- 4
0
votes
1 answer
PHP + ADODB do nonthink
Hi everyone i try write page with PHP and ADODB db-engine is mysql. I want to add to mysql new record and show table. Someone knows what is wrong with that code?
index.php
Saturin
- 1
- 2
0
votes
1 answer
adodb, pdo or other, I want autoExecute
I used to use PEAR MDB2 and one of the things I loved was the autoExecute()
It really cut down on code.
But's it's a pain having to get MDB2 enabled on some hosted servers. I'd like to use either PDO or just include some class file.
It looks like…
Jameson
- 1
- 1
0
votes
1 answer
Open method for AdoDB.Connection object is not supported in Access 2010
Currently I'm working on an Access Database Application which was using ODBCDirect. After upgrading to Access 2010 I receive an error message that told me that ODBCDirect isn't supported anymore and that I have to change from the DAO to ADO in the…
McRaven
- 111
- 1
- 2
- 11
0
votes
2 answers
Valid response causes "Subcript out of range"
I've got a classic ASP application that contacts a database and receives a valid response but then crashes with
Error Number 9: Subscript out of range
after exiting the IF block the db call is made in. What's odd is that the same code is currently…
broguesquadron
- 25
- 1
- 9
0
votes
0 answers
Using adodb-mssqlnative.inc.php with a timeout for update without any result
I am using php5.4.38 with Apache2.2.29 on a windows server 2008 with MSSQL as Database with UTF8 fields for chinese language.
I am using adodb and the affected driver is adodb-mssqlnative.inc.php in adodb/drivers folder. It seems that using a…
Thomas Plus
- 1
- 1
0
votes
1 answer
AXMLS check constraint
I am creating q site using Conreate 5 CMS.
I am creating a new block and I have to use AXMLS to create a database table.
I have been able to create a basic table but I would like to extend it to add an check constraint. Below is the code I have…
Alan Auckland
- 115
- 2
- 10
0
votes
2 answers
How to select dynamic sheet names with an Excel VBA macro that moves data with ADODB?
I'm using a macro to move data across workbooks with an ADODB connection. When I select the data from the closed workbook, I need to label the sheet names as dynamic. However, when using my string variable for the name, the code will not run.
Public…
zbrown
- 40
- 7
0
votes
2 answers
UDF function in Excel running ACE SQL query, JOIN two tables does not work
I am trying to figure out what wrong may be with a function in Excel that tries to join two tables. I presume the error is somewhere in SQL string.
The function works well without a join, returning correctly a table to an array - range of cells.…
Jacek Kotowski
- 620
- 16
- 49
0
votes
1 answer
ADODB.Recordset keeping rows after close.. Classic ASP
I am getting old records from record set object even after I have closed the record set object.
Below is a code snippet from my file -
SQL = "Select col1, col2 from [Sheet1$]"
Set ExcelConnection =…
Rohit
- 1,520
- 2
- 17
- 36
0
votes
1 answer
Open Connection and Recordset objects to use SQL for sheet to sheet data movement
I am trying to open Connection and Recordset to use SQL to move data between worksheets within the open workbook. To be clear all the data source sheets are open in the current workbook that I am trying to copy data from and to a different worksheet…
CraigM
- 65
- 2
- 10
0
votes
1 answer
ADODB Connection is empty, Unable to read CSV file
I have gotten the code below working with all file types except CSV Files.
I am trying to copy a CSV file into a worksheet and I have gotten myself confused. All help will be appreciated.
The debugger shows:
rsConn = ""
szSQL = "SELECT * FROM…
CraigM
- 65
- 2
- 10
0
votes
1 answer
Cast and Convert functions are not supported on converting the column to date time format (in vbscript - Excel adodb)
I have written a vbscript to connect the excel file (.xlsx) as a database using ADODB connection. I want to extract the records from excel file which has the values in 'StartDate' column greater than '15/05/2015', but on executing a adodb query an…
Testers Logic
- 79
- 1
- 7