Hi Francisco -
I haven't actually done this myself, so I'm not sure if it's going to work or not, but I think you might be able to use SQLSETPROP() and/or SQLGETPROP().
From the help file:
Connections inherit properties in a similar fashion. Default properties for connection 0 are inherited when you create and store a named connection in a database. You can change these default property settings for connection 0 with the SQLSETPROP( ) function. After the connection has been created and is stored in a database, you can change connection properties with the DBSETPROP( ) function. When you use a connection, the property settings stored for the connection in the database are inherited by the active connection. You can change these properties on the active connection using the SQLSETPROP( ) function for the connection handle.
Does this help?
There is more in the help file under "ODBC data sources, using named views and connections"
>I want to create an ODBC DSN programaticaly.
>I can't find the proper keywords to use for these options:
>
>Disable the checkbox «Connect to SQL Server to obtain default settings ...»
>«Perform Translation for character data»
>
>I am using the ODBC Driver version 3.70.08.21
>
>Any help would be apreciated.
>
>TIA
ellen whitney
EPS Software Corp