Click Here
home features news forums classifieds faqs links search
6071 members 
Amiga Q&A /  Free for All /  Emulation /  Gaming / (Latest Posts)
Login

Nickname

Password

Lost Password?

Don't have an account yet?
Register now!

Support Amigaworld.net
Your support is needed and is appreciated as Amigaworld.net is primarily dependent upon the support of its users.
Donate

Menu
Main sections
» Home
» Features
» News
» Forums
» Classifieds
» Links
» Downloads
Extras
» OS4 Zone
» IRC Network
» AmigaWorld Radio
» Newsfeed
» Top Members
» Amiga Dealers
Information
» About Us
» FAQs
» Advertise
» Polls
» Terms of Service
» Search

IRC Channel
Server: irc.amigaworld.net
Ports: 1024,5555, 6665-6669
SSL port: 6697
Channel: #Amigaworld
Channel Policy and Guidelines

Who's Online
24 crawler(s) on-line.
 129 guest(s) on-line.
 1 member(s) on-line.


 yoodoo2

You are an anonymous user.
Register Now!
 yoodoo2:  4 mins ago
 zipper:  6 mins ago
 vox:  6 mins ago
 eliyahu:  14 mins ago
 mordock:  22 mins ago
 K-L:  24 mins ago
 pixie:  39 mins ago
 matthey:  54 mins ago
 kriz:  56 mins ago
 kolla:  1 hr 12 mins ago

Software News   Software News : iODBC - Independent Open DataBase Connectivity for AmigaOS4
   posted by afxgroup on 11-Feb-2010 15:45:16 (9484 reads)


iODBC for AmigaOS4 Package is available to download.

What is ODBC?

ODBC is the acronym for Open DataBase Connectivity, a Microsoft Universal Data Access standard that started life as the Windows implementation of the X/Open SQL Call Level Interface specification. Since its inception in 1992 it has rapidly become the industry standard interface for developing database independent applications. Is is also the emerging standard interface for SQL based database engines replacing many of the first generation Embedded SQL and proprietary call level interfaces provided by database engine and database connectivity middleware vendors alike.
What is the ODBC Value Proposition?


The ability to develop applications independent of back-end database engine.
What is iODBC?

iODBC is the acronym for Independent Open DataBase Connectivity, an Open Source platform independent implementation of both the ODBC and X/Open specifications. It is rapidly emerging as the industry standard for developing solutions that are language, platform and database independent.
What is the iODBC Value Proposition?

The ability to develop applications independent of back-end database engine, operating system, and for the most part programming language. Although ODBC and iODBC are both 'C' based Application Programming Interfaces (APIs) there are numerous cross language hooks and bridges from languages such as: C++, Java, Perl, Python, TCL etc.

iODBC has been ported to numerous platforms, including Linux (x86, Itanium, Alpha, Mips, and StrongArm), Solaris (Sparc & x86), AIX, HP-UX (PA-RISC & Itanium), Digital UNIX, Dynix, Generic UNIX 5.4, FreeBSD, MacOS 9, MacOS X, DG-UX, and OpenVMS and now on AmigaOS4.
Which drivers are supported?

Actually most of common Open Source database are supported. Drivers for MySQL, PostgreSQL and SQLite are present into the package and has been tested connecting AmigaOS4 to a Windows machine. Also SQL Server is supported. Other drivers are in working. Check the Driver page for all news about driver pages.

This version is a Beta version and contains a lot of Debug informations.
These informations are useful for me to understand if something is wrong.
If you have problems please send me a mail and i'll take a look at it.

All other informations and downloads:

http://www.amigasoft.net/pages/odbc/odbc.asp
    

STORYID: 5299
Related Links
· More about Software News
· News by afxgroup


Most read story about Software News
UBoot 2010.06.04 for Sam460ex available

Last news about Software News
Hollywood APK Compiler 4.0 released
Printer Friendly Page  Send this Story to a Friend

Goto page ( 1 | 2 | 3 )

PosterThread
afxgroup 
Re: iODBC - Indipendent Open DataBase Connectivity for Amiga
Posted on 12-Feb-2010 9:42:41
#41 ]
Super Member
Joined: 8-Mar-2004
Posts: 1968
From: Taranto, Italy

@SinanG

what is the error now?


_________________
http://www.amigasoft.net

 Status: Offline
Profile     Report this post  
SinanG 
Re: iODBC - Indipendent Open DataBase Connectivity for Amiga
Posted on 12-Feb-2010 11:32:09
#42 ]
Regular Member
Joined: 24-Dec-2004
Posts: 334
From: Unknown

@afxgroup

Same error...


_________________
AmigaOS4 Beta-Tester
----------------------------------
Amiga X5000 8GB Radeon RX 560
Amiga A1222 2GB Radeon RX 550
Sam 460 2GB RadeonRX 550

 Status: Offline
