if you have a SQL database residing on a remote website (NOT local) and you have the MS SQL Server address= 'dbService.mssql.site.com' and user name ='defaultuser' and password='Anypass' what will be the lines in config.properties file to achieve an RDC connection through 'RunRLC.bat' to run the server. I do not want the server to run on a local machine since my database is remote and opening the server port is a heck of problem.
My confusion is really that: If I want my android app to connect to a remote database why would I use a database that resides on a PC. How would the app find the address?
#Lines starting with '#' are comments.
#Backslash character at the end of line means that the command continues in the next line.
#SQL Server
DriverClass=net.sourceforge.jtds.jdbc.Driver
JdbcUrl=jdbc:jtds:sqlserver:// dbService.mssql.site.com /dbService
User=defaultuser
Password=AnyPass ServerPort=????
#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
#commands
sql..................
sql.................
sql.select_...=SELECT ... ... FROM .... WHERE ... = ?
Hi,
Yes I can ping it and I can make connection to the remote database site by using ASP.NET but as I want to make the server with the same parameters I fail and the server does not work. Is it necessary to detect a port number because I do not know it for the ms sql server I use.
I know that sir but how would I achieve that server in the correct way in order connect to the remote SQL server with the above parameters (What is wrong with them)?
You can use any unused port number as long as it is not reserved. Normally I use a number bigger than 5000. This port number is for java server.
As I mentioned above, I gave a number 17178 as the ServerPort value. Of course you need to allow this port in firewall.
For mssql database server, if you never change the default value, you can ignore the number. The default port number is 1433.
I know that sir but how would I achieve that server in the correct way in order connect to the remote SQL server with the above parameters (What is wrong with them)?
Using the ip in the config.properties, the server on the command window is working but I can not connect to it in the browser with the 'site can't be reached' and 'took too long to repond' message popping
Using the ip in the config.properties, the server on the command window is working but I can not connect to it in the browser with the 'site can't be reached' and 'took too long to repond' message popping