pcsoft.us.windevCopyright 2026, PC SOFT12 Jan 2018 12:40:50 Z12 Jan 2018 12:40:50 ZHello, I have an issue to retrieve he dataset of a stored procedure in WINDEV19. The error message says that the "data source is not initialized" - Connection SLQ SERVER OLEDB: HDescribeConnection(gs_CommonDB_Connection,gs_sql_user,gs_sql_password,gs_server_name,gs_AIGCOMMONDB_Name,hOledbSQLServer,hOReadWrite) I looked on all forums and tried various samples without success. Can someone help ? Many thanks in advance. WINDEV code: gs_SQLstring = [ DECLARE @@ret BIGINT ; USE [AigCommonDb] EXECUTE @@ret=[AigCommonDb].[dbo].[sp_getProfile_Minerva] @userName = N'%1' ] gs_SQLstring = StringBuild(gs_SQLstring, "vandera") IF HExecuteSQLQuery(qry_file_CommonDB, gs_CommonDB_Connection, ... hQueryWithoutCorrection,gs_SQLstring ) THEN IF ErrorOccurred THEN Error(HErrorInfo(hErrComplet)) END IF HReadFirst(qry_file_CommonDB) THEN Info(qry_file_CommonDB.userProfile) END ELSE Error(HErrorInfo()) END Error message on HReadFirst: Error at line 30 of Global Procedure Run_Stored_Procedure_AIGCOmmonDB process. HReadFirst function called. The <qry_file_CommonDB> data source is not initialized. - If it is a data file, the file was not found in the <C:\My Projects\BE_MINERVA\BE_MINERVA.wdd> analysis or it was not described by HDeclare/HDeclareExternal. - If it is a query or a view, the execution may have failed. To retrieve the corresponding error, check the result of HExecuteQuery/HExecuteSQLQuery/HCreateView. ----- Technical Information ----- Project : BE_MINERVA WL call: Process of 'Global Procedure Run_Stored_Procedure_AIGCOmmonDB' (Global_Procedures.Run_Stored_Procedure_AIGCOmmonDB), line 30, thread 0 'HReadFirst' function, syntax 3 What happened? The <qry_file_CommonDB> data source is not initialized. - If it is a data file, the file was not found in the <C:\My Projects\BE_MINERVA\BE_MINERVA.wdd> analysis or it was not described by HDeclare/HDeclareExternal. - If it is a query or a view, the execution may have failed. To retrieve the corresponding error, check the result of HExecuteQuery/HExecuteSQLQuery/HCreateView. Error code: 70018 Level: fatal error (EL_FATAL) WD55 error code: 18 Dump of the error of 'WD190HF.DLL' module (19.0.97.1). Identifier of detailed information (.err): 70116 Debugging information: IEWDHF=1.1 Module=<WDHF> Version=<19.0.97.1> Fonction (7,10) Additional Information: EIT_PATHWDD : <C:\My Projects\BE_MINERVA\BE_MINERVA.wdd> EIT_LOGICALTABLENAME : <qry_file_CommonDB> EIT_PILEWL : Global Procedure Run_Stored_Procedure_AIGCOmmonDB (Global_Procedures.Run_Stored_Procedure_AIGCOmmonDB), line 30 Selecting the menu of _Menu.Test (WIN_Main._Menu.Test), line 1 EIT_DATEHEURE : 11/01/2018 10:12:43 Help - Check that the file is described in the current analysis. - For a dynamically described file, check that it has been properly declared with HDeclare, HDeclareExternal or HDescribeFile. - For a query created in the query editor, or a query written in SQL language, check that it has been declared with HExecuteQuery or HExecuteSQLQuery. Stored procedure sp_getProfile_Minerva: USE [AigCommonDb] GO /****** Object: StoredProcedure [dbo].[sp_getProfile_Minerva] Script Date: 01/11/2018 10:19:54 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[sp_getProfile_Minerva] @userName nvarchar(50) AS DECLARE @countUserName int; DECLARE @DEFAULT_PROFILE nvarchar(50); SET @DEFAULT_PROFILE = 'RO' SET @countUserName = (SELECT count(*) FROM User_Minerva WHERE [UserName] = @userName ) IF @countUserName = 0 BEGIN INSERT INTO User_Minerva([UserName],[userProfile]) VALUES(@userName,@DEFAULT_PROFILE) END UPDATE User_Minerva SET UserLastLogin = getdate() WHERE [UserName] = @userName SELECT [userProfile] FROM User_Minerva >WHERE [UserName] = @username Note: The file User_Minerva is declared in the Analysis30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63977-stored-procedure-sql-olebd-problem-get-result-dataset/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)