Remote MySQL Linked Server in SQL Server, only show names of the tables.
Remote MySQL Linked Server deployed in SQL Express Management Studio do not show any content and structure, it only LIST NAME of the tables belongs to the remote connected MySQL database
A remote MySQL database is running in a Linux server and, working in a Windows Server with sql database, I need to manage data from that remote database.
Tried to connect with different ODBC drivers and everything is OK in terms of connection. But, after successfully created a linked server in the Sql Server Microsoft environment, when deploy the tables tree of the referred database, only the list of the table names of the complete database apear there in the catalogue area of Linked Server SQL Server object, no way to show columns neither data.
Trying to verify if the problem come from the origin, installed in the same windows server the workbench app, and in this case the complete deployment of that database come correctly.
Same issue in Windows Server 2012 and 2016
Changed many parameters and the problem persist. Can somebody tell me which is the correct way to solve this connection?
What are steps in connecting VB.net with SQL server?0 votes0 answersMuhammad Abdullahi1 month ago
Azure SQL DB connection string is not working unless logged in to azure account
I'm building an Visual C++ project which is connected to Azure SQL database via ODBC, I placed the following connection string that Azure:0 votes0 answersAhmed Ayman1 month ago
Making Constant Data Bases to recall in program.
I'm a student learning programming. I need to find out what web address gets my database and server. I need to find out what the database name is.0 votes0 answersBrad Harris1 month ago
Connection error IIS10/SQL 2016
I try to transfer a classic-asp-application from Windows Server 2008R2/II7 to 2016/II10 and SQL 2008 to SQL 2016. The application works fine with IIS10 and SQL 2008. Also with IIS7 and SQL 2016.0 votes0 answersPaul H. Niederbracht1 month ago
SSIS package with ODBC source Teradata Deployment issue
SSIS package works fine in Visual Studio, But when deployed it says gives error, SQL Jobs fails execution0 votes0 answersSandesh J2 months ago
proplem in connecting phpmyadmin database to asp.net mvc
add name="xyzEntities" connectionString="Data Source=22.214.171.124;port=3306;Integrated Security=false;Initial Catalog=database name;User Id=myname;password=mypass" providerName="MySql.Data.MySqlClient"/0 votes0 answersvivek kansal2 months ago
Connect to SQl with gMSA
I'm trying to make use of gMSA's to connect from ASP/X code to an MS SQL 2016 server. I've configured the gMSA with permissions on the target database and set up the gMSA on the source server, but can't get a connection string configured to use the account.0 votes0 answersSteve Sirag3 months ago
Connect a VbScript to MySQL without ODBC driver
Hi everybody, I'm just beginning with MySQL and I try to make a connection between a VBscript and a MySQL Database.0 votes4 answersJean-Marc CADIOU4 months ago
ADO connection string
I need a ADO connection string to work with Quick Payroll, I am not a developer but I need it in order to customise reports.0 votes0 answersAnonymous user5 months ago
Table 'mysql.proc' doesn't exist
I get the error able 'mysql.proc' doesn't exist while executing procedures from .net application using proxysql. MySQL version: 8.0.13 MySQL.Data version: 8.0130 votes0 answersRahul Kanaujia6 months ago
- Load more posts