I am using the following as a connection to a MYSQL database.
The database and the middleware reside on the same server.
This works great, my config:
I am now busy with a new app that requires a connection to a Microsoft SQL Server database.
The middleware will NOT be residing on the same server as the SQL Server database.
As such, the middleware will be residing on one server (listen on port 17170) that will "redirect" queries to the SQL Server database on another server.
Is the following config correct:
Is it correct to have the SQL Server database port as:
The database and the middleware reside on the same server.
This works great, my config:
B4X:
DriverClass=com.mysql.jdbc.Driver
JdbcUrl=jdbc:mysql://localhost/istockDB?characterEncoding=utf8
#SQL Server
#DriverClass=net.sourceforge.jtds.jdbc.Driver
#JdbcUrl=jdbc:jtds:sqlserver://<database server ip>/<database>
User=root
Password=
ServerPort=17178
#If Debug is true then this file will be reloaded on every query.
#This is useful if you need to modify the queries.
Debug=true
I am now busy with a new app that requires a connection to a Microsoft SQL Server database.
The middleware will NOT be residing on the same server as the SQL Server database.
As such, the middleware will be residing on one server (listen on port 17170) that will "redirect" queries to the SQL Server database on another server.
Is the following config correct:
B4X:
#DriverClass=com.mysql.jdbc.Driver
#JdbcUrl=jdbc:mysql://localhost/test?characterEncoding=utf8
#SQL Server
DriverClass=net.sourceforge.jtds.jdbc.Driver
JdbcUrl=jdbc:jtds:sqlserver://197.96.xxx.xxx,1440/sectorstores
User=mytest
Password=mytest
ServerPort=17170
#If Debug is true then this file will be reloaded on every query.
#This is useful if you need to modify the queries.
Debug=true
Is it correct to have the SQL Server database port as:
B4X:
JdbcUrl=jdbc:jtds:sqlserver://197.96.xxx.xxx,1440/sectorstores