Insert data through SQL

iqbalmad
Member Posts: 180
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.
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.
0
Comments
-
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-2012Regards,Alain Krikilion
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions