[Gambas-user] Connecting gambas with ODBC Databases

[Andrea Bortolan]

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 E' molto più divertente: Audibles, Avatar, Webcam, Giochi, Rubrica
 Scaricalo ora! 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.gambas-basic.org/pipermail/user/attachments/20050313/29f11f79/attachment.html>