You can use the Microsoft SQL Server Management Studio to connect your Oracle data to an SQL Server instance. NET Framework 4.5 must be installed on the computer.Ĭonnecting to Oracle from SQL Server Management Studio using ODBC Driver for Oracle ODBC Driver for Oracle and SQL Server must be installed on the same computer.Otherwise, configure the driver using the 32-bit version of ODBC Administrator - launch it from %windir%\SysWOW64\odbcad32.exe. For example, if you are using 64-bit SQL Server Management Studio on 64-bit Windows platform, then configure the 64-bit version of the driver using ODBC Administrator launched from %windir%\system32\odbcad32.exe. The driver, studio, and SQL Server must be of the same bitness.Refer to the Driver Configuration article to learn how to configure a System DSN The data source must be a configured system DSN.In order to avoid incorrect integration with MS SSMS, the working environment must meet the following conditions:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |