Options

Insert data through SQL

iqbalmadiqbalmad Member Posts: 179
edited 2013-06-21 in Navision Attain
Hi everyone,

Part of the codes
//Create client on another server
SetupIntra1.RESET;
SetupIntra1.SETRANGE("Main Server",FALSE);
SetupIntra1.SETRANGE("Create Client",TRUE);
IF SetupIntra1.FINDFIRST THEN
REPEAT
ServerName := SetupIntra1."Server IP";
NavDB := SetupIntra1."Database Name";

Companytxt:=SetupIntra1."Company Name";

ConnectionString := 'Data Source='+ServerName+';'
+ 'Initial Catalog='+NavDB+';'
+ 'User ID=test;'
+ 'Password=test;'
+'Persist Security Info=False;';

SQLConnection := SQLConnection.SqlConnection(ConnectionString);
SQLConnection.Open;
SQLCommand := SQLConnection.CreateCommand();

SQLCommand.CommandText :='INSERT INTO [dbo].'+
'([No_],[Name],[Search Name],[Name 2],[Address],[Address 2],[City],[Contact],[Phone No_],[Telex No_],[Our Account No_]'+

I get this error message. My servers are already linked servers.

Any idea.

Thanks in advance.

Comments

Sign In or Register to comment.