Let me clarify my posting …

I understand that I must use ODBC Datasource Administrator to make the initial connection. It is this which I would like to do programtically and on the fly.

I think you could do this with a file based dsn, where ou would update the file on the fly.

see:

http://www.minisoft.com/pages/middleware/odbc32/pages/odbc_y.htm

or, if you have OI 7.2, try using ADO recordsets, where you can build the connection string on the fly. I just posted an example

Bob

Thanks, Bob. I will try this.

View this thread on the Works forum...