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
5
votes
1 answer

ADODB.Stream error '800a0bbc' Write to file failed

I've weird and strange error showing while I change hosting provider which is: ADODB.Stream error '800a0bbc' Write to file failed. /cp/portal_upload.asp, line 63 I gave the needed permissions and it solve the update Access DB problem but file…
MrMatar
  • 51
  • 1
  • 1
  • 2
5
votes
3 answers

Named variables in SQL using ADODB in vba

I have lots of SQL scripts, many of which use various different variables throughout, and I'd like to be able to drop the results directly into Excel. The hope is to do this as 'smoothly' as possible, so that when someone gives me a new SQL script…
John Faben
  • 151
  • 1
  • 9
5
votes
2 answers

ADO Command running multiple SQL statements: can't get error message back: USE THE Connection.Errors collection

I have some triggers on various tables that use raiserror to tell the user that he tried to do something bad. I would like to run several inserts and updates atomically, rolling back if one of the triggers says so. I was evil in a former life so I'm…
ajd
  • 423
  • 4
  • 11
5
votes
5 answers

SQL query doesn't return full results for only one field

I'm having a problem using VBA to execute a SQL query and copy the results into an Excel worksheet. When the sub excecutes, it only copies rows that are multiples of 256 (so rows 256, 512, 768 etc are the only ones that are filled into Excel). I'm…
Liam Barrett
  • 123
  • 1
  • 1
  • 10
4
votes
2 answers

PHP interpreter gets undefined constant OCI_COMMIT_ON_SUCCESS with ADODB

I wrote a php script that must be run on the php interpreter (Without Apache), which uses the adodb library with an Oracle database, but when I try to run it, I'm getting the following error: PHP Notice: Use of undefined constant…
adiego73
  • 189
  • 1
  • 3
  • 13
4
votes
3 answers

Using ADODB to access opened xls file

Although I've been working with VBA for Excel for quite a long time, I've one problem I cannot solve by myself. I've described it below, hope to get some help or advice. I'm using Excel 2007 and Windows XP, all updated with newest patches. I'm very…
mj82
  • 5,193
  • 7
  • 31
  • 39
4
votes
2 answers

ADODB query updates Excel cell as escaped text

I'm trying update a cell within an Excel 2003 spreadsheet, but the problem that I'm having is that Excel adds a single quote to the front of my value. Is there any way to enter the value as an integer and not as an escaped string? Thanks!! Const…
ant
  • 171
  • 2
  • 13
4
votes
2 answers

How do you create an ADODB disconnected recordset in a VB.NET Windows application?

I'm using an OLEDB connection to a Sybase database, with ADODB.dll file version 7.10.6070.0 (which comes from the Sybase 12.5 package). I need to be able to open a connection, use a command object to fill a recordset from a stored procedure, then…
Matt Hamsmith
  • 3,955
  • 1
  • 27
  • 42
4
votes
1 answer

SQLite 'long' integers are returned truncated/incorrect by SQL select query — how can the correct values be retrieved? (SQLite ODBC driver, VBA/ADODB)

In Excel VBA with the SQLite ODBC Driver, my simple SELECT query run against a single table retrieves 'long' integers (10 or more decimal places) incorrectly. How can these values be retrieved correctly, without truncation or whatever garbling is…
Joan Eliot
  • 267
  • 1
  • 8
4
votes
1 answer

Is this secure? ADOdb prepared statements

I am using ADOdb for connecting to my MSSQL database. I am wondering is this good enough to prevent SQL injection? The prepared query that I am using is: $db = ADONewConnection('odbc_mssql'); $dsn = "Driver={SQL…
GEMI
  • 2,239
  • 3
  • 20
  • 28
4
votes
1 answer

No recordset is returned if one of the column has data more than 1024 characters Mysql 8.0 and Classic ASP

I am using 32 bit MySQL ODBC connector 8.19 with Classic asp MYSQL server is 8. CHARACTER is latin1 and COLLATE is latin1_swedish_ci Connection string has OPTION=3 Storage Engine is InnoDB Following is the table structure CREATE TABLE…
Anjali
  • 43
  • 3
4
votes
0 answers

Out Of Memory (7) when upload file in VB6 using MSXML

i have a function to upload multipart/form-data with Visual Basic 6 using MSXML2.ServerXMLHTTP60, no problem with 100MB file size, but when i upload 200MB it's show "Run Time Error '7'" Out Of Memory. this is my code: Public Function PostFile(sUrl…
Abu Ayyub
  • 401
  • 4
  • 14
4
votes
3 answers

Parameterized Queries in VBA + ADODB + Oracle

I'm new to working with Oracle 11g and I'm having a lot of issues getting a parameterized query to work smoothly. this code works: Dim rs As ADODB.Recordset Dim con As ADODB.Connection Dim cmd As ADODB.Command Dim prm As…
ArcherBird
  • 2,019
  • 10
  • 35
4
votes
1 answer

VB6 App won't work on Server 2008 after recompile

I'm trying to move web servers. Our app (be kind) was written back in 1998 (I think) in VB6. I've got it working on our new server (Windows Server 2008 R2 64 bit). However, when I take the source code on my machine (Windows 7 64 Bit), and…
Matt Dawdy
  • 19,247
  • 18
  • 66
  • 91
4
votes
2 answers

VBA Error handling on ADODB Connection.Open

I have an ADODB connection in VBA for connecting to an SQLServer database. I want to catch the error that is raised when connection.Open is called and the given database is unreachable. My code looks like this: Public Function Connect() As…
PKeno
  • 2,694
  • 7
  • 20
  • 37
1 2 3
…
99 100