pcsoft.us.windevCopyright 2026, PC SOFT28 Jul 2017 06:28:56 Z16 Jan 2009 11:24:00 ZHi, I have deployed the following files Final_WebService.WDL Final_WebService.XML , I have configured the IIS properly and the web service is working fine when i return some static value from the web service like the procedure below PROCEDURE ret() RETURN "Hello" but it gives me an error when i use to retrieve data from a table like the procedure below. ______________________________________________ PROCEDURE CheckLogin(b) user is Clogin_master ds is Data Source Deserialize(user,b,psdXML) MemoryToFile(user,login_master) HExecuteSQLQuery(ds,"select * from login_master where user_id='"+ user:user_id+"'") HReadFirst(ds) IF HFound(ds) THEN RESULT "True" ELSE RESULT "False" END _________________________________________________ I have WDL and XML files hosted , do i have to host any other analysis or class files to the soap server. I am receiving this error when i execute the web service "analysis query/view not initialized". Does the deployment pc requires windev installed on it?? or i am missing something. I have tested the procedure without deoloying and it is working fine. URGENT!! Please help!! Regards, Prolay30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/17455-web-service-not-returning-data-from-database/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)007niyasakayilpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/17455-web-service-not-returning-data-from-database-61939/read.awp28 Jul 2017 06:28:56 Zhi, i am using windev 21.when i try to execute a system stored procedure in mssql database throu OLEDB it doesn,t work properp…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/17455-web-service-not-returning-data-from-database-61939/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/17455-web-service-not-returning-data-from-database-61939/read.awpWeb Service not returning data from databaseguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/17455-web-service-not-returning-data-from-database-17467/read.awp16 Jan 2009 15:55:46 ZHi, Problem Solved The default connection to database was giving this error so i defined my own connection and it was working …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/17455-web-service-not-returning-data-from-database-17467/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/17455-web-service-not-returning-data-from-database-17467/read.awpWeb Service not returning data from databaseguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/17455-web-service-not-returning-data-from-database-17463/read.awp16 Jan 2009 13:41:37 ZHi Prolay... I totally agree with Paulo that you should test the return values of your functions... But just by reading your co…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/17455-web-service-not-returning-data-from-database-17463/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/17455-web-service-not-returning-data-from-database-17463/read.awpWeb Service not returning data from databaseguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/17455-web-service-not-returning-data-from-database-17462/read.awp16 Jan 2009 13:41:27 ZHi, Data Source: RAHULA-PC OLEDB Provider: SQLOLEDB why is the webservice not able to access database? I tried it with other …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/17455-web-service-not-returning-data-from-database-17462/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/17455-web-service-not-returning-data-from-database-17462/read.awpWeb Service not returning data from databaseguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/17455-web-service-not-returning-data-from-database-17459/read.awp16 Jan 2009 12:35:13 ZPlease help out with this error execsql OLE DB access error. Error Number = 170124 Failure opening connection: Data Sour…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/17455-web-service-not-returning-data-from-database-17459/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/17455-web-service-not-returning-data-from-database-17459/read.awpWeb Service not returning data from databaseguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/17455-web-service-not-returning-data-from-database-17458/read.awp16 Jan 2009 12:17:05 Zprobably some dll's are missing. To test webservices i use one text file to log all the possible errors, this is the only way i…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/17455-web-service-not-returning-data-from-database-17458/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/17455-web-service-not-returning-data-from-database-17458/read.awpWeb Service not returning data from databaseguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/17455-web-service-not-returning-data-from-database-17457/read.awp16 Jan 2009 12:16:43 ZSorry, The code isn't tested as you can see (missing one " in the Fopen), but I hope the idea helps.https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/17455-web-service-not-returning-data-from-database-17457/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/17455-web-service-not-returning-data-from-database-17457/read.awpWeb Service not returning data from database