Public Sub GetSQLCommand(SqlKey As String)As String
Dim GetSQL as String="SELECT [Sql] FROM JRDC_SQL WHERE [Sql] is not null AND [Key]=?"
Dim res As String = pool.GetConnection.ExecQuerySingleResult2(GetSQL,Array As String(SqlKey)).ToLowerCase.trim
Return res
End Sub
I think this is more convenient than the commands in a text file
In step 6 of your tutorial, I find that my config.properties file is a pdf; your file in the tutorial is a text file. I get an error when I double click the pdf. The error message says: Adobe Acrobat Reader could not open 'config.properties' because it is either not a supported file type or because the file has been damaged (for example, it was sent as an email attachment and wasn't correctly decoded). I'll look into my c:\\drive at the file.
Thanks, however, I don't have a file or folder called notepad.exe. In my Windows 10 System32 folder, I have an empty notepad file called 'notepad' of type Application. Edited: What I did was to remove the config.properties file which was a PDF I think it was and reintroduce it after opening it as a text file as Jose suggested in post # 6. Now I'll see if I can proceed as your tutorial instructs me to.
Thanks kisoft, I solved the problem with my above **edited post #9. Now I'm tryng to get a URL either for my browser or my computer for the step #7 in Bladimir's tutorial. It's not clear for me to understand which URL I need.
That's because your jRDC2 server and your MS SQL server are in the same computer.
In the client (B4A app?) you should write your pc local network IP (you can get it going to console and writing "ipconfig", or in your network card properties, it will be something similar to 192.168.0.x or 192.168.1.x"
I don't know why when using run>ipconfig, a window blinks but does not display (windows10). I'll try the network card properties (I'll do search to find the card) OK I found it; so I put the 192.168..... in the file, not local host like you mentioned in post #14, right?
Oh yeah the cmd first; I forgot, Thanks. It verified that the IPv4 address is the same as the settings entry...... so I put the 192.168..... in the file, not local host like you mentioned in post #14, right? Maybe I should write 'local host'. Right now it reads:
#DATABASE CONFIGURATION
DriverClass=com.mysql.jdbc.Driver
JdbcUrl=jdbc:mysql://localhost/test?characterEncoding=utf8
User=root
Password=
#Java server port
ServerPort=17178