Profile     Report this post  
Mark 
Re: iODBC - Indipendent Open DataBase Connectivity for Amiga
Posted on 12-Feb-2010 11:43:03
#43 ]
Team Member
Joined: 12-Mar-2003
Posts: 1457
From: UK

Actually, given the nature of MDB and SQLite, for those two ONLY yes you should be able to (or would in the case of MDB if the MS access driver were working) read them from files stored on AOS4 as these two have no engine/server actually running. For MSSQL yes you'd need a Windows server running SQL server.

For MySQL though, ( believe there's a AOS3.x version of mysql, you should be able to connect to that....

Mark


_________________
IceStar Media Ltd.

 Status: Offline
Profile     Report this post  
afxgroup 
Re: iODBC - Indipendent Open DataBase Connectivity for Amiga
Posted on 12-Feb-2010 12:15:05
#44 ]
Super Member
Joined: 8-Mar-2004
Posts: 1968
From: Taranto, Italy

the program needs two libs:

libiodbc.so and libiodbcinst.so

copy only those two libs in SYS:SObjs and the program should start

otherwise you can copy those two libs also in the SQL Manager program, but it is better that you have the libs in the SObjs: dir


_________________
http://www.amigasoft.net

 Status: Offline
Profile     Report this post  
-Sam- 
Re: iODBC - Independent Open DataBase Connectivity for Amiga
Posted on 12-Feb-2010 12:30:50
#45 ]
Elite Member
Joined: 18-Apr-2003
Posts: 3040
From: Yorkshire Dales, United Knigdom

Wow. Get this up to speed and all Amiga-efficient and I mught even be able to develop on the Amiga for work!


_________________
Sam

 Status: Offline
Profile     Report this post  
VooDoo 
Re: iODBC - Indipendent Open DataBase Connectivity for Amiga
Posted on 12-Feb-2010 14:06:12
#46 ]
Super Member
Joined: 16-Jun-2003
Posts: 1503
From: Croatia

I try this and Yes is working..Thanx again!


_________________
--

Amiga x5000 ı o2o ı 4GB RAM ı RadeonRX580 | SBlaster Audigy Fx - AmigaOS4.1 FInal Edition

A1200 sandwich :)

Croatian Amiga portal

 Status: Offline
Profile     Report this post  
Templario 
Re: iODBC - Independent Open DataBase Connectivity for Amiga
Posted on 12-Feb-2010 14:31:55
#47 ]
Elite Member
Joined: 22-Jun-2004
Posts: 3670
From: Unknown

Good job friends!

 Status: Offline
Profile     Report this post  
freeaks 
Re: iODBC - Independent Open DataBase Connectivity for Amiga
Posted on 12-Feb-2010 14:52:10
#48 ]
Regular Member
Joined: 2-Jan-2010
Posts: 225
From: Unknown

comment deleted

Last edited by freeaks on 12-Feb-2010 at 03:06 PM.

 Status: Offline
Profile     Report this post  
freeaks 
Re: iODBC - Independent Open DataBase Connectivity for Amiga
Posted on 12-Feb-2010 15:03:31
#49 ]
Regular Member
Joined: 2-Jan-2010
Posts: 225
From: Unknown

comment deleted

Last edited by freeaks on 12-Feb-2010 at 03:05 PM.

 Status: Offline
Profile     Report this post  
Lou 
Re: iODBC - Independent Open DataBase Connectivity for Amiga
Posted on 12-Feb-2010 15:21:36
#50 ]
Elite Member
Joined: 2-Nov-2004
Posts: 4228
From: Rhode Island

Quote:
Poster: thinkchip Date: 11-Feb-2010 23:41:36

This is great! Amiga hasn't has a good database program since superbase. This will help ween me off Microsoft Access, which is way too expensive for home use.


Uh with ODBC, you can connect to your Access db on a Windows machine and manipulate the data on the Amiga.

 Status: Offline
Profile     Report this post  
abalaban 
Re: iODBC - Independent Open DataBase Connectivity for Amiga
Posted on 12-Feb-2010 15:46:41
#51 ]
Super Member
Joined: 1-Oct-2004
Posts: 1114
From: France

@thinkchip

If you need a database for personnal/home usage you can try MUIbase it *currently* supports AmigaOS 68k, AmigaOS 4.x, MorphOS, AROS, Linux, Windows (and IIRC a MacOS version is in the work). The beauty is that this program is *free*, under GPL and actively developped by its author (which is so rare for a GPLed software that it worth mentioning)

@afxgroup

Thank you for this software this is the first step to bring back serious development into AmigaOS.


_________________
AOS 4.1 : I dream it, Hyperion did it !
Now dreaming AOS 4.2...
Thank you to all devs involved for this great job !

 Status: Offline
Profile     Report this post  
SinanG 
Re: iODBC - Indipendent Open DataBase Connectivity for Amiga
Posted on 12-Feb-2010 20:40:46
#52 ]
Regular Member
Joined: 24-Dec-2004
Posts: 334
From: Unknown

@afxgroup

thanks...Tried copying 2 libs again to SObjs: now SQL Manager is working :)

Will you release some documentation about how to connect to .mdb databases ?


_________________
AmigaOS4 Beta-Tester
----------------------------------
Amiga X5000 8GB Radeon RX 560
Amiga A1222 2GB Radeon RX 550
Sam 460 2GB RadeonRX 550

 Status: Offline
Profile     Report this post  
pjhutch 
Re: iODBC - Independent Open DataBase Connectivity for Amiga
Posted on 12-Feb-2010 23:30:19
#53 ]
Regular Member
Joined: 13-May-2003
Posts: 194
From: W Yorkshire, UK

For access to databases you also need drivers such as FreeTDS which has source available from http://www.freetds.org/ for access to MS SQL and Sybase. A standard GCC compiler should be able to compile it.


_________________
Peter J Hutchison
http://www.pjhutchison.org/

 Status: Offline
Profile     Report this post  
afxgroup 
Re: iODBC - Independent Open DataBase Connectivity for Amiga
Posted on 13-Feb-2010 8:27:58
#54 ]
Super Member
Joined: 8-Mar-2004
Posts: 1968
From: Taranto, Italy

the MDB driver is included in the package but i didn't succeded to connect to an mdb.. i've spent no great time with it but i'll take a look. but i think you should use sqlite instead mdb. is really faster and since you don't have on OS4 an "Access" replacement, the mdb format is really useless for your programs.

BTW.
i will release the iodbc SDK so everyone can use databases in their programs


_________________
http://www.amigasoft.net

 Status: Offline
Profile     Report this post  
Yssing 
Re: iODBC - Indipendent Open DataBase Connectivity for Amiga
Posted on 13-Feb-2010 9:04:36
#55 ]
Super Member
Joined: 24-Apr-2003
Posts: 1102
From: Unknown

There is no way i h*** amiga will benefit from .NET not even windows benefits from it.

They should have stuck to basci, C/C++ and Java, no need to reinvent programming/te wheel. For the sake of just comming up with a whell that does not really adresses any ones need.


_________________

 Status: Offline
Profile     Report this post  
BigBentheAussie 
Re: iODBC - Indipendent Open DataBase Connectivity for Amiga
Posted on 14-Feb-2010 7:11:33
#56 ]
Super Member
Joined: 28-Oct-2003
Posts: 1690
From: Melbourne, Australia

@Yssing
Quote:
There is no way i h*** amiga will benefit from .NET not even windows benefits from it.

They should have stuck to basci, C/C++ and Java, no need to reinvent programming/te wheel. For the sake of just comming up with a whell that does not really adresses any ones need.


Ummmm.... where to begin? I have a lot of gripes about MS but .NET certainly is not one of them. In fact, you should wish, you had something like this available for Amiga, as it would make programming for the Amiga platform incredibly more inviting.

1. Windows does benefit incredibly from .NET. .NET is fantastic at cutting through the mess of low level rubbish which is Windows and easing development for the platform. It's development platform is second to none and used by businesses the world over.
2. .NET contains a virtual machine for languages called the Common Language Runtime, which is an AWESOME idea. It could theoretically be OS agnostic and that is what the Mono team is trying to produce and what would be a great to port to Amiga.
3. MS has always supported a multitude of languages throughout its existence. Why should anything be different now? Their library of supported languages continues to grow, either through MS or third parties. I imagine your objection is to C#, which in of itself is not .NET, but a language that compiles to byte-code running on a VM which is part of .NET.
4. MS no longer actively supports Java because for good or for evil they needed to enhance Java in a non-standard way to tie it to their proprietary products. When Sun sued, along came C#, which now is arguably technically superior to Java, and open to whatever enhancements Microsoft want to make. This is a win for MS and actually a win for developers too. .NET isn't a fit for every development problem, but is good enough for business. My only gripe is that its language enhancements come so quickly and so fast it is hard to keep up.
5. If Hyperion alters the Amiga API, can one not argue, that that too, is not needed. MS is free to do what they want with their product just as Hyperion is, and heaven forbid MS actually make something simpler to do(for a change).


_________________
Leo Nigro, CTO Commodore USA, LLC
Opinions expressed are my own and not those of C= USA.
Commodore/AMIGA "Beautiful, High-Performance, Home Computers for Creativity and Entertainment."

 Status: Offline
Profile     Report this post  

Goto page ( 1 | 2 | 3 )

[ home ][ about us ][ privacy ] [ forums ][ classifieds ] [ links ][ news archive ] [ link to us ][ user account ]
Copyright (C) 2000 - 2019 Amigaworld.net.
Amigaworld.net was originally founded by David Doyle