Quote:

ODBC provides a standard interface so that applications can interact with repositories of data using industry conventions.

What ?!?!?!?!?

_________________
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

@Metalheart

Quote:

What ?!?!?!?!?

I'll have a go at explaining this. Many applications need to store data in databases. There are many different databases to choose from, such as MySQL, PostgreSQL, Sqlite, Microsoft SQL server, etc. Despite most of the servers using SQL, there are enough differences that they are not 100% compatible.

IODBC provides a method of using any type of database server with your application through one interface. Think of it this way, you write your database access code once, and it can be used with any database server for which there is an iODBC driver. Otherwise you'd have to write extra code for each database type that you want to support.

This is great for developers, as it saves them time. For users, it means that they can whatever server type they want. This may not seem important, but if you're running a business, that means having one database server for everything, instead of having to install MySQL for app x, Microsoft SQL server for app y, etc.

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.

Quote:

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

the same for me...
Bravo AFX, anyway!

_________________
A1200/020+68882 - 6 MB RAM - AmigaOS 3.0

Home Recording Audio

Ok then ! Great, I guess

So to name a few apps that might take advantage of this: Office apps, bank acount programs, office server programs, programs that link guests to diner reservations and hotel rooms or something...

No apps like wordprocessors or 'normal' databases and inet browsers then ?

Did I get it right ?

_________________
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

@metalheart
In general, the most "normal" database in all the world, it's SQL dumps from mysql for unix users/admin/server owners, and so on. All the forums (and i think that one, on amigaworld) use mySQL. Amigans.net and Os4depot.net too. All the time when i "work" i have deal with mysql and dumps from mysql. I think for now million (really 10000000) apps use SQL databases (mostly mySQL). Have suppoer of it on amigaos4 in any way are great step. It can bring someday aos4 on the "business" level.

SQL it's just a programming language, support of which have those apps which mentions before (mysql, psql, etc). When you need use REALLY BIG amount of text data, which need to handle (forum posts, milions remarks about users, thousand on anything you can imagine), then, databases is comming, ans SQL language are for it.

So, if just say how it good for user who want to watch movie and play in game: i think there is nothing for it in general. But, it's very usable for anyone who want to do normal work related to administration, catalogs stuff and such.

Databases which can be handled by SQL language are not just text files, it's tables, tables and many tables, beetwen which you can navigate interactivity, or in real time, or from any code (perl, php, does not matter which).

The conclusion: it's for real business and real work. Not for fun.

Last edited by kas1e on 11-Feb-2010 at 09:37 PM.

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

Quote:

So to name a few apps that might take advantage of this: Office apps, bank acount programs, office server programs, programs that link guests to diner reservations and hotel rooms or something... No apps like wordprocessors or 'normal' databases and inet browsers then ? Did I get it right ?

Almost. Word processors and browsers don't really need it, but I took a peek at the Google Gears code (it allows web apps that use it to work offline), and it looks like it uses Sqlite to store stuff.

As the amount of data that we deal with gets bigger and bigger, databases are going to be used more and more.

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.

afxgroup
how is things going on with the
apache server,and the gnash npni plug-in thing

@afxgroup

I have copied iODBC drawer and its contents SYS:Libs/ODBC
and tried running SQLManager

But it doesn't work with the message:
"Failed to load shared object
libodbc.so"

UPDATE:

I tried running iODBC from shell, GUI appears and it fails to load any iODBC drivers when I click "Add"

I am running OS4.1 Update1 on mA1 512MB

Last edited by SinanG on 11-Feb-2010 at 09:58 PM.

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

I feel so giiidddy!! I feeeeeeeeeeeeeel sooooooooo giiiidddy!! Oooh...ooooh...my head is swimming fast * sits down and holds his head * oh the the great pleasurable sensation! I downloaded the program and tried to open odbc.ini on AmigaSYS 4 AGA on WinUAE and it prompted a dialog box:

Please insert volume
AmigaOS4.1
in any drive

what a pleasurable sensation! What a feeling..hehe!! By the end of this year I am going to upgrade and buy AmigaOS 4.1 system.

@SinanG
Quote:

"Failed to load shared object libodbc.so"

Copy all #?.so files from the iODBC drawer into your sys:Sobjs/ dir.

@Foody
Quote:

if there is away we can have a developing tool like Visual Studio

Like CodeBench.

@afxgroup
OMG ! Wow ! Somebody "made"/ported ODBC to AOS. Great job ! And I think this is important !

Last edited by Tomppeli on 11-Feb-2010 at 11:39 PM.

_________________
Rock lobster bit me. My Workbench has always preferences. X1000 + AmigaOS4.1 FE
"Anyone can build a fast CPU. The trick is to build a fast system." -Seymour Cray

i think that only libodbc.so is needed in SObjs: drawer. The other one could remain in the SYS:Libs/ODBC drawer (i think..)
BTW try to copy every single lib the system shows to you

i need to write an installer. i think i must buy the latest version of CubicIDE since my version is the C++ edition and doesn't support the Installer script creation...

_________________
http://www.amigasoft.net

Fantastic work!

It's infrastructure porting like this which is truly important at the moment imho.

_________________
Troll - n., A disenfranchised former potential customer who remains interested enough to stay informed and express critical opinions.
opp., the vast majority who voted silently with their feet.

Does CodeBench support .NET and GUI developing tool like Visual Studio? Thanks in advance.

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.

_________________
X5000 / microA1(OS4.1 FE U2) / CodeBench / Imagine / Blender
Lightwave 2019 / Microsoft Visual C++

Awesome achievement!!! A BIG step on the right direction for our beloved platform!

THANK YOU!

Dragster

_________________
Powerbook G4 1139/MOS 3.9/OSX 10.5.8. Pegasos II 2B5 Mobo. 2 GB RAM. 400 GB x 2 GB ATA HD, USB 2.0 PCI. SoundBlaster Audigy 2ZS Gold. Quad boot: AmigaOS 4.1 FInal Edition, MorphOS 3.9 regged, Debian Lenny PPC, OpenSUSE 11.1. Rockin'

@afxgroup

I already copied all #.so libs to SObjs: but it doesn't work :(

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

Ummmm... yeah... but.... this iODBC thing is for talking to database engines running on other platforms isn't it? It's not, as far as I can see, for accessing database engines running on OS4 is it? Are there and database engines for OS4 that this iODBC thing can access? I think people are getting the impression that you're suddenly going to be able to use an MS-Access MDB file, or a SQL-Server database file, actually sitting on OS4, or is that what it does?

_________________
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."

Great! That's a very important step for Amiga development!

_________________
God created Paula so that Allister Brimble and Dave Whittaker could do music

Check my Amiga gameplays (ITA)!

@BigBentheAussie
Yes you are right, actually it's for connecting to a DB which is running
un another platform, but when we have MySQL ported to AOS4 I hope
we can use iODBC to connect to a server on AOS4.
For the MySQL port look here

@Foody
Why would we need .NET support? what will that bring our platform and why not Java?
i myself would prefer a C++ oriented framework like Qt framework.

A RAD studio is needed yes, and i hope Codebench will become that.


Oh and about the news GREAT!!!!

_________________
_________________________________________________
--Regards Muffin
--Amiga a Brave New World!