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?
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 CADIOU3 weeks 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 user1 month 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 Kanaujia2 months ago
Non-Standard Port with SQL Server ODBC
Why does the SQL Server ODBC Connection page not mention any example of using a non-standard port? I was incorrectly trying to use the "Port" attribute as "Port=x" but that does not work.0 votes0 answersDavid Garcia2 months ago
NUODB to SQL database migration
Hi Guys I am using SQL Server 2012 , using import and export wizard i want to migrate nuodb databse to sql , but could not find any JDBC data source inside the wizard.0 votes0 answersGautam Raj2 months ago
Connection string issue in connecting to SQL Server
I am trying to connect my C# code to SQL Server. My connection string is not working. It gives the following error: "Format of the initialization string does not conform to specification starting at index 0."0 votes0 answersFaizan Rahman4 months ago
[Microsoft][ODBC Driver Manager] Data source file not found and no default driver specified.
I have a VBA code (in excel 2016) that i use to grab information from a MS SQL server (2008R). The connection works fine on the computer i wrote it on. When i run it on another computer i get the error "[Microsoft][ODBC Driver Manager] Data source file not found and no default driver specified".0 votes1 answerlee avery4 months ago
connect from Oracle to MS SQL Server
I want to Connect from Oracle to MS SQL Server with a connection string to pass location (IP) / username / Password and SQL Database !0 votes0 answersFrank Lehmann4 months ago
Excel 2016 VBA OLE SQL connection help
Excel 2016 VBA to create an OLE connection to a sql 2014 db and then execute a stored procedure returning the results starting cell A1 on sheet :StoredProcData. Server & instance is QGZZZ\MYINSTANCE db is data0 votes0 answersRichard6 months ago
- Load more posts