ADO - Revision history

Water: "work in progress" added

2024-08-13T20:13:52Z

"work in progress" added

← Older revision		Revision as of 20:13, 13 August 2024
Line 126:		Line 126:

	== Examples ==		== Examples ==
	* [[ADO_Example_DB2\|IBM DB2]]		* [[ADO_Example_DB2\|IBM DB2]] (work in progress)
	* [[ADO_Example_Access\|Microsoft Access]]		* [[ADO_Example_Access\|Microsoft Access]] (work in progress)
	* [[ADO_Example_Excel\|Microsoft Excel]]		* [[ADO_Example_Excel\|Microsoft Excel]]
	* [[ADO_Example_Project\|Microsoft Project]]		* [[ADO_Example_Project\|Microsoft Project]] (work in progress)
	* [[ADO_Example_SQL_Server\|Microsoft SQL Server]]		* [[ADO_Example_SQL_Server\|Microsoft SQL Server]] (work in progress)
	* [[ADO_Example_MySQL\|MySQL]]		* [[ADO_Example_MySQL\|MySQL]] (work in progress)
	* [[ADO_Example_Oracle\|Oracle Database Server]]		* [[ADO_Example_Oracle\|Oracle Database Server]] (work in progress)
	* [[ADO_Example_PostgreSQL\|PostgreSQL]]		* [[ADO_Example_PostgreSQL\|PostgreSQL]] (work in progress)
	* [[ADO_Example_SQLite\|SQLite]]		* [[ADO_Example_SQLite\|SQLite]] (work in progress)
	* [[ADO_Example_TextFile\|Text files]]		* [[ADO_Example_TextFile\|Text files]]

MLipok: /* External links */ www.devguru.com: ADO Quick Reference

2020-09-06T16:28:52Z

External links: www.devguru.com: ADO Quick Reference

← Older revision		Revision as of 16:28, 6 September 2020
Line 160:		Line 160:
	*[http://msdn.microsoft.com/en-us/library/windows/desktop/ms675532%28v=vs.85%29.aspx MSDN: Microsoft ADO page]		*[http://msdn.microsoft.com/en-us/library/windows/desktop/ms675532%28v=vs.85%29.aspx MSDN: Microsoft ADO page]
	*[http://msdn.microsoft.com/en-us/library/windows/desktop/ms675944%28v=vs.85%29.aspx MSDN: ADO object model]		*[http://msdn.microsoft.com/en-us/library/windows/desktop/ms675944%28v=vs.85%29.aspx MSDN: ADO object model]
	*[~~http~~://www.devguru.com/technologies/ado/home www.devguru.com: ADO Quick Reference]		*[https://www.devguru.com/content/technologies/ado/home.htmlhome www.devguru.com: ADO Quick Reference]
	*[http://www.w3schools.com/asp/ado_intro.asp www.w3schools.com: Learn ADO]		*[http://www.w3schools.com/asp/ado_intro.asp www.w3schools.com: Learn ADO]
	*[https://www.connectionstrings.com/ www.connectionstrings.com: Learn about many different Connection Strings]		*[https://www.connectionstrings.com/ www.connectionstrings.com: Learn about many different Connection Strings]

	[[Category:Tutorials]][[Category:ADO]]		[[Category:Tutorials]][[Category:ADO]]

Water: /* UDF */

2019-05-17T16:07:04Z

UDF

← Older revision		Revision as of 16:07, 17 May 2019
Line 141:		Line 141:

	== UDF ==		== UDF ==
	mLipok has written an [https://www.autoitscript.com/wiki/User_Defined_Functions#Databases_and_web_connections UDF] to access all kind of databases using ADO.		mLipok has written an [https://www.autoitscript.com/wiki/User_Defined_Functions#Databases_and_web_connections UDF] to access all kind of databases using ADO.<br>

			water has written an [https://www.autoitscript.com/forum/index.php?showtopic=106163 UDF] to access Microsoft Active Directory using ADO.

	== Internal links ==		== Internal links ==

Water at 20:11, 9 January 2017

2017-01-09T20:11:37Z

← Older revision		Revision as of 20:11, 9 January 2017
Line 139:		Line 139:
	== Tools ==		== Tools ==
	Some (AutoIt) tools to make life easier can be found on page → [[ADO Tools]].		Some (AutoIt) tools to make life easier can be found on page → [[ADO Tools]].

			== UDF ==
			mLipok has written an [https://www.autoitscript.com/wiki/User_Defined_Functions#Databases_and_web_connections UDF] to access all kind of databases using ADO.

	== Internal links ==		== Internal links ==

Water: /* OLEDB */

2016-05-27T12:33:19Z

OLEDB

← Older revision		Revision as of 12:33, 27 May 2016
Line 30:		Line 30:
	=== OLEDB ===		=== OLEDB ===
	OLEDB is a Microsoft standard that defines a set of API (Application Interface) functions for accessing all kind of databases (oracle, db2, MS-based databases etc.).<br />		OLEDB is a Microsoft standard that defines a set of API (Application Interface) functions for accessing all kind of databases (oracle, db2, MS-based databases etc.).<br />
	t is a COM (Component Object Model) API that was a follow-up to the ODBC API.<br />		It is a COM (Component Object Model) API that was a follow-up to the ODBC API.<br />
	~~ypically~~ OLEDB is used to create a database specific driver, known as a ''provider'', that can be implemented by a higher level data access library such as ADO ~~or ADO.NET~~.<br />		Typically OLEDB is used to create a database specific driver, known as a ''provider'', that can be implemented by a higher level data access library such as ADO.<br />

	=== ODBC ===		=== ODBC ===

MLipok: /* External links */

2016-05-27T12:27:24Z

External links

← Older revision		Revision as of 12:27, 27 May 2016
Line 155:		Line 155:
	*[http://msdn.microsoft.com/en-us/library/windows/desktop/ms675532%28v=vs.85%29.aspx MSDN: Microsoft ADO page]		*[http://msdn.microsoft.com/en-us/library/windows/desktop/ms675532%28v=vs.85%29.aspx MSDN: Microsoft ADO page]
	*[http://msdn.microsoft.com/en-us/library/windows/desktop/ms675944%28v=vs.85%29.aspx MSDN: ADO object model]		*[http://msdn.microsoft.com/en-us/library/windows/desktop/ms675944%28v=vs.85%29.aspx MSDN: ADO object model]
	*[http://www.devguru.com/technologies/ado/home ~~DevGuru~~: ADO Quick Reference]		*[http://www.devguru.com/technologies/ado/home www.devguru.com: ADO Quick Reference]
	*[http://www.w3schools.com/asp/ado_intro.asp w3schools: Learn ADO]		*[http://www.w3schools.com/asp/ado_intro.asp www.w3schools.com: Learn ADO]
	*[https://www.connectionstrings.com/ connectionstrings: Learn about many different Connection Strings]		*[https://www.connectionstrings.com/ www.connectionstrings.com: Learn about many different Connection Strings]

	[[Category:Tutorials]][[Category:ADO]]		[[Category:Tutorials]][[Category:ADO]]

MLipok: /* External links */ External links "CleanUp"

2016-05-27T12:26:25Z

External links: External links "CleanUp"

← Older revision		Revision as of 12:26, 27 May 2016
Line 153:		Line 153:
	== External links ==		== External links ==

	*[http://msdn.microsoft.com/en-us/library/windows/desktop/ms675532%28v=vs.85%29.aspx Microsoft ADO page]		*[http://msdn.microsoft.com/en-us/library/windows/desktop/ms675532%28v=vs.85%29.aspx MSDN: Microsoft ADO page]
	*[http://msdn.microsoft.com/en-us/library/windows/desktop/ms675944%28v=vs.85%29.aspx ADO object model]		*[http://msdn.microsoft.com/en-us/library/windows/desktop/ms675944%28v=vs.85%29.aspx MSDN: ADO object model]
	*[http://www.devguru.com/technologies/ado/home DevGuru ADO Quick Reference]		*[http://www.devguru.com/technologies/ado/home DevGuru: ADO Quick Reference]
	*[http://www.w3schools.com/asp/ado_intro.asp w3schools ~~- learn~~ ADO]		*[http://www.w3schools.com/asp/ado_intro.asp w3schools: Learn ADO]
	*[https://www.connectionstrings.com/ Learn about many different Connection Strings]		*[https://www.connectionstrings.com/ connectionstrings: Learn about many different Connection Strings]

	[[Category:Tutorials]][[Category:ADO]]		[[Category:Tutorials]][[Category:ADO]]

Water: /* ODBC */

2016-05-27T12:11:59Z

ODBC

← Older revision		Revision as of 12:11, 27 May 2016
Line 35:		Line 35:
	=== ODBC ===		=== ODBC ===
	ODBC is a standard API for accessing SQL based database management systems (DBMS). The designers of ODBC aimed to make it independent of database systems and operating systems.<br />		ODBC is a standard API for accessing SQL based database management systems (DBMS). The designers of ODBC aimed to make it independent of database systems and operating systems.<br />
	This is accomplished by using an ODBC driver as a translation layer between the application and the DBMS. The application uses ODBC functions through an ODBC driver manager with which it is linked, and the driver passes the query to the DBMS.		This is accomplished by using an ODBC driver as a translation layer between the application and the DBMS. The application uses ODBC functions through an ODBC driver manager with which it is linked, and the driver passes the query to the DBMS.<br />
			There are commercial products available to access Applications and WebAPIs like Google Sheets, Microsoft SharePoint, Twitter and so on.

	== Internals ==		== Internals ==

Water: /* ODBC */

2016-05-27T12:07:53Z

ODBC

← Older revision		Revision as of 12:07, 27 May 2016
Line 35:		Line 35:
	=== ODBC ===		=== ODBC ===
	ODBC is a standard API for accessing SQL based database management systems (DBMS). The designers of ODBC aimed to make it independent of database systems and operating systems.<br />		ODBC is a standard API for accessing SQL based database management systems (DBMS). The designers of ODBC aimed to make it independent of database systems and operating systems.<br />
	~~ODBC accomplishes DBMS independence~~ by using an ODBC driver as a translation layer between the application and the DBMS. The application uses ODBC functions through an ODBC driver manager with which it is linked, and the driver passes the query to the DBMS.		This is accomplished by using an ODBC driver as a translation layer between the application and the DBMS. The application uses ODBC functions through an ODBC driver manager with which it is linked, and the driver passes the query to the DBMS.

	== Internals ==		== Internals ==

Water: /* ODBC */

2016-05-27T12:07:16Z

ODBC

← Older revision		Revision as of 12:07, 27 May 2016
Line 34:		Line 34:

	=== ODBC ===		=== ODBC ===
	ODBC is a standard API for accessing database management systems (DBMS). The designers of ODBC aimed to make it independent of database systems and operating systems.<br />		ODBC is a standard API for accessing SQL based database management systems (DBMS). The designers of ODBC aimed to make it independent of database systems and operating systems.<br />
	ODBC accomplishes DBMS independence by using an ODBC driver as a translation layer between the application and the DBMS. The application uses ODBC functions through an ODBC driver manager with which it is linked, and the driver passes the query to the DBMS.		ODBC accomplishes DBMS independence by using an ODBC driver as a translation layer between the application and the DBMS. The application uses ODBC functions through an ODBC driver manager with which it is linked, and the driver passes the query to the DBMS.

← Older revision		Revision as of 20:13, 13 August 2024
Line 126:		Line 126:

	== Examples ==		== Examples ==
	* [[ADO_Example_DB2\|IBM DB2]]		* [[ADO_Example_DB2\|IBM DB2]] (work in progress)
	* [[ADO_Example_Access\|Microsoft Access]]		* [[ADO_Example_Access\|Microsoft Access]] (work in progress)
	* [[ADO_Example_Excel\|Microsoft Excel]]		* [[ADO_Example_Excel\|Microsoft Excel]]
	* [[ADO_Example_Project\|Microsoft Project]]		* [[ADO_Example_Project\|Microsoft Project]] (work in progress)
	* [[ADO_Example_SQL_Server\|Microsoft SQL Server]]		* [[ADO_Example_SQL_Server\|Microsoft SQL Server]] (work in progress)
	* [[ADO_Example_MySQL\|MySQL]]		* [[ADO_Example_MySQL\|MySQL]] (work in progress)
	* [[ADO_Example_Oracle\|Oracle Database Server]]		* [[ADO_Example_Oracle\|Oracle Database Server]] (work in progress)
	* [[ADO_Example_PostgreSQL\|PostgreSQL]]		* [[ADO_Example_PostgreSQL\|PostgreSQL]] (work in progress)
	* [[ADO_Example_SQLite\|SQLite]]		* [[ADO_Example_SQLite\|SQLite]] (work in progress)
	* [[ADO_Example_TextFile\|Text files]]		* [[ADO_Example_TextFile\|Text files]]