There are screenshots and detailed instructions found in a how to here: https://manual.pvxplus.com?How%20To/How%20to%20Use%20PxPlus%20VS%20Code%20Ext.htm

The VS Code Extension needs to be given the path to an active PxPlus executable not the activation file. In this first version you can't point it at a remote PxPlus to use it.

We are looking into that as a feature we can add in a update.

Yes it is the offset in the field.

Based on that ini setting it seems that the ODBC will ignore the data in the file for the first 5 characters and then treat the next 9 as the field.

No when using the [ADO] interface ODBC is not used.

The error 15 means the error is coming not from PxPlus so the important error info is:

HY000: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

It sounds like it can't find the SQL server using the server url SADI.

I think when you used SADI\SQLEXPRESS it gaev an error about a login which means it connected and tried to login.

I assume what you would want based on the info provided is

OPEN (CHAN,IOL=*,OPT=";USER=sa;PSWD=sa123@123@;Connect='Provider=SQLOLEDB;';DB=WMPOS;KEY=PK_D_INVENTORY;CONCURRENCY=LOCK;EXTROPT=(UPDLOCK)")"[ado]SADI;D_INVENTORY"

some of the errors you were getting were login errors so you may want to confirm user name and password.

Here is an example open using [ADO] for a SQL Server database

open (1,iol=*,opt=";USER=username;PSWD=password;Connect='Provider=SQLOLEDB;';DB=db_name;KEY=key_field;CONCURRENCY=LOCK;EXTROPT=(UPDLOCK)")"[ado]server_url;table_name"

Note that server_url is not the name of the SQL server but of the url of the machine it is running on. So if this is all running on the same machine right now then use localhost for the server_url.

For the table name I think you want to leave off the dbo. so just use D_INVENTORY.

Some things I would check are:

-Have you tried checking the enable mapping?
   -Maybe that is needed to enable the setting.

-Firewall (on both router and device running ezweb server)
   -Make sure the wan port and lan port are allowed inbound access

-Your external IP address is it static or dynamic?
   -If dynamic it could have changed since you checked it.

-Your device internal IP address is it static or dynamic?
   -If dynamic it could have changed since you checked it.

-Is you router connected directly to the internet or to another network?
   -If not connected directly you will have to adjust firewall and port forwarding another level higher as well.

Quote from: James Zukowski on July 11, 2024, 03:04:52 PMIs there a way to get something like the old singular "Unread Posts" button? With this new format, it seems I get to check the Alerts as well as the Updated Tops and Unread Posts under my avatar if I want to get all of the updates since the last time I checked.

You can change the theme by clicking look and layout after clicking your profile icon. Then select the SMF default theme curve2. This theme has the button at the top still. You will have to decide which theme you like better overall.

Quote from: dlocke on August 19, 2024, 12:36:59 PMIs there a way to search the forums and have it not include substrings ?  I'm trying search for "log" and it's including logic, catalog , dialog , technologies and etc. 

The forum software has a default mode where the search is not whole word. I can turn on whole word search but then you can't do partial word search. For now as I think it is more useful I have switched it to whole word search. If this ends up being worse overall I may switch it back.

I think the issue should now be resolved.

Please try again.

Hi John,

PxPlus does not come with a Open Office/Libre Office interface.

You could write code to interface with the application via the COM interface.

You could also use the Google Workspace object to use Google doc and sheets and export as different file formats like ms office or open office.

Things you can try if you haven't already:

1. Setting the Icon=icon_path in the [config] section of the pxplus.ini file

2. Doing a print 'option'("ICON",icon_path$) or print 'option'("WDWICON",icon_path$)

If you are trying to change a non secure TCP connection to secure you need to use SETDEV SET directive or the PRINT 'OPTION' mnemonic with SSL/TLS specific options. See SETDEV SET directive, 'OPTION' mnemonic and TCP Options. For an example of switching an unsecure TCP connection to a secure one, see Changing from Non-Secure to Secure.

From your example it looks like you want to replace

write record (channel) 'option'("Secure", $$) + eol$

with

print(channel) 'option'("Secure", "")

The relevant documentation can be found as part of the DIM directive documentation and the DIM function documentation here are some direct links:

https://manual.pvxplus.com?directives/dim.htm#load

https://manual.pvxplus.com?functions/dim.htm#json

Try

ret = SQLDriverConnect(dbc, NULL, connStr, SQL_NTS, NULL, 0, &outstrlen, SQL_DRIVER_NOPROMPT);

The main difference is NOPROMPT instead of PROMPT and passing null for outStr.

Your logic converts the HTML code to ASCII encoding.

The Yen symbol is part of the ASCII encoding. This means there is a conversion for us to do.

The Drachma symbol is not part of the ASCII encoding. This means there is no valid conversion to ASCII and the ? symbol is used.

If you want to use symbols like Drachma you need to use UTF-8. If you do not have UTF-8 mode enabled you will need to first enable it via SET_PARAM 'U8' then you can convert to UTF8 instead of ASCII.

CVS(htmlcode$,"HTML:UTF8")

Alternatively if you just want to display HTML you could always use a embedded browser in your panel to load a HTML file. You can add a COM control to a panel and then select Chromium Browser for the COM control.