OpenEuphoria

ODBC question [ Matt]

• Posted by George Walters <gwalters at sc.rr.com> Dec 11, 2005
• 757 views

I've been using ODBC for some time and have run into a problem I would like
to solve. My understanding is the issue here. I have multiple customers 
running the software (all having the same database name). I had been thinking
that the 1st argument below was the data base name, but it looks like it is
the DSN, as in the windows XP Data Sources (ODBC) panel.

--Establishes a connection to a DSN.  Returns the integer id of the connection.
global function openConnectionODBC( sequence server, sequence user,
        sequence authentication )

Setting up the windows panel for the DSN's the user and password is entered
there, but it is also in this argument call which seems to not be necessary
or could be contradictory.

I'm wondering if I should be calling 

global function dataSourcesODBC( )

and getting the database (or is it the DSN) , user, and password from there

Matt could you give a small digressionl on this?