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
4
votes
1 answer
Old VB6 App using ADODB throwing error when calling Oracle Stored Procedure
This has to be provider related in some way because it works fine on my dev box but doesn't work on another dev box.
Here is the error I'm getting on the non-working dev box:
ORA-00604: error occurred at recursive SQL level 1
ORA-06502: PL/SQL:…
SLoret
- 1,531
- 3
- 18
- 31
4
votes
5 answers
MSDataShape error, broken on upgrade to Windows 10 Feature Update 1809
In our VB6 application, we use ADODB.Recordsets and make use of the Data provider for MSDataShape to create a relational recordset with SHAPE commands.
In the latest Windows 10 Feature (1809) our code breaks with the following error: -
"-2147217900…
Max Power
- 350
- 4
- 15
4
votes
2 answers
Strange error appending fields to recordset in VS2010 after converting to .NET 4
I have some code from this site CodeProjectLink to convert a datatable to a recordset. This code had been working fine until I changed to .NET 4 (was previously 2), now when I call the following line:
Dim result As New…
Matt Wilko
- 26,994
- 10
- 93
- 143
4
votes
2 answers
Why does GetRows() method return a transposed array?
Im using a Adodb connection
and reading the result of a query
into an array with
array = recordSet.GetRows()
which leads to a transposed array of dimensions
(row,col)
(0, 0)
(0, 1)
(0, 2)
instead of
(row,col)
(0, 0)
(1, 0)
(2, 0)
so it should…
Stackoverflow Nutzer
- 143
- 2
- 10
4
votes
2 answers
Inserting NULL values in a database from VBA code
I have 3 radioButtons ("YES", "NO", "UNKNOWN") which matches a column from my database with 3 possible values (1, 0, NULL).
When the radioButton selected is "UNKNOWN" I want to insert a NULL value in this table (using Variant type). But when I try…
Natty
- 497
- 1
- 11
- 23
4
votes
2 answers
CopyFromRecordset Returning Strange Characters
I have the following code below:
Function downloadsqltoexcel(conn As ADODB.Connection, sSQL As String, exceldestinationrangename As String, sqltablename As String, bDownload As Boolean, Optional ws As Worksheet) As…
Scott Holtzman
- 27,099
- 5
- 37
- 72
4
votes
1 answer
"Not enough storage is available to complete this operation" when base64-encoding a zip file
The below code is for converting a zip file to base64 format.
Dim inByteArray, base64Encoded,
Const TypeBinary = 1
inByteArray = readBytes("F:path/file.zip")
base64Encoded = encodeBase64(inByteArray)
Private Function readBytes(file)
Dim…
rahul raj
- 105
- 1
- 1
- 13
4
votes
1 answer
ADODB SQL Syntax - Access table Inner Join with Excel worksheet
I have a project where users will need to fill out an Excel file and then export the data to an Access database. The data collected in the Excel file will need to be exported in 3 steps: (1) export data set 1 record, (2) query Access for the primary…
Ryan
- 41
- 2
4
votes
1 answer
How do I upload a zip file via HTTP post using VBA?
This question has been asked many times by others in some form or another but most remained unanswered or the given answer is "Use C#, duh!", which incidentally, is a non-answer. ;-)
I want to upload a zip file to a web server via VBA. The server…
GeneQ
- 7,485
- 6
- 37
- 53
4
votes
3 answers
Oracle 11g ado connection strings for ODBC (not OLEDB) using excel VBA 64 bit (DSN Less and tnsnames)
Please help. I have researched this for hours. I get some parts to work but not others.
What I am trying to do is write all the connection strings in excel VBA to connect to Oracle 11g database. I don't want to set up the User DSN in ODBC…
Rob
- 41
- 1
- 1
- 2
4
votes
2 answers
Check if Connection is OK in Classic ASP
Is there a simple way to check if a connection string was successful in connecting to the specified database:
Scenario:
Connection string example:
ConnString="DRIVER={MySQL ODBC 5.1 Driver}; SERVER=###.###.####.##; PORT=3306; DATABASE=DbName;…
brabstah
- 65
- 1
- 7
4
votes
1 answer
Grant read permission for MSysObjects
I need to get the metadata of some hundred MS Access DBs, so I need to automate the process of metadata gathering.
I want to query stuff described here, but before I can query the DBs I need read access to MSysObjects tables.
I Keep getting…
rammy
- 43
- 1
- 4
4
votes
1 answer
VB6 map string to integer for headers
I'm trying to parse a CSV File into a VB6 application in order to update multiple records on a table on SQL with existing single record updating code already in the form. The CSV Files will have a header row whixh can be used to validate the…
Davidp04
- 145
- 1
- 7
- 17
4
votes
3 answers
Opening Excel file stored on SharePoint as data source using ADODB Connection
I'm trying to use the following VBA code snippet to open an Excel file as a data source:
Dim cn As ADODB.Connection
Set cn = New ADODB.Connection
With cn
.Provider = "Microsoft.ACE.OLEDB.12.0"
.ConnectionString = "Data Source=" & path & "\"…
Matti Wens
- 740
- 6
- 24
4
votes
2 answers
Calling Stored Procedures with Lots of Parameters
Hey I am getting this error with this piece of code and I am not sure why. It would be a great help as i am trying to make my code slightly earier to read
Public Function SaveProperty() As Boolean
'** Save Current Personal Data Record
' Error…
Richard
- 179
- 2
- 10