squirrel-sql-users

[Squirrel-sql-users] how to connect to an informix db

[Luca L. <lla...@do...>]

Hi,
I need to connect to an informix db
Can you please explain me how to do it?

host is 10.1.160.10
dbserver is ol_alchi_mass
db is alchimia
port is 1526

I do not know which information I have to enter in the drivers and alias 
windows.

Thanks
Luca

Re: [Squirrel-sql-users] how to connect to an informix db

[Rob M. <Rob...@co...>]

Luca Lazzarotti wrote:

> Hi,
> I need to connect to an informix db
> Can you please explain me how to do it?

Hi Luca,

In the "Help" section in Squirrel you should look at "How to connect to 
a database".

There is also a great tutorial here:  
http://squirrel-sql.sourceforge.net/kulvir/tutorial.html

If you still have problems after reading those, let us know.

Rob


CollabraSpace - Revolutionary Collaboration
Visit us at http://www.collabraspace.com
This message has been scanned for viruses by
ClamAV v0.83

Re: [Squirrel-sql-users] how to connect to an informix db

[Luca L. <lla...@do...>]

Hi,
I read the help and the tutorial, but still I am not able to connect to 
my DB.
I use the JDBC ODBC bridge driver (since there is no informix dirver) I 
don't know how to enter the info on the alias window
I found an old messages saying to use something similar to:
jdbc:informix-sqli://10.1.160.10:1526/alchimia:informixserver=ol_alchi_mass
but I cannot get this to work

Any idea?

thanks
Luca



Rob Manning wrote:
> Luca Lazzarotti wrote:
> 
>> Hi,
>> I need to connect to an informix db
>> Can you please explain me how to do it?
> 
> 
> Hi Luca,
> 
> In the "Help" section in Squirrel you should look at "How to connect to 
> a database".
> 
> There is also a great tutorial here:  
> http://squirrel-sql.sourceforge.net/kulvir/tutorial.html
> 
> If you still have problems after reading those, let us know.
> 
> Rob
> 
> 
> CollabraSpace - Revolutionary Collaboration
> Visit us at http://www.collabraspace.com
> This message has been scanned for viruses by
> ClamAV v0.83
> 
> 
> 
> 
> -------------------------------------------------------
> SF.Net email is sponsored by: Discover Easy Linux Migration Strategies
> from IBM. Find simple to follow Roadmaps, straightforward articles,
> informative Webcasts and more! Get everything you need to get up to
> speed, fast. http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
> 

Re: [Squirrel-sql-users] how to connect to an informix db

[Rob M. <Rob...@co...>]

Luca Lazzarotti wrote:

> Hi,
> I read the help and the tutorial, but still I am not able to connect 
> to my DB.
> I use the JDBC ODBC bridge driver (since there is no informix dirver) 
> I don't know how to enter the info on the alias window
> I found an old messages saying to use something similar to:
> jdbc:informix-sqli://10.1.160.10:1526/alchimia:informixserver=ol_alchi_mass 
>
> but I cannot get this to work
>
> Any idea?

WebLogic has a JDBC (type 4) driver for Informix (I think it's of 
DataDirect origin)
IBM - strangely enough - *sells* a JDBC driver (They own Informix now so 
they can
do whatever they want with it - just that most database vendors provide 
JDBC drivers
for free) :

http://www-306.ibm.com/software/data/informix/tools/jdbc/

I've haven't tried ODBC in years, so I doubt I'd be of much help to 
you.  As I recall,
you need to define an ODBC data source using Microsoft's ODBC 
configuration tools (I can't
even remember what they are called). Then use the Sun JDBC-ODBC bridge 
driver to
connect to the ODBC data source by whatever name you gave it.

Rob


CollabraSpace - Revolutionary Collaboration
Visit us at http://www.collabraspace.com
This message has been scanned for viruses by
ClamAV v0.83

Re: [Squirrel-sql-users] how to connect to an informix db

[Rob M. <Rob...@co...>]

Luca Lazzarotti wrote:

> Hi,
> I read the help and the tutorial, but still I am not able to connect 
> to my DB.
> I use the JDBC ODBC bridge driver (since there is no informix dirver) 
> I don't know how to enter the info on the alias window
> I found an old messages saying to use something similar to:
> jdbc:informix-sqli://10.1.160.10:1526/alchimia:informixserver=ol_alchi_mass 
>
> but I cannot get this to work
>
> Any idea?

Luca,

I found a link to download the "IBM Informix" driver here:

http://www14.software.ibm.com/webapp/download/preconfig.jsp?id=2005-07-26+16%3A37%3A17.740493R&cat=database&fam=&s=c&S_TACT=104CBW71&S_CMP=

Rob


CollabraSpace - Revolutionary Collaboration
Visit us at http://www.collabraspace.com
This message has been scanned for viruses by
ClamAV v0.83