NsODBC plug-in - Revision history

Outtay: /* Download Link */

2023-12-06T10:45:36Z

Download Link

â† Older revision		Revision as of 10:45, 6 December 2023
Line 5:		Line 5:

	== Download Link ==		== Download Link ==
	<attach>NsODBC.zip</attach>		<attach>NsODBC.zip</attach><br>
			<attach>NsODBC-unicode.zip</attach>

	== Methods ==		== Methods ==

213.229.157.152: /* References */

2007-09-06T09:51:14Z

References

â† Older revision		Revision as of 09:51, 6 September 2007
Line 41:		Line 41:
	[[Category:Plugins]]		[[Category:Plugins]]
	[[Category:Database Functions]]		[[Category:Database Functions]]
	~~No funciona~~

213.229.157.152: /* References */

2007-09-06T09:50:44Z

References

â† Older revision		Revision as of 09:50, 6 September 2007
Line 41:		Line 41:
	[[Category:Plugins]]		[[Category:Plugins]]
	[[Category:Database Functions]]		[[Category:Database Functions]]
			No funciona

Zippy1981: Demonstrated how to create a mdb file with this function

2006-08-31T17:23:36Z

Demonstrated how to create a mdb file with this function

â† Older revision		Revision as of 17:23, 31 August 2006
Line 7:		Line 7:
	<attach>NsODBC.zip</attach>		<attach>NsODBC.zip</attach>

	== ~~The Script~~ ==		== Methods ==
	<highlight-nsis>		<highlight-nsis>
			::AddDSN ;[DriverName] Parameters pairs follows: [DSN=XXX] [UID=0x777] ...
			::AddSysDSN ;[DriverName] Parameters pairs follows: [DSN=XXX] [UID=0x777] ...
			::ConfDSN ;[DriverName] Parameters pairs follows: [DSN=XXX] [UID=0x777] ...
			::ConfSysDSN ;[DriverName] Parameters pairs follows: [DSN=XXX] [UID=0x777] ...
			::RemoveDSN ;[DriverName] Parameters pairs follows: [DSN=XXX] [UID=0x777] ...
			::RemoveSysDSN ;[DriverName] Parameters pairs follows: [DSN=XXX] [UID=0x777] ...
			::RemoveDefDSN ;[DriverName] Parameters pairs follows: [DSN=XXX] [UID=0x777] ...
			</highlight-nsis>

			== Example Scripts ==
			<highlight-nsis>

	; Create MS Access DSN & Data Base		; Create MS Access DSN & Data Base
	nsODBC::AddSysDSN "Microsoft Access Driver (*.mdb)" "DSN=SERVER_${PRJ_NAME}_DB"		nsODBC::AddSysDSN "Microsoft Access Driver (*.mdb)" "DSN=SERVER_${PRJ_NAME}_DB"
