| Oracel 11.0.6 and Sql server 2005 [message #495648] |
Mon, 21 February 2011 10:06 |
 |
markowb
Messages: 2
Registered: February 2011
|
Junior Member |
|
|
We are using OWB 11.1.0.7 64bit on Windows 2003 Server 64bit R2
We have to pull data from a SQl Server database SQL SERVER 2005 64 bit on Windows 2008 R2 64 bit
WE followed the procedures given in Oracle documentation
1. creating a ODBC DSN connection
2. creating a init ora file for that connection
3. creating a listener
We tried with both HSODBC and DG4ODBC... We can connect to SQL server through OWB...the connection is successful but I cannot import the tables into OWB. It simply hangs forever. (in the init ora file we have put the HS_FDS_SUPPORT_STATISTICS=FALSE) We have to pull data from SQL server on an ongoing basis. However we found a workaround we can create a remote link to the SQL server database by creating an entry in the tnsnames. However this connection is very slow we have to pull thousands of records on daily basis. IT takes quite some time to do this. We have tried different combinations after Goodling.
Could you shed some light on this? Is it a bug in OWB 11.1 that we cannot connect to SQL Serer or are we missing something? Will it be ok if we go for 11.2?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
