Page 1 of 1

Android app all of a sudden cant test on a physical device

Posted: Fri Dec 06, 2024 5:37 pm
by DavJans
Hi all, not sure what I did. Nothing crazy in the code. Have had this app for 5+ years now but needed to point to a new server. As it is hard coded just for personal use I just updated the connection string. Now when I try to re- install it on my device using my device as a test target it seems to test just fine but when it tries to open I just get a black screen and then it minimizes it self. I'm hoping I just did something stupid that's a know thing that is also easy to fix. It wouldn't be terrible to Start a brand new stack but still probably 8 hours of work.

Re: Android app all of a sudden cant test on a physical device

Posted: Fri Dec 06, 2024 9:00 pm
by DavJans
I figured it out. Android doesn't support ODBC. I switched from MySQL to SQL server. This works just fine in wondows but not on android which is why I was confused.

put revOpenDatabase("ODBC","DRIVER=SQL Server;SERVER=();DATABASE=<>;UID=<>;PWD=<>;Trusted_Connection=<>",,,) into tResult

Does anyone know the correct way I should be connecting to a local SQL server on android?