Click Here
home features news forums classifieds faqs links search
5808 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
61 crawler(s) on-line.
 14 guest(s) on-line.
 0 member(s) on-line.



You are an anonymous user.
Register Now!
 Trixie:  12 mins ago
 mobileconnect2:  35 mins ago
 Rob:  44 mins ago
 zipper:  46 mins ago
 SOFISTISOFTWARE:  1 hr 3 mins ago
 dirkzwager:  1 hr 10 mins ago
 matthey:  1 hr 12 mins ago
 DiscreetFX:  1 hr 13 mins ago
 Hypex:  1 hr 16 mins ago
 Skateman:  1 hr 25 mins ago

Software News   Software News : iODBC - Independent Open DataBase Connectivity for AmigaOS4
   posted by afxgroup on 11-Feb-2010 15:45:16 (7646 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
    

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
Goadf! 3.0 has been released
Printer Friendly Page  Send this Story to a Friend

Goto page ( 1 | 2 | 3 )

PosterThread
kas1e 
Re: iODBC - Indipendent Open DataBase Connectivity for Amiga
Posted on 11-Feb-2010 16:04:47
#1 ]
Amiga Developer Team
Joined: 11-Jan-2004
Posts: 3425
From: Russia

That what we can call good software ! Thanks a lot, will test it today.


_________________
Join us to improve dopus5!
zerohero's mirror of os4/os3 crosscompiler suites

 Status: Offline
Profile     Report this post  
Lou 
Re: iODBC - Indipendent Open DataBase Connectivity for Amiga
Posted on 11-Feb-2010 16:06:40
#2 ]
Elite Member
Joined: 2-Nov-2004
Posts: 4043
From: Rhode Island

This is an epic achievement and will now make it possible to put Amigas in the business place as client workstations.

 Status: Offline
Profile     Report this post  
TheDaddy 
Re: iODBC - Indipendent Open DataBase Connectivity for Amiga
Posted on 11-Feb-2010 16:16:05
#3 ]
Elite Member
Joined: 30-Sep-2005
Posts: 4499
From: Quattro Stelle

Great news!


_________________
www.loriano.pwp.blueyonder.co.uk

 Status: Offline
Profile     Report this post  
Allanon 
Re: iODBC - Indipendent Open DataBase Connectivity for Amiga
Posted on 11-Feb-2010 16:48:26
#4 ]
Regular Member
Joined: 28-Jan-2009
Posts: 136
From: Unknown

OMG! This is a milestone for the AmigaOS world

Thank you for your work!!!


_________________
-----
[Allanon] Fabio Falcucci
AMC Website // Docs Site // Support Forum // => Patreon <=

 Status: Offline
Profile     Report this post  
Yssing 
Re: iODBC - Indipendent Open DataBase Connectivity for Amiga
Posted on 11-Feb-2010 16:56:14
#5 ]
Super Member
Joined: 24-Apr-2003
Posts: 1022
From: Unknown

Excatly what we need.. :)

I can really use this, for my Amiga Gate Controller project


_________________

 Status: Offline
Profile     Report this post  
VooDoo 
Re: iODBC - Indipendent Open DataBase Connectivity for Amiga
Posted on 11-Feb-2010 17:01:55
#6 ]
Super Member
Joined: 16-Jun-2003
Posts: 1495
From: Croatia

Great MAn..from you all sw is very quality!! Thanx!!


_________________
--
A1200 sandwich :)

uA1c/g3-800 mHz/512mb/160gb hdd/OS4.1 Final + upd #1

MacMini G4 1.5ghz 1GB ram + MorphOS 3.9

Croatian Amiga portal

 Status: Offline
Profile     Report this post  
afxgroup 
Re: iODBC - Indipendent Open DataBase Connectivity for Amiga
Posted on 11-Feb-2010 17:04:24
#7 ]
Super Member
Joined: 8-Mar-2004
Posts: 1966
From: Taranto, Italy

just some things...

