This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.
Pages: [1]
1
ODBC / Error while update mssql Database via ODBC
« on: July 06, 2022, 11:12:54 AM »
Hello fellow colleagues!
I have the following problem. I'm testing around with SQL and have the following code:
0100 ! ^100
0110 LET DATABASE$="[ODB]lansweeper;"
0120 LET OPT$="USER=lansweeperuser;PSWD=***********"
0130 LET DB1=HFN
0140 OPEN (DB1,OPT=OPT$)DATABASE$
0150 GOSUB READ_IT
1000 READ_IT:! ^1000
1010 LET ASSETID=34393
1015 LET SEL_STRG$="select assetname from tblassets where ASSETID="+STR(ASSETID)
1016 READ (DB1,KEY=SEL_STRG$)
1017 LET SEL_STRG$="update tblassetcustom set custom1='400_neu' where ASSETID="+STR(ASSETID)
1020 ! READ RECORD (DB1,KEY=SEL_STRG$)SATZ$
1025 READ (DB1,KEY=SEL_STRG$)
1030 READ (DB1)A$,B$,C$
9900 ENDE:! 9900
9910 ESCAPE
Unfortunately I get an error message during the command to update.
->run
1025 READ (DB1,KEY=SEL_STRG$)
Error #15: Operating system command failed
Last IO to [ODB]lansweeper;, channel 63
Current program is C:\PVX\SQLTEST1, line 1025
HY010: [Microsoft][ODBC Driver Manager] Fehler in der Funktionsreihenfolge
1>
However, the value was still correctly written to the SQL database...
What am I doing wrong?
Maybe you can help me?
Many thanks!
Thomas
I have the following problem. I'm testing around with SQL and have the following code:
0100 ! ^100
0110 LET DATABASE$="[ODB]lansweeper;"
0120 LET OPT$="USER=lansweeperuser;PSWD=***********"
0130 LET DB1=HFN
0140 OPEN (DB1,OPT=OPT$)DATABASE$
0150 GOSUB READ_IT
1000 READ_IT:! ^1000
1010 LET ASSETID=34393
1015 LET SEL_STRG$="select assetname from tblassets where ASSETID="+STR(ASSETID)
1016 READ (DB1,KEY=SEL_STRG$)
1017 LET SEL_STRG$="update tblassetcustom set custom1='400_neu' where ASSETID="+STR(ASSETID)
1020 ! READ RECORD (DB1,KEY=SEL_STRG$)SATZ$
1025 READ (DB1,KEY=SEL_STRG$)
1030 READ (DB1)A$,B$,C$
9900 ENDE:! 9900
9910 ESCAPE
Unfortunately I get an error message during the command to update.
->run
1025 READ (DB1,KEY=SEL_STRG$)
Error #15: Operating system command failed
Last IO to [ODB]lansweeper;, channel 63
Current program is C:\PVX\SQLTEST1, line 1025
HY010: [Microsoft][ODBC Driver Manager] Fehler in der Funktionsreihenfolge
1>
However, the value was still correctly written to the SQL database...
What am I doing wrong?
Maybe you can help me?
Many thanks!
Thomas
2
Language / Big problem with *web/Email
« on: June 15, 2021, 11:52:22 AM »
Hallo all!
Please help me!
PVXPlus PRO V17, SuSE 13.2
I will send a test E-Mail to our exchange but i get an error:
I don't know why it will use ssl...
Here, what i do:
-}goto test
-}run
CALL "*web/email","e-beleg@halek.at","","thomas@pruco.at","","","Test Please Ign
ore","Hi this is a test from PxPlus."+$0D0A$+"Hello World","","N","halek-exchg"+
";"+"25"+";"+""+";"+"",0,-1,"",1,errormsg$,"",savedfilename$
ERROR: Sending to SMTP Server Failed: (99): Writing to SMTP Server: halek-exchg;
25 Failed. (99/175).
MSG(-1)=Could not locate entry point 'TLS_client_method' in libssl library.
Likely an incompatible SSL Interface. (err/ret=0/0)
MSG(-1): Could not locate entry point 'TLS_client_method' in libssl library.
Likely an incompatible SSL Interface. (err/ret=0/0)
10000 ESCAPE
1}
1}
1}open(10)"[TCP]halek-exchg;25"
1}read record(10)x$
1}print x$
220 HALEK-EXCHG.halek.local Microsoft ESMTP MAIL Service ready at Tue, 15 Jun 20
21 17:37:15 +0200
1}end
-}
-}ls -l /lib/libssl*
libssl.so 389,864 Bytes 2016-09-23 20:52:00
libssl.so.1.0.0 389,864 Bytes 2016-09-23 20:52:00
-}ls -l /lib64/libssl*
libssl.so 425,240 Bytes 2016-09-23 20:44:13
libssl.so.1.0.0 425,240 Bytes 2016-09-23 20:44:13
-}
So what can i do?
I'm confused...
Thank You!
Please help me!
PVXPlus PRO V17, SuSE 13.2
I will send a test E-Mail to our exchange but i get an error:
I don't know why it will use ssl...
Here, what i do:
-}goto test
-}run
CALL "*web/email","e-beleg@halek.at","","thomas@pruco.at","","","Test Please Ign
ore","Hi this is a test from PxPlus."+$0D0A$+"Hello World","","N","halek-exchg"+
";"+"25"+";"+""+";"+"",0,-1,"",1,errormsg$,"",savedfilename$
ERROR: Sending to SMTP Server Failed: (99): Writing to SMTP Server: halek-exchg;
25 Failed. (99/175).
MSG(-1)=Could not locate entry point 'TLS_client_method' in libssl library.
Likely an incompatible SSL Interface. (err/ret=0/0)
MSG(-1): Could not locate entry point 'TLS_client_method' in libssl library.
Likely an incompatible SSL Interface. (err/ret=0/0)
10000 ESCAPE
1}
1}
1}open(10)"[TCP]halek-exchg;25"
1}read record(10)x$
1}print x$
220 HALEK-EXCHG.halek.local Microsoft ESMTP MAIL Service ready at Tue, 15 Jun 20
21 17:37:15 +0200
1}end
-}
-}ls -l /lib/libssl*
libssl.so 389,864 Bytes 2016-09-23 20:52:00
libssl.so.1.0.0 389,864 Bytes 2016-09-23 20:52:00
-}ls -l /lib64/libssl*
libssl.so 425,240 Bytes 2016-09-23 20:44:13
libssl.so.1.0.0 425,240 Bytes 2016-09-23 20:44:13
-}
So what can i do?
I'm confused...
Thank You!
3
Programming / Problems wit Terminalserver 2019 and PvxPlus V17.10
« on: May 09, 2021, 06:07:44 AM »
Hello all!
I have a problem with PvX Plus V17.10 and Terminal Server 2019 ...
I keep getting error 65 in many modules.
I just want to show an example here:
Error 65 at:
perform "* winproc.ttl; init_titlebar_controls"; if ...
When I try to display the dump, I also get an error:
[Path to temp \] nomads_dump. [SERVER] .html - File cannot be found.
What am I doing wrong? Why do I get these errors in the terminal server environment?
I use WindX Client...
Please help!
Many Thanks!
I have a problem with PvX Plus V17.10 and Terminal Server 2019 ...
I keep getting error 65 in many modules.
I just want to show an example here:
Error 65 at:
perform "* winproc.ttl; init_titlebar_controls"; if ...
When I try to display the dump, I also get an error:
[Path to temp \] nomads_dump. [SERVER] .html - File cannot be found.
What am I doing wrong? Why do I get these errors in the terminal server environment?
I use WindX Client...
Please help!
Many Thanks!
4
Programming / [DDE] Problem (Excel)
« on: May 07, 2019, 04:23:25 AM »
Hello and good Morning to all of you!
I still can not speak English better ...:-)
I have a little Problem with [DDE] and Excel on one new PC.
Windows 10 / 1809
PxPlus 8.30 (Build 9190) /SuSE -- I know, a little bit old ;-) but it is running smoothly for our Application.
WindX same Version
Office 2016 Home&Business
Now my Problem:
First: On all other Machines are the same Configuration.
We have a Statistic-Application, that writes via DDE to Excel.
An all PC's is no Problem, but on the new one we get an error.
The only thing i have found on the new PC, the Path of Microsoft Office is another than the other PC's.
On the "older" PC's, the Path is "C:\program files (x86)\Microsoft Office\Office15"
We have permanently Updatet Microsoft Office on this Machines since Office Version 2007.
On this new PC the Path is now "C:\program files\Microsoft Office 15"
Maybe this is the Problem?
Or is a PxPlus Update necessary?
When the Problem is the "new" Path of Office, how can i install it to the older Path?
Very Thanks to all of you!
Best Regards
Thomas
I still can not speak English better ...:-)
I have a little Problem with [DDE] and Excel on one new PC.
Windows 10 / 1809
PxPlus 8.30 (Build 9190) /SuSE -- I know, a little bit old ;-) but it is running smoothly for our Application.
WindX same Version
Office 2016 Home&Business
Now my Problem:
First: On all other Machines are the same Configuration.
We have a Statistic-Application, that writes via DDE to Excel.
An all PC's is no Problem, but on the new one we get an error.
The only thing i have found on the new PC, the Path of Microsoft Office is another than the other PC's.
On the "older" PC's, the Path is "C:\program files (x86)\Microsoft Office\Office15"
We have permanently Updatet Microsoft Office on this Machines since Office Version 2007.
On this new PC the Path is now "C:\program files\Microsoft Office 15"
Maybe this is the Problem?
Or is a PxPlus Update necessary?
When the Problem is the "new" Path of Office, how can i install it to the older Path?
Very Thanks to all of you!
Best Regards
Thomas
Pages: [1]