Stack Overflow
Stack Overflow

Questions tagged [adodb]

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.

1825 questions
0
votes
0 answers

ADODB.Recordset returns with incorrect data?

I have an ADO.Recordset object that is able to successfully connect to the database and pull data. However, the data that is in the database vs what is being retrieved by the object is incorrect. For example, if I take the exact query that is in…
Nick Peterson
  • 1
0
votes
0 answers

Pulling data from RedPrarie client using VBA

I'm trying to automate certain processes at my work. They are currently using RedPrarie Client I already know how to pull data from an sql table using VBA ADODB and ODBC connection. But integrating this with RedPrarie seems to be a grey topic. Can…
Luigi
  • 439
  • 5
  • 23
0
votes
1 answer

Null memo fields when opening a csv file as a recordset using ADODB

I'm pretty stuck with this and don't know how to proceed. I am using ADODB to open a CSV file, this is working correctly however my text fields that exist in the CSV file are being opened as null fields, all of the number fields are correctly being…
David Coles
  • 45
  • 1
  • 11
0
votes
1 answer

reading a CSV file with asp getting null values

I am using classic asp to import data into a MySQL database, however I'm running into a bit of trouble, even though the fields exist in the CSV file my code returns the values as NULL As I want to open the CSV file as a recordset I first have to…
David Coles
  • 45
  • 1
  • 11
0
votes
1 answer

Strange ADO behavior generating unwanted NO_BROWSETABLE / set fmtonly queries in VB6

I am strugling with some unwanted metadata requests automatically generated by ADO. The behavior started after replacing the default MSDASQL provider with SQLOLEDB. I have also tried the SQLOLEDB and the behavior seems to be the same. Reproducing…
moander
  • 2,080
  • 2
  • 19
  • 13
0
votes
2 answers

Though deprecated, is DAO still used for automation of Access databases from Excel?

I'm trying to wrap my head around it. I've checked other questions and nothing seems to be too similar. The Office 2013 development centre contains extensive DAO examples and states it is one of the easiest ways to work with an Access file (does…
Rick Henderson
  • 326
  • 3
  • 14
0
votes
1 answer

Weird ODBC error

I'm using an Access front-end for an Microsoft SQL back-end. The problem I'm facing, is that I'm inserting data with an adodb connection. I use this on multiple forms. On the first form it works, on the second form it works, on the third form it…
Walker
  • 1
  • 1
0
votes
1 answer

Open an ANSI csv file and read the content as utf-8

I have a csv file on the server encoded as ANSI, and want to open it, process and save the content on the database. I'm having infinite problems with the accented character as "à è ì ò ù", getting instead "?". The content in the html header is set…
Fehu
  • 381
  • 1
  • 3
  • 18
0
votes
0 answers

How can I make my adodc connect faster to my SQL Server?

How can I make my adodc connect faster to my SQL Server? It's taking a minute (so long) before I can view thousand of record in my listview. Please anyone help me. I'm using this code: Public Class McheckpaymentNew Private cn As New…
Eon Rosales Rodil
  • 1
  • 1
  • 2
0
votes
1 answer

Userform_Initialize Null String On Reopen

I have setup a VBA Userform (in a word document) on Initialize it is set so that a combobox (MoniesInDescription) populates via an external Excel File. It works all fine, except after I have saved my document and reopen if I try to run the code i…
bssm
  • 1
  • 2
0
votes
2 answers

Dumping an ADODB recordset to XML, then back to a recordset, then saving to the db

I've created an XML file using the .Save() method of an ADODB recordset in the following manner. dim res dim objXML: Set objXML = Server.CreateObject("MSXML2.DOMDocument") 'This returns an ADODB recordset set res = ExecuteReader("SELECT * from…
Mark Biek
  • 146,731
  • 54
  • 156
  • 201
0
votes
1 answer

PHP ADODB & MySQL, binding parameters

I'm using ADODB and MYSQL, trying to execute an INSERT statement. Though I've read plenty of forum posts and learned that I cannot bind parameters as easily as with oci8, I still have not found an example similiar to what I'm trying to achieve. My…
Juan M
  • 4,063
  • 4
  • 19
  • 28
0
votes
1 answer

VBA ADODB DATE field type from Oracle database

I have a VBA/ADODB code that connects Excel to Oracle DB and runs an SQL Query. The problem is that the recordset in Excel shows Oracle DATE fields as adDBTimeStamp (135) even though in Oracle they are stored as simple dates. Basically i want to…
user1810355
  • 135
  • 1
  • 6
0
votes
1 answer

link datagrid to adodb

please can anyone tell the wrong of this attached project * the data appears as empty in the grid! * dgv.rows.add(5) also don't work! https://www.dropbox.com/s/s96dw694wc744od/WindowsApplication2.rar?dl=0 Imports ADODB Imports…
Bass Alfan
  • 9
  • 4
0
votes
0 answers

VBScript ADODB.Stream type mismatch

I am writing an HTA application to manage Hyper-V, and I am stuck on the GetVirtualSystemThumbnailImage script. I took the VBScript example from: https://msdn.microsoft.com/en-us/library/cc160707(v=vs.85).aspx but that script never actually calls…
Mako-Wish
  • 303
  • 2
  • 12
1 2 3
…
99
100