10-06-2014 01:16 PM
Pretty much any database that has an odbc driver. There can be limitations to data types supported. See on line doc for details.
10-06-2014 03:41 PM
Yep your are right Reeza CesarOmarHR is mixing up a lot. All three are really different:
- The rdbms system like MySql.
- A language you can use to access a rDBMS as SQL
- a text file in some text file (.dat) you can use to configure something like a rDBMS.
10-06-2014 02:56 PM
I your question is wich RDBMS systems support ODBC. Well ODBC is an open standard they should conform to.
If at the RDBMS software supplier they are claiming to support this than that is no question. The only question is if they are conforming that correctly (no errors).
Be aware of the confusion on dedicated interfaces being supported. They are often indicated as ODBC but are dedicated versions with a lot of additional functionality. Sometimes these are not available on all platforms. For example SQL-server is having dedicated drives at Windows but you are needing to switch to ODBC at Unix.
Datatypes within each RDBMS type is another part of the puzzle. Not all datatypes are equal. The interface is doing the translations. They can be found at:
As you can see it are the SAS-formats that are related to the data-type conversions. Numerics in SAS are always floating type. This is not the same within a RDBMS assuming numeric are equal to chars just having a dedicated range more like a constraint.
10-06-2014 04:04 PM
I think Linus answer is correct, anything with an ODBC Driver.
And SQL isn't one thing, there's T-SQL or MS SQL, Oracle SQL, MySQL, NoSQL, SQLLite and I'm sure there are others.