1) Unpack iODBC package somewhere and copy its content into:

SYS:Libs/ODBC

2) i'm writing a manual and (maybe also) and installer but actually i want to remove all problems first
3) the sql manager can be used from any location in your hard disk
4) refer to the iODBC web site for all useful informations

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


_________________
http://www.amigasoft.net

 Status: Offline
Profile     Report this post  
Hondo 
Re: iODBC - Indipendent Open DataBase Connectivity for Amiga
Posted on 11-Feb-2010 17:25:51
#8 ]
Super Member
Joined: 10-Apr-2003
Posts: 1355
From: Denmark

Nice work man.......this is really really GREAT!!!


_________________
On Planet Boing Trevor is God

 Status: Offline
Profile     Report this post  
klx300r 
Re: iODBC - Independent Open DataBase Connectivity for Amiga
Posted on 11-Feb-2010 17:47:09
#9 ]
Elite Member
Joined: 4-Mar-2008
Posts: 3559
From: Toronto, Canada

wow!! thanks..can I use this to create a small database of info on a small web page ?


_________________
____________________________
c64-2sids, A1000, A1200T-060@50(finally working!),A4000-CSMKIII
! My Master Miggies- Amiga 1000 & AmigaOne X1000 !
mancave-ramblings
X1000 I BELIEVE

 Status: Offline
Profile     Report this post  
DAX 
Re: iODBC - Indipendent Open DataBase Connectivity for Amiga
Posted on 11-Feb-2010 18:21:15
#10 ]
Elite Member
Joined: 30-Sep-2009
Posts: 2790
From: Italy

Congratulations for yet another very important project!

Last edited by DAX on 11-Feb-2010 at 06:23 PM.


_________________
SamFlex Complete 800Mhz System + AmigaOS 4.1 Update 4
Amiga 2000 DKB 2MB ChipRam GVP G-Force040 Picasso 2 OS3.9 BB2
AmigaCD 32

 Status: Offline
Profile     Report this post  
samo79 
Re: iODBC - Indipendent Open DataBase Connectivity for Amiga
Posted on 11-Feb-2010 18:45:09
#11 ]
Elite Member
Joined: 13-Feb-2003
Posts: 3409
From: Italy, Perugia

@afxgroup

BRAVO !


_________________
BACK FOR THE FUTURE

http://www.betatesting.it/backforthefuture

Sam440ep Flex 800 Mhz 1 GB Ram + AmigaOS 4.1 Update 6
AmigaOne XE G3 800 Mhz - 640 MB Ram - Radeon 9200 SE + AmigaOS 4.1 Update 6

 Status: Offline
Profile     Report this post  
saimo 
Re: iODBC - Independent Open DataBase Connectivity for Amiga
Posted on 11-Feb-2010 18:52:10
#12 ]
Elite Member
Joined: 11-Mar-2003
Posts: 2307
From: Unknown


 Status: Offline
Profile     Report this post  
Kicko 
Re: iODBC - Independent Open DataBase Connectivity for Amiga
Posted on 11-Feb-2010 19:01:53
#13 ]
Elite Member
Joined: 19-Jun-2004
Posts: 5009
From: Sweden

Not my area but i see many are happy so im happy :)
Everything that makes the amiga interesting for more people

 Status: Offline
Profile     Report this post  
DiskDoctor 
Re: iODBC - Independent Open DataBase Connectivity for Amiga
Posted on 11-Feb-2010 19:11:01
#14 ]
Cult Member
Joined: 3-Feb-2009
Posts: 563
From: Rzeszow, Poland

Anybody knows anything about Python API to it?


_________________

 Status: Offline
Profile     Report this post  
cha05e90 
Re: iODBC - Independent Open DataBase Connectivity for Amiga
Posted on 11-Feb-2010 19:30:18
#15 ]
Super Member
Joined: 18-Apr-2009
Posts: 1273
From: Germany

@DiskDoctor

