|
The System DSN panel shows which DSN are currently created into the odbc.ini file. With right buttons
you can Add a new DSN or also Remove, Edit or Test the selected DSN.
|
|
|
The ODBC Drivers panel shows which ODBC drivers are currently installed into the system in the ODBC's Driver directory.
Look at downloads section to see which drivers are available.
|
|
|
The About panel shows the ODBC components version and date. Look at downloads section to see
if newer version are available to download
|
|
|
The ODBC Driver Chooser window allow to choose which driver use to create a new DSN. Once clicked to Finish button
you will be able to configure the DSN with all its parameters.
An existing DSN cannot change its driver type. So if you want to change its type you must remove it and recreate the DSN with the new driver.
|
|
|
When you create a DSN, you can work with its parameters simply using the Keyword, Value pair of String gadget.
Refer to the driver documentation to see which parameters are allowed. To test the DSN use the Test button into the System DSN
panel providing Username and Password when asked.
|
|
|
When you test a DSN you can receive an error if something is not configured well. The result code and description may vary and are returned by the
server or driver. In this screenshot a SQL Server warn the user for a bad password (in italian language)
|
|
|
In the current ODBC package is included a CLI tool that allow you to test the DSN or either a connection string provided to the program.
In the screenshot you can see a connection to a SQL Server Database that show a TOP 5 * on a table.
|
|
|
|
|
|
|
Some simply python instructions to fetch data from SQL Server Database using pyODBC (not yet released)
Now it is possible to use python language to fetch data from any database!
|
|
iODBC - Independent Open DataBase Connectivity for AmigaOS4