Line 15:		Line 27:
	; Remove DSN		; Remove DSN
	nsODBC::RemoveSysDSN "Microsoft Access Driver (*.mdb)" "DSN=SERVER_${PRJ_NAME}_DB"		nsODBC::RemoveSysDSN "Microsoft Access Driver (*.mdb)" "DSN=SERVER_${PRJ_NAME}_DB"
			</highlight-nsis>

	~~; Methods:~~		It is also possible to create, compact, and repair Microsoft Access mdb files with this plugin. A link below explains the syntax for compacting and repairing the database.
	~~::AddDSN ;[DriverName] Parameters pairs follows: [DSN=XXX] [UID=0x777] .~~..		'''Notice:''' Be sure to put the path to the database file in escaped quotes as the command will fail if there are spaces in the file name otherwise.
	~~::AddSysDSN) ;[DriverName] Parameters pairs follows~~: ~~[DSN=XXX] [UID=0x777] ..~~.		<highlight-nsis>
	~~::ConfDSN) ;[DriverName] Parameters pairs follows: [DSN=XXX] [UID=0x777] ...~~		; Create a JetSQL (mdb) file.
	~~::ConfSysDSN~~ ;~~[DriverName] Parameters pairs follows: [DSN=XXX] [UID=0x777] ..~~.		nsODBC::AddDSN "Microsoft Access Driver (*.mdb)" "CREATE_DB=$\"$INSTDIR\foo.mdb$\" General"
	::~~RemoveDSN ;[DriverName] Parameters pairs follows: [DSN=XXX] [UID=0x777]~~ ...
	~~::RemoveSysDSN ;[DriverName] Parameters pairs follows: [DSN=XXX] [UID=0x777] ...~~
	~~::RemoveDefDSN ;[DriverName] Parameters pairs follows: [DSN=XXX] [UID~~=~~0x777] ..~~.
	</highlight-nsis>		</highlight-nsis>

			== References ==
			[http://support.microsoft.com/kb/126606/EN-US/ MS Knowledge base article that demonstrates CREATE_DB, REPAIR_DB, and COMPACT_DB]

	[[Category:Plugins]]		[[Category:Plugins]]
	[[Category:Database Functions]]		[[Category:Database Functions]]

Kichik: added download link

2006-06-30T17:46:01Z

added download link

â† Older revision		Revision as of 17:46, 30 June 2006
Line 2:		Line 2:

	== Description ==		== Description ==
	nsODBC is NSIS ODBC Configuration Manager. Works over		nsODBC is NSIS ODBC Configuration Manager. Works over odbcinst32.dll. Based on SQLInstall Win API.
	odbcinst32.dll. Based on SQLInstall Win API.
			== Download Link ==
			<attach>NsODBC.zip</attach>

	== The Script ==		== The Script ==
Line 25:		Line 27:

	[[Category:Plugins]]		[[Category:Plugins]]
			[[Category:Database Functions]]

Deguix: ODBC Configuration Manager moved to NsODBC plug-in

2005-12-03T15:00:59Z

ODBC Configuration Manager moved to NsODBC plug-in

â† Older revision

Revision as of 15:00, 3 December 2005

ConversionBot: Adding new author and category links.

2005-06-24T13:32:59Z

Adding new author and category links.

â† Older revision		Revision as of 13:32, 24 June 2005
Line 1:		Line 1:
	{~~\|align=right~~		{{PageAuthor\|sl}}
	~~\|<small>Author: [[~~{~~{ns:2}}:sl~~\|sl~~]] ([[{{ns:3}}:sl\|talk]], [[{{ns:-1}~~}~~:Contributions/sl\|contrib]])</small>~~
	\|}
	~~<br style="clear:both;">~~
	== Description ==		== Description ==
	nsODBC is NSIS ODBC Configuration Manager. Works over		nsODBC is NSIS ODBC Configuration Manager. Works over
Line 26:		Line 24:
	</highlight-nsis>		</highlight-nsis>

	[[~~{{ns:14}}~~:Plugins]]		[[Category:Plugins]]

ConversionBot: Added category links.

2005-04-30T21:37:10Z

Added category links.

â† Older revision		Revision as of 21:37, 30 April 2005
Line 25:		Line 25:
	::RemoveDefDSN ;[DriverName] Parameters pairs follows: [DSN=XXX] [UID=0x777] ...		::RemoveDefDSN ;[DriverName] Parameters pairs follows: [DSN=XXX] [UID=0x777] ...
	</highlight-nsis>		</highlight-nsis>

			[[{{ns:14}}:Plugins]]

ConversionBot: Updated author links.

2005-04-30T03:01:33Z

Updated author links.

@@ Line 1: / Line 1: @@
 == Description ==
    nsODBC is NSIS ODBC Configuration Manager. Works over
@@ Line 21: / Line 25: @@
      ::RemoveDefDSN ;[DriverName] Parameters pairs follows: [DSN=XXX] [UID=0x777] ...
 </highlight-nsis>

ConversionBot: Updated author and download links, and changed format of some pages.

2005-04-23T12:39:58Z

Updated author and download links, and changed format of some pages.

â† Older revision		Revision as of 12:39, 23 April 2005
Line 22:		Line 22:
	</highlight-nsis>		</highlight-nsis>

			Page author: [[User:sl\|sl]]
	Page author: sl