Insert data through SQL

iqbalmad

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.

kriki

The error seems clear: the server cannot be found. Maybe a problem in creating the connection string.

Check these url's for some help:
http://www.connectionstrings.com/
http://www.connectionstrings.com/?carrier=sqlserver
http://www.connectionstrings.com/?carrier=sqlserver2005
http://www.connectionstrings.com/sql-server-2008
http://www.connectionstrings.com/sql-server-2012