Is there any utlity that I could use to run SQL and see the schema on
an IDS11.50 from windows 7 64 bit version either free or for little
money.

dbaccess is not good enough to see results

I have had xp so far and used Winsql which is relatively cheap but
it's not working anymore with the 64 bit ODBC driver and AGS Server
Studio is a bit expensive for me.

Any suggestion please?

Thank you,

Try this product ....

http://www.dbvis.com/products/dbvis/doc/supports.jsp



-----Original Message-----
From: informix-list-bounces (AT) iiug (DOT) org [mailto:informix-list-bounces (AT) iiug (DOT) org] On Behalf Of Gentian Hila
Sent: Thursday, December 02, 2010 10:53 AM
To: IIUG Informix List
Subject: Windows 7 64 bit SQL and Schema viewer for IDS 11.50

Is there any utlity that I could use to run SQL and see the schema on
an IDS11.50 from windows 7 64 bit version either free or for little
money.

dbaccess is not good enough to see results

I have had xp so far and used Winsql which is relatively cheap but
it's not working anymore with the 64 bit ODBC driver and AGS Server
Studio is a bit expensive for me.

Any suggestion please?

Thank you,
_______________________________________________
Informix-list mailing list
Informix-list (AT) iiug (DOT) org
http://www.iiug.org/mailman/listinfo/informix-list

I will try these tools that you are suggesting. It seems that OAT is a hit
out there.

Thank you very much!

On Thu, Dec 2, 2010 at 11:59 AM, Mirav Kapadia <mirav (AT) us (DOT) ibm.com> wrote:

Hello.
You could install OAT - OpenAdmin tool, it´s free, it´s on a web
front-end, and does much more than you said you need!
Try it.... http://www.openadmintool.org/

Best regards.

Em 02/12/2010 12:52, Gentian Hila escreveu:

--

Alexandre Marini

Tecnologia da Informação - DBA

msn: alexandre_marini (AT) hotmail (DOT) com

SEFAZ-MS / SGI-UGSR / Sistemas IBM-Informix

Cert-Info-Mgmt_color <Cert-Info-Mgmt_color.jpg>

IBM Informix Dynamic Server Certified Professional V10 / V11

I will try that too. Actually I am having a tough time to get OAT installed
in 64 bit.




On Thu, Dec 2, 2010 at 1:22 PM, Plugge, Joe R. <JRPlugge (AT) west (DOT) com> wrote:

I quite like http://www.dbschema.com/

--
Clive

On 02/12/2010 19:23, Gentian Hila wrote:

I prefer dbvis... but if you like winsql and the only problem is
the 64 bit driver why dont you use the 32 bit odbc instead?
It works ...

Dirk

"Gentian Hila" <genti.tech (AT) gmail (DOT) com> schrieb im Newsbeitrag news:mailman.666.1291308762.1071.informix-list (AT) iiug (DOT) org...

Or this:

http://squirrel-sql.sourceforge.net

Regards,
Doug Lawry

I got Winsql, OAT and DBvis all working. Sure OAT and DBVis give you
quite a bit more.

Yes, the key was to use the 32 bit driver and 32 bit ODBC manager
instead of the 64 bit manager.

New to windows 7 64 bit!

The only benefit of Winsql is that you can update based on the results
you get and it exports to excel as well. Maybe the others do but I
haven't figured out yet.

Thank you everyone,

On Thu, Dec 2, 2010 at 6:47 PM, Doug Lawry <lawry (AT) nildram (DOT) co.uk> wrote: