I HAVE NEVER TRIED WINDOWS AUTHENTICATION! You must have SQL Server Authentication. You MUST SELECT 'SQL Server and Windows Authentication Mode'. I was warned NEVER put it here but it is working. Or wherever your libs are if it is different. Put the file in: C:\Program Files (x86)\Anywhere Software\Basic4android\Libraries You can download the driver file by Searching the net for jtds-1.3.1.jar or I found it HERE. I have had this working on multiple tablets AND phones. If your SQL Server is on anything other than a Standard Windows/Windows server I cannot help you.Īndroid 7 and above required. IF you want to connect to any other DB other than MS SQL Server then I cannot help you. I have connected to SQL server versions 2008 - 2014 successfully. WHEN IT DOESN'T WORK I TELL OUR CUSTOMERS "CALL YOUR MIS/NETWORKING PEOPLE." They do and THEY have always fixed the problem. We have a number of customers using our program using this type of connection wirelessly on Android tablets. IF YOU CANNOT GET IT TO WORK THEN MORE THAN LIKELY YOUR ISSUE IS FIREWALL/DOMAIN/SQL SERVER CONFIGURATION/SECURITY. I AM ABLE TO SUCCESSFULLY CONNECT TO AN SQL SERVER DATABASE USING THESE PROGRAMS FROM BOTH WINDOWS (B4J) AND ANDROID (B4A). The B4A REQUIRES an INBOUND RULE allowing the PORT I am using through the firewall. For example on my laptop I am able to connect without a problem using the Java program to connect to an SQL database on my laptop. Or, if possible, run the Java program on the computer containing the instance of SQL. The B4J I created for testing as it should have fewer problems connection to an SQL DB from a Windows machine connected with a wire than a wireless tablet trying to connect. If you want code examples download the programs. This subject keeps coming up so I thought I would do a tutorial and sample programs.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |