Here make sure your DNS exists (under user DSN's). Your ODBC Data Source Administrator will open. It responds to all ODBC connection requests made by. To see your existing DSN's go to Control Panel - Data Sources (ODBC). I have tried multiple connection strings in the data source including the one above and the dsn but continue to receive the sane error. The driver manager is a library, which manages communications between applications and ODBC drivers. A system DSN has beed created for each drive and the connection test is successful.
#Odbc manager drivers
The server running the report server has the 32-bit and 64-bit MySql ODBC 8.0 Unicode drivers installed. All major big data, relational, and SaaS/cloud data sources. Make sure you've entered the connection string and any credentials correctly.ĮRROR Data source name not found and no default driver specifiedODBC: ERROR Data source name not found and no default driver specified. Get the fastest, most scalable application performance for ODBC connections with DataDirect ODBC drivers. The report server couldn't connect to the data source using the information you entered. When I create the connection on the report server I receive the error: The paginated report is created in visual studio and uses an ODBC connection with the following connection string:ĭriver=MySQL ODBC 8.0 Unicode Driver server=10.0.0.123 database=machforms I'm tyring to create an ODBC data source on the Report Server to run a paginated report that uses a MySql database.
26414 (May 2021) on a server with a 64-bit operating system. We are running Power BI Report server Version. Pro Cloud Server connections to MySQL, Oracle and PostgreSQL databases require the use of ODBC DSNs, which are defined in the Windows ODBC Data Source Administrator (32-bit) screen.
0 kommentar(er)
