question

if i was to write a program to connect to my online sql database is there a chance someone could decompile it and get the password?

It's always possible. You could make it harder by encrypting the password.

Yeah never store any password in plain text in any programming language.
I would look to find another way to connect to the online database without storing the password in the program since they could also use a packet sniffer and pick it up.

thanks that answers my question