When I trie to set up a connection with a SQL db, generated in SAP Business One environment and using the jTDS drive, Servoy gives a charset error.
The connection to an example SQL db, not SAP generated on the same server, works fine.
I think that I have to set the charset parameter in the connection string, but also the SAP programmer does not know what.
Any suggestiion? Thanks in advanced!
Have you tried checking with SQL Server’s management tools what the charset is and setting it in the connect URL? You can find here:
http://jtds.sourceforge.net/faq.html
how to put the charset in your connect URL.