the issue has been resolved

registry fix worked foe me

thank you so much ...import these registry settings to fix the problem

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client]

"SharedMemoryOn"=dword:00000001

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\ConnectTo]

"DSQUERY"="DBNETLIB"

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\DB-Lib]

"AutoAnsiToOem"="ON"

"UseIntlSettings"="ON"

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\SNI9.0]

"ProtocolsSupported"=hex(7):73,00,6d,00,00,00,74,00,63,00,70,00,00,00,6e,00,70,00,00,00,76,00,69,00,61,00,00,00,00,00

"ProtocolOrder"=hex(7):73,00,6d,00,00,00,74,00,63,00,70,00,00,00,6e,00,70,00,00,00,00,00

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\SNI9.0\GeneralFlags]

"NumberOfFlags"=dword:00000002

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\SNI9.0\GeneralFlags\Flag1]

"Label"="Force protocol encryption"

"Value"=dword:00000000

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\SNI9.0\GeneralFlags\Flag2]

"Label"="Trust Server...

Hello Dear Frens .....the unicode solution working fine with VS 2005 but when i m implementing this with VS 2003 it is having some problem

it is inserting N in...

Bingo !!!!!!!!!

Yes it is Working and Working Fine with No Errors !!

Thank You So much ...But still I have a confusion in my mind that whether we are working 100%...

I did that but still it is saved in the database as a ??????....

Can you Please tell me Where to use that "N" ...I m putting that into when executing...