T Thomas Myers New Member Licensed User Longtime User Jun 4, 2015 #1 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.
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.
T Tom Law Active Member Licensed User Longtime User Jun 4, 2015 #2 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. Upvote 0
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.
DonManfred Expert Licensed User Longtime User Jun 4, 2015 #3 Tom Law said: MariaDB connector Click to expand... it is a connector to MySQL. Not MS SQL Upvote 0
T Tom Law Active Member Licensed User Longtime User Jun 4, 2015 #4 Oh I see, it says mssql on the first line but says my SQL on the second. ☺ Upvote 0
DonManfred Expert Licensed User Longtime User Jun 4, 2015 #5 Tom Law said: but says my SQL on the second Click to expand... Thomas Myers said: have installed Java 8 Update 45 on my SQL Server Click to expand... "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 Upvote 0
Tom Law said: but says my SQL on the second Click to expand... Thomas Myers said: have installed Java 8 Update 45 on my SQL Server Click to expand... "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
johnB Active Member Licensed User Longtime User Jun 16, 2015 #6 DonManfred said: "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 Click to expand... Thanks for the link and library, I'll try this shortly Upvote 0
DonManfred said: "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 Click to expand... Thanks for the link and library, I'll try this shortly
DonManfred Expert Licensed User Longtime User Jun 16, 2015 #7 johnB said: Thanks for the link and library, I'll try this shortly Click to expand... See my Signature to get to a list of all my libraries (DonManfreds overview). Upvote 0
johnB said: Thanks for the link and library, I'll try this shortly Click to expand... See my Signature to get to a list of all my libraries (DonManfreds overview).
johnB Active Member Licensed User Longtime User Jun 16, 2015 #8 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 Upvote 0
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
Erel B4X founder Staff member Licensed User Longtime User Jun 16, 2015 #9 Please start a new thread for this question. Upvote 0
johnB Active Member Licensed User Longtime User Jun 16, 2015 #10 Erel said: Please start a new thread for this question. Click to expand... Sorry, I did what I should have done before posting and googled the question. Hope the answer was correct Upvote 0
Erel said: Please start a new thread for this question. Click to expand... Sorry, I did what I should have done before posting and googled the question. Hope the answer was correct
T Thomas Myers New Member Licensed User Longtime User Jun 16, 2015 #11 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. Upvote 0
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.
Eduardo Bardales Member Licensed User Longtime User Jun 19, 2015 #12 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. Upvote 0
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.
