How can I make a UDL (Universal Data Link) file to test comunication to a data base of Azure database for MySQL flexible server?

Question

How can I make a UDL (Universal Data Link) file to test comunication to a data base of Azure database for MySQL flexible server?

Rafael Isas Hidalgo 0

Oury Ba-MSFT 20,931 Reputation points Microsoft Employee Moderator

2024-09-12T19:00:36.4+00:00

@Rafael Isas Hidalgo Thank you for reaching out.

Are you trying to connect to an Azure MYSQL flexible server.? was it created through VNET or public access?

Regards,

Oury
Sai Raghunadh M 4,640 Reputation points Microsoft External Staff Moderator

2024-09-16T14:06:06.92+00:00
Hi @Rafael Isas Hidalgo,

Thanks for the question and using MS Q&A platform.

In addition to Oury Ba-MSFT.

1.create a udl file,I named it as TestConnection with extension "udl"Double-click the .udl file to open the Data Link Properties dialog.

2.Go to the Provider tab and select Microsoft OLE DB Provider for ODBC Drivers.

Click Next.

Set Up the Connection:

In the Connection tab, enter the following details:

Data Source Name (DSN): If you have an ODBC DSN set up for your Azure MySQL database, select it here. Otherwise, you can use a connection string.

User name: Your MySQL username.

Password: Your MySQL password.

Initial catalog: The database name you want to connect to. 4.Test Connection:

Click the Test Connection button to verify that the settings are correct and that you can connect to the database.

If you encounter any issues, make sure that:

Your Azure MySQL server allows connections from your IP address.

The firewall rules in Azure are configured correctly.

The MySQL server is running and accessible. I hope this information helps, please let us know if you have any further queries.
Sai Raghunadh M 4,640 Reputation points Microsoft External Staff Moderator

2024-09-17T17:12:43.0666667+00:00

Hi @Rafael Isas Hidalgo,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Sai Raghunadh M 4,640 Reputation points Microsoft External Staff Moderator

2024-09-18T18:24:12.6+00:00

Hi @Rafael Isas Hidalgo,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.

Your answer

Oury Ba-MSFT 20,931 Reputation points Microsoft Employee Moderator

2024-09-12T19:00:36.4+00:00

@Rafael Isas Hidalgo Thank you for reaching out.

Are you trying to connect to an Azure MYSQL flexible server.? was it created through VNET or public access?

Regards,

Oury
Sai Raghunadh M 4,640 Reputation points Microsoft External Staff Moderator

2024-09-16T14:06:06.92+00:00

Hi @Rafael Isas Hidalgo,

Thanks for the question and using MS Q&A platform.

In addition to Oury Ba-MSFT.

1.create a udl file,I named it as TestConnection with extension "udl"Double-click the .udl file to open the Data Link Properties dialog.

2.Go to the Provider tab and select Microsoft OLE DB Provider for ODBC Drivers.

Click Next.

Set Up the Connection:

In the Connection tab, enter the following details:

Data Source Name (DSN): If you have an ODBC DSN set up for your Azure MySQL database, select it here. Otherwise, you can use a connection string.

User name: Your MySQL username.

Password: Your MySQL password.

Initial catalog: The database name you want to connect to. 4.Test Connection:

Click the Test Connection button to verify that the settings are correct and that you can connect to the database.

If you encounter any issues, make sure that:

Your Azure MySQL server allows connections from your IP address.

The firewall rules in Azure are configured correctly.

The MySQL server is running and accessible. I hope this information helps, please let us know if you have any further queries.
Sai Raghunadh M 4,640 Reputation points Microsoft External Staff Moderator

2024-09-17T17:12:43.0666667+00:00

Hi @Rafael Isas Hidalgo,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Sai Raghunadh M 4,640 Reputation points Microsoft External Staff Moderator

2024-09-18T18:24:12.6+00:00

Hi @Rafael Isas Hidalgo,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.

Share via

How can I make a UDL (Universal Data Link) file to test comunication to a data base of Azure database for MySQL flexible server?

Your answer