Android Question RDC to MS SQL Server

Discussion in 'Android Questions' started by Thomas Myers, Jun 4, 2015.

  1. Thomas Myers

    Thomas Myers New Member Licensed User

    I am new to B4A and trying to piece together what I need to create a remote connection to my MS SQL Server.

    I have downloaded and unzipped RDC-Client on my PC. I have installed Java 8 Update 45 on my SQL Server in C:\Program Files (x86)\Java\jre1.8.0_45.

    I have downloaded and unzipped both jtds and Microsoft JDBC drivers on my SQL server. The following were copied to C:\Program Files (x86)\Java\jre1.8.0_45\lib: jtds-1.3.1.jar, sqljdbc.jar, sqljdbc4.jar and sqljdbc41.jar. Recommendations on which driver to use would be appreciated.

    I have added CLASSPATH as a system variable with this value: C:\Program Files (x86)\Java\jre1.8.0_45\lib.

    There are two items mentioned in other threads that I have not been able to locate: RunRLC.bat and RDC-Server.zip.

    Am I started in the right direction? Any help would be appreciated.
     
  2. Tom Law

    Tom Law Active Member Licensed User

    Hi Thomas, just completed a similar project myself. Use the search facility to look for MariaDB connector. I found it simple to use and very fast.
     
  3. DonManfred

    DonManfred Expert Licensed User

    it is a connector to MySQL. Not MS SQL
     
  4. Tom Law

    Tom Law Active Member Licensed User

    Oh I see, it says mssql on the first line but says my SQL on the second. ☺
     
  5. DonManfred

    DonManfred Expert Licensed User

    "my SQL Server" is not "MySQL server" :)

    But thank you anyway to pointing him to my Library. If he ever need to connect to MySQL then he now know a good library :)
     
    Last edited: Jun 5, 2015
  6. johnB

    johnB Active Member Licensed User

    Thanks for the link and library, I'll try this shortly
     
  7. DonManfred

    DonManfred Expert Licensed User

    See my Signature to get to a list of all my libraries (DonManfreds overview).
     
  8. johnB

    johnB Active Member Licensed User

    Sorry for the post, I know that this is not an SQL forum but I'm not a member of any SQL forums and I'm sure that I read in a post on this forum that SQLite is basically a single user platform, only one user access at a time, can anybody please confirm whether I read the post correctly, it was a while ago

    Regards
     
  9. Erel

    Erel Administrator Staff Member Licensed User

    Please start a new thread for this question.
     
  10. johnB

    johnB Active Member Licensed User

    Sorry, I did what I should have done before posting and googled the question. Hope the answer was correct
     
  11. Thomas Myers

    Thomas Myers New Member Licensed User

    Thanks for your posts. I was finally able to work through this and am able to use my android devices to query my corporate MS SQL Server remotely using the DBRequestManager class.
     
  12. Eduardo Bardales

    Eduardo Bardales Member Licensed User

    Thomas can you helpme please with any sample, i can connect from my htc phone to my database made in sql server in my pc. I need send records from my htc to my computer. Thanks.
     
Loading...