I have created database connection successfully on designer application ...
Please show how you tested this. See Wiki - how to post code on this forum for help on how to post your SQL and Python code.
In Designer, have you set Project | Project Properties | General | Default Database to point to your new database?