sorry but I'm a bit confused,
I use jRDC with MS SQL server 2012, should I modify Sub LoadConfigMap like this to use single config file for each dbase, server login credentials should be the same in each file or hard coded in jRDC server?
what is the best method to reference dbname in 'sql.' commands?
Private Sub LoadConfigMap As Map
Return File.ReadMap(File.DirAssets, mDBName & "_config.properties") 'include dbname to config file
End Sub
dbase config file for dbase1:
#DATABASE CONFIGURATION for SQL server
DriverClass=net.sourceforge.jtds.jdbc.Driver
JdbcUrl=jdbc:jtds:sqlserver://127.0.0.1/dbase1
User=sa
Password=pw
#Java server port
ServerPort=17178
dbase config file for dbase2:
#DATABASE CONFIGURATION for SQL server
DriverClass=net.sourceforge.jtds.jdbc.Driver
JdbcUrl=jdbc:jtds:sqlserver://127.0.0.1/dbase2
User=sa
Password=pw
#Java server port
ServerPort=17178