Outtay: Outtay moved page User:Outtay to NsODBCext plug-in: Didn't know how to create in main

2023-12-11T15:41:28Z

Outtay moved page User:Outtay to NsODBCext plug-in: Didn't know how to create in main

â† Older revision

Revision as of 15:41, 11 December 2023

Outtay: NsODBCext plug-in

2023-12-11T15:40:06Z

NsODBCext plug-in

New page

{{PageAuthor|Outtay}}

== Description ==
nsODBCext is an NSIS ODBC Configuration Manager. Works using odbcinst32.dll. Based on SQLInstall Win API. This plugin is based on [https://nsis.sourceforge.io/NsODBC_plug-in NsODBC]. <br>
The main way it differs is by changing the parameter format, such that the whole stack isn't read in and by also retrying the SQLInstall call with a multistring format, which is required for the SQL Server driver.

== Download Link ==
<attach>NsODBCext.zip</attach>

== Methods ==
The plugin was not tested with all functions. Only AddDSN was required for my use case. Source Code is attached. Please modify as you see fit.
<highlight-nsis>
::AddDSN ;[DriverName] [DSN=XXX;UID=0x777] ...
::AddSysDSN ;[DriverName] [DSN=XXX;UID=0x777] ...
::ConfDSN ;[DriverName] [DSN=XXX;UID=0x777] ...
::ConfSysDSN ;[DriverName] [DSN=XXX;UID=0x777] ...
::RemoveDSN ;[DriverName] [DSN=XXX;UID=0x777] ...
::RemoveSysDSN ;[DriverName] [DSN=XXX;UID=0x777] ...
::RemoveDefDSN ;[DriverName] [DSN=XXX;UID=0x777] ...
</highlight-nsis>

== Example Scripts ==
<highlight-nsis>

; Create MS Access DSN & Data Base
nsODBC::AddSysDSN "Microsoft Access Driver (*.mdb)" "DSN=MyDSN;DBQ=C:\Dev\MyAccess.mdb"

; Create SQL Server DSN
nsODBC::AddDSN "SQL Server" "DSN=MyDSN;SERVER=127.0.0.1,1433;Trusted_Connection=Yes;DATABASE=myDB"

; Remove DSN
nsODBC::RemoveSysDSN "Microsoft Access Driver (*.mdb)" "DSN=MyDSN"
</highlight-nsis>

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

NsODBCext plug-in - Revision history

Outtay: Outtay moved page User:Outtay to NsODBCext plug-in: Didn't know how to create in main

Outtay: NsODBCext plug-in