[Gambas-user] DB compatible to SQL Server 2000

[Hans-Martin Bundeshund]

Salute,

I read this thread with my eyes wide open. I don't know, if I understand 
right, but there is an odbc-driver for IBM's DB2 for Linux. Does this means, 
that it is _maby_ possible to use gambas with the iSeries when gambas (maybe) 
can offer odbc support?? 



I don't know other mainframe-machines, but guess that there are some 
odbc-drivers for linux supporting this machines. This could be a great step 
for gambas. 

In a yhaoo-group there is a group called 'Forum 400', a german user-group 
arround programming and adminstrating the AS400/iSeries. In the past we had 
serveral discussions about that:

The big problem IBM for example has, is the green-screen. The users want  to 
have graphical enviroment but IBM waited too long. There first solution was 
Java. But all the AS400 people don't know Java, or even object-relevating 
programming. Some learned, the most don't. 
 
The next step ftom IBM was a 'converter', written in Java and is able to 
generate 'on-the-fly' a GUI under Windows from the green-screen-look. It is 
not such good solution IMHO. It doesn't offers all the objects that windows 
can offer (Combobox, Listbox, ...), only the green-screen ones.

Then VRPG was presented by IBM. It is a Visual-RPG with a (terrible) IDE a bit 
comparing to gambas, but gambas is much, much more better to use. 
And the most users don't use this, because it is too complicated to use. You 
must think of that: The most programmers on iSeries are not that young. The 
most have 10-155 years to work and then go to their retirment...(I allwas 
this this, when I am at a training for iSeries and when I look at the 
profiles at the yahoo-group)

So there is no 'easy-to-use' tool to generate applications using the DB2 on 
the iSeries running under Linux, only one bad (and expansive) IDE for 
Windows. 

Just my thoughts... (writing this without knowing, how much work it is, to 
write such an odbc-support for gambas)


HM


Am Montag, 30. August 2004 11:01 schrieb Benoit Minisini:
> On Monday 30 August 2004 10:45, ron wrote:
> > On Monday 30 August 2004 10:05, Benoit Minisini wrote:
> > > On Monday 30 August 2004 03:54, Iwan Prasetyo wrote:
> > > > Dear milis,
> > > >
> > > > Could it be possible if I request for DB compatible for SQL Server
> > > > 2000? It would be easier and painless to develop app using gambas in
> > > > transition time from Windows to Linux.
> > > >
> > > > (cos I can't connect my VB app to postgreSQL)
> > > >
> > > > Thx in advance and sorry if OOT:)
> > > >
> > > > Regards,
> > > >
> > > > Iwan Prasetyo
> > > > ----------------------
> > >
> > > I think the simpler way to connect ODBC databases is what Edward Hsu
> > > suggested a few days ago: http://odbtp.sourceforge.net
> > >
> > > The only problem with ODBC and this library is finding good
> > > documentation about ODBC catalog requests, which allows me reading
> > > database metadata (tables, fields, indexes). The Gambas database driver
> > > needs that!
> > >
> > > Regards,
> >
> > May be you can use the AdoDB in PHP as a example to
> > get support for all kinds of DB's.
> > After all it is doing the same as we need in gambas for php.
> >
> > Even more interesting a interface to the AdoDB class
> > That way you do not have to write new support for the
> > different db's but only on one interface, the gb.AdoDB.
>
> How could you use a PHP module in Gambas ???
>
> > I got several years back the ODBC developres kit.
> > Didn't see it now for long time.
> > It contains a quicktest program using mutch of the
> > sql commands. Source in C to build and execute them
> > to test the ODBC function of the driver works.
>
> The more difficult is not getting the result of a query, it is getting
> metadata information (named catalog queries in ODBC).
>
> If I made my own cooking with the gambas database component, it was for two
> reasons: Gambas datatype support was needed for the ease of programming,
> and, above all, all database interfaces I saw didn't please me.
>
> I find the odbtp approach a very good idea :-)
>
> Regards,