Stack Overflow
Stack Overflow

Questions tagged [ado]

Microsoft ActiveX Data Objects (ADO) is a COM based package for accessing databases such as SQL Server or data sources such as Excel spreadsheets. ADO.NET provides improvements over ADO along with integration with the .NET Framework for .NET developers. ADO.NET tag should be used for ADO.NET specific questions.

Microsoft developed ADO as a set of COM objects providing a middleware between an application and ODBC for accessing data sources. With ADO, the programmer has a more generic interface to database engines such as SQL Server as well as to other data sources such as Excel spreadsheets.

ADO provides a set of COM objects which a programmer can instantiate and then use for particular data source accesses. Being COM objects, ADO can be used with a variety of programming languages. The ADO interface allows SQL statements to be passed to a data source that supports SQL.

ADO contains 4 collections and 12 objects.

ADO.NET is a replacement for ADO in the .NET Framework.

Links:

References:

2633 questions
11
votes
4 answers

How to solve TimeOut Expired Problem?

Using SQL Server 2005 and VB6 When I executing for yearly data or more than 3 months' data, it is showing "Timeout Expired" error. It is not executing completely. My Connection String ConnectionString = "Provider=SQLOLEDB.1;" & _ "Persist…
Gopal
  • 11,712
  • 52
  • 154
  • 229
11
votes
3 answers

Connecting Excel to PostgreSQL via VBA

Is it possible to make query like SELECT from VBA in Excel, so I can query a PostgreSQL DB from Excel? If is possible please explain me how to connect to the database. I was looking in Google but found no results.
vivid
  • 1,115
  • 2
  • 14
  • 34
11
votes
1 answer

COM msado15.dll Program has stopped running

We had been using the old msado15.dll in our program . And we used to import it #import "msado15.dll" . Now just a few days back we upgraded to Windows 8. And alas, our software stopped working on Windows 7 which didnt have Service pack 1…
Saurabh
  • 241
  • 2
  • 12
11
votes
4 answers

VBScript: Passing a parameter with a null value to a stored procedure?

In VBScript (ASP environment), is it possible to pass a parameter with a null value to a stored procedure?
burnt1ce
  • 14,387
  • 33
  • 102
  • 162
10
votes
1 answer

How to get the insert ID from this ADODB.Recordset?

I'm trying to avoid using straight SQL queries in my web app. I looked around and have come to the conclusion that ADO Recordsets would be the best or at least safest tool for the job. I need to insert records into a database table. Unfortunately…
sholsinger
  • 3,028
  • 2
  • 23
  • 40
10
votes
1 answer

VB6 application ado connection for TLS1.2

I have to support a VB6 application that is still in production (ugh). A customer is specifying our software needs to be PCI compliant which requires TLS 1.2. Anyone know how to do this? I am using SQL Server 2014. I'm patched to build…
FatherOfDiwaffe
  • 300
  • 1
  • 2
  • 12
10
votes
3 answers

Connection string syntax for Classic ADO / ODBC / Oracle 10g EZConnect

I'm trying to connect various VBA projects to an Oracle 10g back end using ADO (2.8) and no TNS. After various attempts, we've decided that the simplest series of steps for a clean installation include: Set up an Oracle Instant Client Install the…
downwitch
  • 1,362
  • 3
  • 19
  • 40
10
votes
3 answers

Why doesn't Microsoft support OLE DB connections to SQL Azure?

At the MSDN website it says, "Connecting to SQL Azure by using OLE DB is not supported." There are other places on the web where folks report that it works fine for them after tweaking the server name in the connection string, such as here and here.…
Troy
  • 1,237
  • 2
  • 13
  • 27
10
votes
4 answers

View output of 'print' statements using ADOConnection in Delphi

Some of my MS SQL stored procedures produce messages using the 'print' command. In my Delphi 2007 application, which connects to MS SQL using TADOConnection, how can I view the output of those 'print' commands? Key requirements: 1) I can't run the…
apenwarr
  • 10,838
  • 6
  • 47
  • 58
10
votes
2 answers

Read large file line-by-line with ADO Stream?

I want to use ADO Stream to read lines from a local large text file with UTF-8 encoding so I try Set objStream = CreateObject("ADODB.Stream") objStream.Charset = "utf-8" objStream.Type = 2 objStream.Open objStream.LoadFromFile =…
Teiv
  • 2,605
  • 10
  • 39
  • 48
10
votes
4 answers

Classic ASP - SQL Server 2008 Connection String using Windows Authentication

This should be painfully simple, but I cannot come up with a working connection string for a local copy of SQL Server 2008 using Windows Authentication. I've tried using the Data Link Properties tool to create a connection string and it has no…
Nathan Taylor
  • 24,423
  • 19
  • 99
  • 156
10
votes
2 answers

Is Delphi's TADOConnection thread-safe?

I'm writing a Delphi 7 application which needs to access the same SQL Server database from many different threads simultaneously. Can I use a single shared TADOConnection, or must each thread create their own?
Blorgbeard
  • 101,031
  • 48
  • 228
  • 272
9
votes
1 answer

What is "*;1" in TADOStoredProc.ProcedureName value in Delphi?

You may specify TADOStoredProc.ProcedureName in Delphi with the following value: MSSQLProcedureName;1 But what does meen ";1" in this value? Thanks for the help!
Dmitry
  • 14,306
  • 23
  • 105
  • 189
9
votes
1 answer

Recordset Closed After Stored Procedure Execution

I'm executing a stored procedure using ADO in VBA. I'm trying to populate the recordset with the results from a stored procedure in SQL Server 2008. Example of the VBA below: Public Function DoSomething() As Variant() Dim oDB As ADODB.Connection:…
Gareth
  • 5,140
  • 5
  • 42
  • 73
9
votes
3 answers

How to pass NULL or empty strings to stored procedure input parameter with ADO and VB?

I have a stored procedure in Sql Server 2005 with a varchar input parameter defined as: @Value varchar(24) = NULL in my VB6 application I try to set the parameter with an ADO function: Set prmParamVal = cmdChkParam.CreateParameter(, adVarChar,…
räph
  • 3,634
  • 9
  • 34
  • 41
1 2
3
…
99 100