ODBC software

I spotted this link from Amiganew
http://www.amigasoft.net/pages/odbc/downloads.asp
downloaded the software

Seems interesting enough but some newbee introduction might help.

What can you do with it and how, first steps anybody?

@JosDuchIt

i have no experience with database but i think it is a database manager, and most important, you can import and export database from various db platform like microsft db (mdb), mysql and so on..

i think also you can use it to create and manage database under amiga os 4.x .. you should ask to afx for more infos about it

@JosDuchIt

you can connect your Amiga to ODBC databases like SQL Server, MySQL, sqlite and so on.
But you need this only if you are a developer and/or a power user that needs this. If you are a simply user maybe you don't need this.

@afxgroup


I am trying to maintain the Gui4CLi scripting language source from D Keletsekis.

I have ported it to OS4 (only the pipe functionality is still a problem)
I have not worked on it for some months now.
I think better database support internally (comma separated files), or external interface to big databases would be a very nice thing te have as a first expansion of the language.
I guess i could try to use the library to build a Gui4Cli written ODBC manager.
Since i did not find 'starter' documentation about it, I am interested of discussing this with knowledgeabel people.

@JosDuchIt

you can find all informations here:

http://www.iodbc.org/dataspace/iodbc/wiki/iODBC/

you have a shared object (libiodbc.so) that allows you to connect to ODBC data sources. The binding with Gui4Cli could be problematic but since i don't know how it works it is possible i'm wrong.
BTW, if you search on Google iODBC you will find tons of examples

@afxgroup

Thanks, i am continuing llokong at this

I assembled the usefull links at
http://users.online.be/AD/ODBC.htm

I have the impression that it should be possible tot do a an easy test with the file ioDBCtest and with iODBC (data source administrator) whose gui tells me no driver is installed, so allthough they are present i would like to know how they can be added.
Did not find this yet in any doc.
I did not find a contact for the Amiga port neither

@JosDuchIt

no drivers or no connections?

P.S.
i'm the author of the iODBC

@afxgroup

Great to hear you are the author. If i inderstand your avatar and emoticons it was pretty exhausting, or you are wasting? your energy elsewhere ;)

The question in fact is: can i easily test what is in the 2 archives? How?

Here is what i tried:

I have all the iODBC files in sys:libs drawer.
I do see 2 icons iODBC and iODBCtest(SQL)
clicking on iODBC a gui appears "IODBC Source Administrator" and immediately a "IODBC Data Source Administrator" message appears " No ODBC drivers installed"
Clicking OK, and coming back to "iODBC Source Administrator " clicking in the 'System DSN's Add (a system Data Source Name) the same message appears, clicking on OK an other requester gui appears "Choose an ODBC Driver" However no driver is present in the list.

In the "iODBC Data Source Administrator" when chosing the ODBC Drivers tab, no drivers in the list neither.

In the about tab i see the 3 files
"iODBC Driver Manager" libiodbs.so - - v3.52.7
"iODBC Adminsitrator " iODBC 'Wed Dec' 362 kB V3.52.7
"iODBC installer" libiodbcinst.so - - V 3.52.7


Going back to the ODBC drawer & clickin on iODBC test the program outputs:

"ODBC Demonstration program
This program shows an interactive SQL processor
Driver Manager: 03.52.0709.0909
1: SQLDriverConnect = [iODBC][Driver Manager]Data source name not found and no default driver specified. Driver could not be loaded (0) SQLSTATE=IM002
1: ODBC_Connect = [iODBC][Driver Manager]Data source name not found and no default driver specified. Driver could not be loaded (0) SQLSTATE=IM002

Have a nice day."

I have the SQL Manager drawer in sys:utilities, clickin on its icon the "SQL manager -NoNme.sql appears" and another gui connect to an ODBC data source" appears,
The gadget "Select the DSN to use" does not show any available DSN.

When clicking on NewDSN button a "SQL manager" window appears with the lines:
Sys:Libs/ODBC/iODBC: Unknown command
Sys:Libs/ODBC/iODBC failed returncode 10

I suppose i should also know of some (free) database to connect to.

Thanks for your programming and for your help

Joseph

@JosDuchIt

you must install all in Sys:Libs/ODBC/ and not in Sys:Libs

BTW in the next version the program will search ODBC: so you can install the package wherever you want.

@afxgroup

That's what i did., nearly in fact: in sys:libs/iODBC, Not as stated on the website;

I have renamed it and am seeing the drivers now.

If i understand what i did read about ODBC what i need now is a local database or a database on a remote computer to connect ot.
Any suggestion to which remote database i might connect?

@JosDuchIt

at moment you can use remote servers like SQL Server, Postgre or MySQL or local db like sqlite that could be the bes solution for client programs. Indeed it is used on many software. MDB support seems broken or at least i cannot connect to any mdb file.. but you can try with your hands

@afxgroup

I run a local MySQL server here, and trying to connect to it just leads me to a string of DSI's.

According to the crashlogs, it's in the FreeChooserList() function().

This happens quite a bit, especially if I "Ignore DSI's" and try to continue.

If you have the sources in a repsoitory somewhere , and would like me to take a look at it, contact me via PM. Either that, or I'll pass you the crashlogs.

Simon

@Rigo

uhm.. i'll connect to irc channel asap. in the meanwhile i'll try my local mysql server to see if it happens also to me since all my tests are done on SQL Server.

@Rigo

How did you configure your amiga user on MySQL? in the past when i've tried the driver it was working.. but now it seems that i don't have the remote access turned on for my Amiga client IP

@afxgroup

Well, once I finally worked out that "DSN Name" could actually be an IP address, I entered the local address of the MySQL server, chucked in the login details, and instantly got the DSI.

Simon

@Rigo

uhm, this driver seems buggy and however i cannot connect anymore to mysql. i must check it what is wrong. I didn't receive any error when i try to connect to a DSN but nothing is printed on console (i'm using iodbctest)