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

Got a LiveCode personal license? Are you a beginner, hobbyist or educator that's new to LiveCode? This forum is the place to go for help getting started. Welcome!

Moderators: FourthWorld, heatherlaine, Klaus, kevinmiller

Post Reply
DavJans
Posts: 275
Joined: Thu Dec 12, 2013 4:21 pm

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

Post by DavJans » Fri Dec 06, 2024 5:37 pm

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.
"Det bästa stället att hitta en hjälpande hand är i slutet av din egen arm" förutom här

DavJans
Posts: 275
Joined: Thu Dec 12, 2013 4:21 pm

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

Post by DavJans » Fri Dec 06, 2024 9:00 pm

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?
"Det bästa stället att hitta en hjälpande hand är i slutet av din egen arm" förutom här

Post Reply