How to get data from OracleDatabase to SQL Server automaticly
-
Hi all. I Have a SQL server 2008 DB.I also have some Oracle Database.Now I Want to get data from Oracle DB to SQL server DB. I also read some post about link server but I still not success connecting to Oracle DB. For example some information about oracle DB that I can connect by using SQL developer IP:10.149.35.132 Username:abc pass:bcd. Instance:bms
-
Instead of posting your connection information try letting us know how you tried to connect and what went wrong
-
Thanks for your reply. I Have try some action to add linked server to Oracle DB but I failed.If anybody have done please help me. Chat with me and i will give you Teamviewer ID to see. Thanks.
THe error here The linked server has been created but failed a connection test. Do you want to keep the linked server? ------------------------------ ADDITIONAL INFORMATION: An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) ------------------------------ SQL Server Network Interfaces: Connection string is not valid [87]. OLE DB provider "SQLNCLI10" for linked server "BIM" returned message "Login timeout expired". OLE DB provider "SQLNCLI10" for linked server "BIM" returned message "A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.". (Microsoft SQL Server, Error: 87) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.1617&EvtSrc=MSSQLServer&EvtID=87&LinkId=20476
-
THe error here The linked server has been created but failed a connection test. Do you want to keep the linked server? ------------------------------ ADDITIONAL INFORMATION: An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) ------------------------------ SQL Server Network Interfaces: Connection string is not valid [87]. OLE DB provider "SQLNCLI10" for linked server "BIM" returned message "Login timeout expired". OLE DB provider "SQLNCLI10" for linked server "BIM" returned message "A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.". (Microsoft SQL Server, Error: 87) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.1617&EvtSrc=MSSQLServer&EvtID=87&LinkId=20476
-
I can connect to Oracle now.The first Oracle DB is OK, but now I want to connect to two or more oracle at the same time. The second ORalce is fail.
As I implied earlier, we can't help if we don't know what you are doing. If the 2nd linked server connection failed with the same error, then you are supplying the wrong credentials. Have a read of this and see if it helps How to setup linked servers for SQL Server and Oracle 64 bit client[^]
-
As I implied earlier, we can't help if we don't know what you are doing. If the 2nd linked server connection failed with the same error, then you are supplying the wrong credentials. Have a read of this and see if it helps How to setup linked servers for SQL Server and Oracle 64 bit client[^]
-
As I implied earlier, we can't help if we don't know what you are doing. If the 2nd linked server connection failed with the same error, then you are supplying the wrong credentials. Have a read of this and see if it helps How to setup linked servers for SQL Server and Oracle 64 bit client[^]
The tnsnames.ora is here PMCalculate = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.138)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = NMS) ) ) BIM = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.12)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = nms) ) ) BIM is OK, PMCalculate is fail Do I need to restart something each time I add a DB to tnsnames.ora
-
The tnsnames.ora is here PMCalculate = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.138)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = NMS) ) ) BIM = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.12)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = nms) ) ) BIM is OK, PMCalculate is fail Do I need to restart something each time I add a DB to tnsnames.ora
I didn't think you had to do a restart each time, but it might be worth trying. But first, if you take BIM out of the .ORA does PMCalculate still fail? I notice SERVICE_NAME is in capitals for PMCalculate but lower-case for BIM ... is there a case-sensitivity issue here? Are you sure that the Oracle Server on Host 192.168.2.138 is listening on the default port (1521)? (Reference in case you need to check ... Managing Oracle Database Port Numbers[^]) Beyond that I'm running out of ideas, sorry.
-
I didn't think you had to do a restart each time, but it might be worth trying. But first, if you take BIM out of the .ORA does PMCalculate still fail? I notice SERVICE_NAME is in capitals for PMCalculate but lower-case for BIM ... is there a case-sensitivity issue here? Are you sure that the Oracle Server on Host 192.168.2.138 is listening on the default port (1521)? (Reference in case you need to check ... Managing Oracle Database Port Numbers[^]) Beyond that I'm running out of ideas, sorry.
