SqlDataAdapter can it be used to access oracle db?
yes it says sql, but can it be used for oracle
A:
No - at least, not directly, you can of course execute SQL Server queries (SqlDataAdapter is SQL Server specific) that access data from Oracle, but you'll need a SQL Server involved. Check out Oracle and ADO.Net on MSDN instead.
Will A
2010-08-22 13:42:05
what do u mean by sql server involved? some thing like linked servers??
2010-08-22 13:45:17
Indeed - exactly, although I'm not suggesting that you do this. If you want to connect to an Oracle database directly then SqlDataAdapter and the other SqlClient classes are _not_ the way to do it.
Will A
2010-08-22 13:53:20
+2
A:
Microsoft has depricated its own Oracle drivers. Use Oracle's drivers instead. They will perform better than OleDB or ODBC drivers.
Cylon Cat
2010-08-22 14:16:20