Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kflee2000
Starting Member
14 Posts |
 Posted - 2012-04-10 : 03:52:55
|
I'm trying to use import/export to import data from oracle to sql2008, however I couldn't find the microsoft OLE DB provider for ODBC in the List.I have installed the Oracle odbc driver and could see it and sucessfully tested connection using obdc by creating a data source.Anyone know why the data source it's not appear in the sql2008 native driver which this can be done in sql2000.Thanks Note: I have to a test using test file test.udl it could shown the odbc, however not in import/export wizard. |
|
|
|
|
|
Import/Exoprt using odbc driver