Odbc

When connecting to a database in code using the ODBC popup to specify a data source, I am encountering a problem when the source table has field names with spaces in them. For SQL Server, these fields need square brackets around them but for other data sources ( Oracle etc ) a different delimiter is needed. Is there anyway of knowing what the delimiter should be for any selected data source?


Cheers
Cenobite

The only way to know what the delimiter is (that I know of anyway) would be to check the individual Db documentation.

What I mean is, that in the code when the user has selected a data source ( eg SQL Server, Oracle ), I need a generic way to find out in the code at run time what the delimiter would be.


Cen