Use this driver to connect to your company's Microsoft SQL Server or Sybase databases. This driver installs completely on your Mac - nothing is installed on the. Jun 23, 2018 - Installing the Connector/ODBC driver lets you connect to MySQL databases on any platform through the ODBC interface. If your application. This tool seems pretty neat, but it it a 32 bits app. All my attempts to connect to PostgreSQL x64 failed, reporting an architecture mismatch between the driver (64) and the application, which is 32. I'm not too hopeful with regards to MySQL either. Help > Visit web site. Sends us to www.kaimon.cl/contenido/software/odbc-query-tool/, which is a beautiful 404, same as checking for updates. It is easy to criticise apps that someone went to through the trouble to put together for free. If a next release of this fixes the 64 bits item, I'll raise it to 5 stars on the spot. I am having trouble connecting to a SQL Server (2008 R2) via the new Excel 2016 for Mac SQL Server ODBC New Database Query feature. We also have another SQL Server (SQL Server Express 2012) that I also access via ODBC on Windows Excel 2016. I tried to follow the Office Support info available on this link: I successfully manage to query the same SQL server in Windows using ODBC connections to the SQL server on our LAN. However, I try the same or similar settings with my Mac's Excel 2016 and I do not succeed in making the connection. I do the following: I started with the following settings: Server Name: 10.66.4.4 Database: MSSQLSERVER1 Authentication: Method: Username/Password User Name: crystal Password: ******* Error Message: [SqlServerODBC] (15) Failed to connect to the SQL Server instanceL [28000]: Login failed for user 'crystal'. I then found some support that stated that I need to specify the Port number for the server (60198): Server Name: 10.66.4.4,60198 Database: MSSQLSERVER1 Authentication: Method: Username/Password User Name: crystal Password: ******* Error Message: [SqlServerODBC] (15) Failed to connect to the SQL Server instance: [HY000]: Connection broken unexpectedly Now the error code changes from 28000 to HY000 and the message reads 'Connection broken unexpectedly'. I also tried without specifying the actual Database name with the same result. I originally started with the Office support forum pages - see the following post: It was on this forum where they pointed me to this forum. So it seems that I am now stuck between the two forums that appear to be referring me to the other. How do I solve this? Microsoft Answers forum seems to think this is an authentication issue but I don't have any issue accessing the same SQL server via ODBC on a windows 7 machine and I use the SQL authentication and not Windows NT Auth. I am really hopeful that someone would be able to help me debug this problem and provide some support for me to move forward and get the SQL ODBC setup working with the Excel 2016 for Mac. Apologies for the slow response, I forgot to be alerted when someone responds. The username is correct because we are using SQL authentication instead of Windows Authentication. ![]() On Windows the ODBC SQL Server DSN Configuration is setup With SQL Server authentication using a login ID and password instead of with Windows NT authentication. The login ID is crystal and this works fine using Excel 2016 on Windows. I am unfortunately not able to attache images or links yet as my account hasn't been verified, but I did originally start with a O365 for Business Forum query where I raised where they pointed me to the MSDN Forums for more help on the SQL Server Data Access. I am really hopeful that someone will be able to direct me to solving this conundrum. I am happy to make configuration changes to the SQL server if necessary, but I do need advice on this as I am not a SQL Server expert.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
March 2019
Categories |