Forum

Call a stored procedured in SQL

Anh Bui	#1 Mar 02, 2020 06:18 AM
Just came Points:: 0 Joined:: Apr 10, 2017	Hello 1C, I have some troubles with calling a stored procedure in SQL from 1C. I've followed this topic https://1c-dn.com/forum/forum5/topic1790/?sphrase_id=134114#message11634. My connection is totally fine but the system could not find the Stored Procedure in SQL and I'm sure that name of SP is exactly. The name of Stored Procedure is SelectAll without parameters.
	Profile

Aleksandr Biryukov	#2 Mar 02, 2020 11:57 AM
Administrator Points:: 0 Joined:: Oct 3, 2019	Hi Anh Bui! Do you use MS SQL in your work? If you call a stored procedure in the SQL console - does it work? Aleksandr
	Profile

Anh Bui	#3 Mar 02, 2020 03:10 PM
Just came Points:: 0 Joined:: Apr 10, 2017	Hi Aleksandr, I ran "EXEC SelectAll" in SQL and it works.
	Profile

Aleksandr Biryukov	#4 Mar 02, 2020 05:06 PM
Administrator Points:: 0 Joined:: Oct 3, 2019	Please show me your 1C code...
	Profile

Anh Bui

Mar 02, 2020 05:25 PM

Just came

Points:: 0
Joined:: Apr 10, 2017

Here is my code

Code

ConnectionParameters = ExternalDataSources.StoreProcedured.GetCommonConnectionParameters();
   ConnectionParameters.ConnectionString = "DRIVER={SQL Server};SERVER=SRV-TR-KYTHU\SQL2014;";
   ConnectionParameters.DBMS = "SyncNano2Tr";
   ConnectionParameters.UserName = "sa";
   ConnectionParameters.Password = "sql2014@";
   ConnectionParameters.StandardAuthentication = True;
   
   ExternalDataSources.StoreProcedured.SetCommonConnectionParameters(ConnectionParameters);
   ExternalDataSources.StoreProcedured.Connect();
      
   ExternalDataSources.StoreProcedured.dbo_SelectAll();

And the link to SP

Profile

Aleksandr Biryukov

Mar 03, 2020 01:27 PM

Administrator

Points:: 0
Joined:: Oct 3, 2019

Hi Anh Bui!

Your "ConnectionString" should look like this:

Code
ConnectionParameters.ConnectionString = "DRIVER={SQL Server};SERVER=SRV-TR-KYTHU\SQL2014;DATABASE=SyncNano2Tr";

That is, you should add the name of your database to it: "DATABASE=SyncNano2Tr".

Please try this code.

Aleksandr

Profile

Anh Bui	#7 Mar 03, 2020 02:58 PM
Just came Points:: 0 Joined:: Apr 10, 2017	Thank you so much Aleksandr, I got it. Have a nice day!
	Profile