NODBC Problem when sending the data between 2 DB's

kishi_g

Hi,
I had one problem. we are using SQL Server2005 with two data bases.
I want to transfer the data from one DB to another DB. I created two DSN's for two DB's. I created Conn type as Automation " Microsoft ActiveX Data Objects 2.8 Library'.Connection " i can transfer the data from one DB to another DB.
I wrote this Code.

IF ISCLEAR(Connection) THEN
CREATE(Connection);
Connection.Open('DSN='Test','sa','password');

By using the above code i can transfer the data to coonect as SA only in navision.

Is it possible to assign multiple userids for transfering the data???


Thanks & Regards,
kishore...

kriki

[Topic moved from Navision forum to SQL General forum]