[Gambas-user] Connecting gambas with ODBC Databases

[Juan Jose Costello Levien]

Andrea,

Ok, I tested the connection with ISQL command, and worked Ok.
But, the Database Manager responds this message when I try to add the 
connection:

Cannot connect to database

ODBC does not implement this function.

It is really strange this message... seems that something is wrong with 
the driver .so or S.so?

Thank you for your answer.

Juan


Andrea Bortolan wrote:

> */Juan Jose Costello Levien <jcostello at ...903...>/* wrote:
>
>     Hello,
>     I want to know how to use the Gambas Database Manager with the ODBC
>     driver. What Andrea Bortolan said is that you have to complete
>     with the
>     word ODBC the type field, and in the host field you have to type
>     the dsn
>     file involved. I have the file /cnn1.dsn, I wrote it like that
>     (/cnn1.dsn) and the Database Manager complains that could not
>     connect to
>     the DSN.
>
>     Do you have a tutorial or the like for this?
>
>     Thank you
>
>     Juan
>
>
>     -------------------------------------------------------
>     SF email is sponsored by - The IT Product Guide
>     Read honest & candid reviews on hundreds of IT Products from real
>     users.
>     Discover which products truly live up to the hype. Start reading now.
>     http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
>     _______________________________________________
>     Gambas-user mailing list
>     Gambas-user at lists.sourceforge.net
>     https://lists.sourceforge.net/lists/listinfo/gambas-user
>
> Hi,
> in order to connect to a databse trought the ODBC driver you need to :
> -configure the DSN (using the ODBCConfig tool or editing the odbc.ini 
> file)
> -try the connection using the "isql" command (provided by the unixODBC 
> package) : >>isql DataSourceName userID Password, if all works you are 
> propted for SQL command, try select * from tablename.
> - If you want to try the Database example provided by Gamabs you can 
> overwrite the filed where you're asked for the database type(MySQL 
> Postgre SqlLite) with ODBC, in the hostname filed insert the DSN as 
> above and UserID & password as usual.
> It should work.
> If you need more help please let me know.
> Have a nice day.
>
> ------------------------------------------------------------------------
> *Nuovo Yahoo! Messenger* 
> <http://us.rd.yahoo.com/mail/it/taglines/*http://it.messenger.yahoo.com> 
> E' molto più divertente: Audibles, Avatar, Webcam, Giochi, Rubrica… 
> Scaricalo ora!