Yep, that would be nice - a python module or an ARexx library (i.e. porting the RexxSQL lib for Regina...).


_________________
X1000|II/G4|440ep|2000/060|2000/040|1000

 Status: Offline
Profile     Report this post  
Metalheart 
Re: iODBC - Indipendent Open DataBase Connectivity for Amiga
Posted on 11-Feb-2010 19:34:00
#16 ]
Elite Member
Joined: 21-Aug-2003
Posts: 2968
From: Somewhere in the Dutch mountains....

I feel stupid, but what exactly does it do ? And what kind of programs use this ?

Sorry for being so ignorant


_________________
Theres a time to live and a time to die
When its time to meet the maker
Theres a time to live but isnt it strange
That as soon as you're born you're dying

 Status: Offline
Profile     Report this post  
ikir 
Re: iODBC - Independent Open DataBase Connectivity for Amiga
Posted on 11-Feb-2010 19:47:24
#17 ]
Elite Member
Joined: 18-Dec-2002
Posts: 5646
From: Italy

Bravo!


_________________
Amiga News.it
Sam460ex 1,15Ghz
2GB RAM, 120GB Crucial v4 SSD, 32GB SDHC
Radeon HD 6450 1GB

 Status: Offline
Profile     Report this post  
ne_one 
Re: iODBC - Indipendent Open DataBase Connectivity for Amiga
Posted on 11-Feb-2010 19:58:10
#18 ]
Cult Member
Joined: 13-Jun-2005
Posts: 885
From: Unknown

Quote:
I feel stupid, but what exactly does it do ? And what kind of programs use this ?


ODBC provides a standard interface so that applications can interact with repositories of data using industry conventions. Prior to ODBC, drivers would be proprietary and calling conventions would be specific to each database.

Applications that use ODBC cover a wide spectrum -- anything that stores to or retrieves data from a repository. That covers a lot of territory. :)

 Status: Offline
Profile     Report this post  
Hans 
Re: iODBC - Independent Open DataBase Connectivity for Amiga
Posted on 11-Feb-2010 20:17:05
#19 ]
Elite Member
Joined: 27-Dec-2003
Posts: 4927
From: New Zealand

@afxgroup

Congratulations on finishing this. I don't have an immediate use for it right now, but it's only going to be a matter of time before I write something that needs a database.

In your opinion, is it worth using iODBC for something that 99% of people are only going to need sqlite for? One major factor would be that, with Sqlite, you can automatically create a new database without having to ask the user what type, where the server is, etc. Is that possible with iODBC? Basically, I'd like to know if you could use this for programs of any size, or if it's more suitable for programs that require heavy duty database servers.

Hans


_________________
http://hdrlab.org.nz/ - Amiga OS 4 projects, programming articles and more. Home of the RadeonHD driver for Amiga OS 4.x project.
https://keasigmadelta.com/ - More of my work.

 Status: Offline
Profile     Report this post  
Foody 
Re: iODBC - Independent Open DataBase Connectivity for Amiga
Posted on 11-Feb-2010 20:24:11
#20 ]
Super Member
Joined: 3-Sep-2003
Posts: 1467
From: Canada

If AmigaOS 4.1 becomes a more serious OS like Windows, Linux or Mac before I die, I am going to make it officially one hundred percent AmigaOS 4.1 as my only OS till the day I day and will be only using it 100% as my main PC for all daily life. We need A GOOD DEVELOPING tool like Visual Studio with .NET technology support, if there is away we can have a developing tool like Visual Studio or at least supports .NET technology with similarity like Visual Studio, a browser that is as equally functioning as a PC browser, more of these DATABASE programs ported to AmigaOS, etc, etc, etc....I will migrate permanently to AmigaOS 4.1 until I become completely senile, and need someone to change my urine pocket! That is a promise for myself. So keep it up guys, this iODBC have brought a big smile to my face and I see AmigaOS 4.1 in a whole new face...please...more....I BEG YOU MORE!

 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