November 29, 2005 at 6:45 am
Hi,
I am using Linked server feature to export data from SQL Server to Oracle database. It is working for all datatype except for nvarchar.
It is throwing me :
"Server: Msg 7356, Level 16, State 1, Line 1"
Does anybody knows how to solve this issue?
I am using sp4a.
Thanks
Manju
November 29, 2005 at 9:53 am
Take a look at:
SSC.com Article: Oracle Link by Adrian Small
He worked through the errors he was receiving making a linked server connection to Oracle and that error you cite is one of them.
K. Brian Kelley
@kbriankelley
November 30, 2005 at 1:38 am
Many Thanks Brian for the reply.
I had a look at the article which you have mentioned, but none are relating to out problem.
Could you please tell me whether any character set settings are there while doing the SQL Server 2000 installation?
Thanks
Manju
November 30, 2005 at 7:07 am
Do you mean at the OS level?
K. Brian Kelley
@kbriankelley
November 30, 2005 at 11:22 pm
No. When we are doing SQL Server Installation.
In Oracle, while creating Database we can set Character set information.
Similar to this, I was searching for a feature in SQL Server.
November 30, 2005 at 11:22 pm
No. When we are doing SQL Server Installation.
In Oracle, while creating Database we can set Character set information.
Similar to this, I was searching for a feature in SQL Server.
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply