Hi Udhaya
If I understand the issue, I present some insights, and potential solutions:
Database Type:
Hostname or IP Address:
Port:
Database Name:
Username and Password:
Additional Connection Options:
Here's a step-by-step guide on how you can generally set up a database connection in Mendix:
Open your Mendix project:
Go to the "Database" tab:
Click "New Database" or a similar option:
Select Database Type:
Enter Connection Details:
Test Connection:
Save the Connection:
Use the Connection in Your App:
** Kindly accept my answer if it assist you to solve your problem.
As explained in the documentation, these are the credentials you need to connect. The hostname specifically is the host (server) where your external database can be found. If you are running locally and testing a local database, you might be able to use localhost. The port, database, username and password are settings you can configure when setting up your database. You could check with your DBA to see how to connect to the required database.
For example let's say you are connecting PostgreSQL. So for that,
1. Database Name: Add name of the database in the PgAdmin and put that here in the above screenshot.
2. Host : Usually, let's say you are working on localhost so Host will be localhost:{PortNumber of PgAdmin which is default 5432).
3. Username : Default username for PostgreSQL is 'postgres'.
4. Password: It is the same password that you have put while installing the PostgreSQL.
Done and you are good to go.
Just close the serve and run your application. Check console where you will find all the DB connection related logs.
This https://docs.mendix.com/developerportal/operate/restore-backup-locally/ link will help you further as a documentation.
Thanks!
Now im getting like this please help me resolve
Im getting this error please someone help to solve my issue , i have checked my db connection it was connecting in other sources , but in mendix i cant able to connec the db please help me
Check Oracle Connection Details:
Network Connection:
Oracle Client Installation:
tnsnames.ora
file or the Oracle Wallet is correctly configured with the required connection details.Driver Configuration:
Testing Outside Mendix:
Mendix Version Compatibility:
Error Logs:
Database Server Status: