# \#sql-gateway **URL:** https://community.cdata.com/tag/sql-gateway/44.md [Latest](https://community.cdata.com/latest.md) · [Categories](https://community.cdata.com/categories.md) · [Tags](https://community.cdata.com/tags.md) --- ## [PostgreSQL Data in MySQL Workbench with no tables](https://community.cdata.com/t/postgresql-data-in-mysql-workbench-with-no-tables/1073)
**Author:** [@DuyNguyen](https://community.cdata.com/u/DuyNguyen)\ **Replies:** 1\ **Last updated:** [April 11, 2025, 12:43pm UTC](https://community.cdata.com/t/postgresql-data-in-mysql-workbench-with-no-tables/1073 "2025-04-11T12:43:37Z")
Hi. I am using CData SQL Gateway to query PostgreSQL data in MySQL workbench. MySQL workbench has successfully connected to PostgreSQL data source, but no table can be fetched. Here is my error: This is my CData … --- ## [Maximizing SQL Server Linked Server Efficiency with CData SQL Gateway](https://community.cdata.com/t/maximizing-sql-server-linked-server-efficiency-with-cdata-sql-gateway/1035)
**Author:** [@Dibyendu](https://community.cdata.com/u/Dibyendu)\ **Replies:** 0\ **Last updated:** [March 4, 2025, 6:24am UTC](https://community.cdata.com/t/maximizing-sql-server-linked-server-efficiency-with-cdata-sql-gateway/1035 "2025-03-04T06:24:18Z")
Hey CData Community! Recent updates to the CData SQL Gateway have significantly enhanced its read and write speed performance. Users can now experience up to an 8x improvement in performance across all 270+ supported da… --- ## [Check GLAccountCode linked with Division](https://community.cdata.com/t/check-glaccountcode-linked-with-division/882)
**Author:** [@muthuEOL](https://community.cdata.com/u/muthuEOL)\ **Replies:** 1\ **Last updated:** [August 7, 2024, 9:34pm UTC](https://community.cdata.com/t/check-glaccountcode-linked-with-division/882 "2024-08-07T21:34:49Z")
from which table we can check what are GLAccount code linked for a particular Division ? --- ## [Error: 'Unable to create data source with driver 'DriverType=ODBC;Platform=64', Keyword not supported: 'DRIVER'.'.](https://community.cdata.com/t/error-unable-to-create-data-source-with-driver-drivertype-odbc-platform-64-keyword-not-supported-driver/796)
**Author:** [@Naomi\_Y](https://community.cdata.com/u/Naomi_Y)\ **Replies:** 1\ **Last updated:** [June 21, 2024, 4:04pm UTC](https://community.cdata.com/t/error-unable-to-create-data-source-with-driver-drivertype-odbc-platform-64-keyword-not-supported-driver/796 "2024-06-21T16:04:06Z")
I’m using the Dynamics365 ODBC Driver with SQL Gateway to create a Linked Server. When I try creating a Service within SQL Gateway using a new System DSN, I run into this error of Error: ‘Unable to create data source … --- ## [“The certificate is empty.” Error within SQL Gateway](https://community.cdata.com/t/the-certificate-is-empty-error-within-sql-gateway/726)
**Author:** [@Naomi\_Y](https://community.cdata.com/u/Naomi_Y)\ **Replies:** 0\ **Last updated:** [May 24, 2024, 9:04pm UTC](https://community.cdata.com/t/the-certificate-is-empty-error-within-sql-gateway/726 "2024-05-24T21:04:03Z")
SQL Gateway exposes ODBC data sources as if they were MySQL or SQL Server databases. More can be read about SQL Gateway at the link below: https://www.cdata.com/kb/articles/sqlgateway-overview.rst#setup With TDS (SQL S… --- ## [SQL Gateway – “The ‘Configured\_Service’ expected status was Running, but the actual status is StartPending.” error](https://community.cdata.com/t/sql-gateway-the-configured-service-expected-status-was-running-but-the-actual-status-is-startpending-error/572)
**Author:** [@Bergi\_M](https://community.cdata.com/u/Bergi_M)\ **Replies:** 0\ **Last updated:** [December 14, 2023, 10:31pm UTC](https://community.cdata.com/t/sql-gateway-the-configured-service-expected-status-was-running-but-the-actual-status-is-startpending-error/572 "2023-12-14T22:31:12Z")
This error message indicates the service failed to start within the expected timeframe (default of 30 seconds). When you start the service within the Gateway, it attempts a Test Connection against the driver. Sometimes t… --- ## [SQL Gateway – \[ERROR\] Could not bind server socket.](https://community.cdata.com/t/sql-gateway-error-could-not-bind-server-socket/451)
**Author:** [@Bergi\_M](https://community.cdata.com/u/Bergi_M)\ **Replies:** 0\ **Last updated:** [October 10, 2023, 6:56pm UTC](https://community.cdata.com/t/sql-gateway-error-could-not-bind-server-socket/451 "2023-10-10T18:56:06Z")
Error ‘Could not bind server socket: Only one usage of each socket address (protocol/network address/port) is normally permitted”. This error message usually indicates that we are using a port that is already in use. … --- ## [SQL Gateway – \[ERROR\] The service ‘Configured Service’ can’t be started](https://community.cdata.com/t/sql-gateway-error-the-service-configured-service-can-t-be-started/450)
**Author:** [@Bergi\_M](https://community.cdata.com/u/Bergi_M)\ **Replies:** 0\ **Last updated:** [October 10, 2023, 3:13pm UTC](https://community.cdata.com/t/sql-gateway-error-the-service-configured-service-can-t-be-started/450 "2023-10-10T15:13:50Z")
Error \[500\] The registry token store location ‘registry://%DNS%’ is invalid’. This error message usually indicates that we haven’t established any connection in our ODBC Data Sources. We can overcome this issu… --- ## [SQL Gateway - The \`Service Name\` expected status was Running, but the actual status is Stopped](https://community.cdata.com/t/sql-gateway-the-service-name-expected-status-was-running-but-the-actual-status-is-stopped/432)
**Author:** [@Skerdian\_Shehaj](https://community.cdata.com/u/Skerdian_Shehaj)\ **Replies:** 0\ **Last updated:** [October 4, 2023, 7:04pm UTC](https://community.cdata.com/t/sql-gateway-the-service-name-expected-status-was-running-but-the-actual-status-is-stopped/432 "2023-10-04T19:04:08Z")
The error message, "The Service Name expected status was Running, but the actual status is Stopped", typically indicates that the SQL Gateway service is attempting to operate on a port that is already in use. … --- ## [Linked Server: Physical connection is not usable \[xFFFFFFFF\] error](https://community.cdata.com/t/linked-server-physical-connection-is-not-usable-xffffffff-error/409)
**Author:** [@Kristian\_K](https://community.cdata.com/u/Kristian_K)\ **Replies:** 0\ **Last updated:** [September 21, 2023, 6:33pm UTC](https://community.cdata.com/t/linked-server-physical-connection-is-not-usable-xffffffff-error/409 "2023-09-21T18:33:46Z")
The problem typically arises when there is a discrepancy between the DSN name used and the Catalog value when setting up a linked server. The value should correspond with the DSN employed by the SQL Gateway Service. I… --- ## [SQL Linked Server: Execute a Stored Procedure with input table.](https://community.cdata.com/t/sql-linked-server-execute-a-stored-procedure-with-input-table/400)
**Author:** [@Ilia\_N](https://community.cdata.com/u/Ilia_N)\ **Replies:** 0\ **Last updated:** [September 18, 2023, 6:57pm UTC](https://community.cdata.com/t/sql-linked-server-execute-a-stored-procedure-with-input-table/400 "2023-09-18T18:57:50Z")
There are situations in which Stored Procedures can receive both primitive values and tables as parameters. One example of this is illustrated by the RFC\_READ\_TABLE function module within the SAP ERP provider, which can … --- ## [Cannot process the object ""CatalogName"."SchemaName"."TableName"". The OLE DB provider "SQLNCLI11" for linked server "ConnectionName" indicates that either the object has no columns or the current user does not have permissions on that object](https://community.cdata.com/t/cannot-process-the-object-catalogname-schemaname-tablename-the-ole-db-provider-sqlncli11-for-linked-server-connectionname-indicates-that-either-the-object-has-no-columns-or-the-current-user-does-not-have-permissions-on-that-object/323)
**Author:** [@Luçjano\_Capo](https://community.cdata.com/u/Lu%C3%A7jano_Capo)\ **Replies:** 0\ **Last updated:** [August 8, 2023, 9:53pm UTC](https://community.cdata.com/t/cannot-process-the-object-catalogname-schemaname-tablename-the-ole-db-provider-sqlncli11-for-linked-server-connectionname-indicates-that-either-the-object-has-no-columns-or-the-current-user-does-not-have-permissions-on-that-object/323 "2023-08-08T21:53:18Z")
This error comes from the SQL Server, which indicates there are no permissions to read this table. We can try to use an OPENQUERY to work around these limitations. SELECT \* FROM OPENQUERY (‘ACUMATICA REST’, ‘SELECT \* … --- ## [Cannot select more than 4096 columns in the SELECT statement error](https://community.cdata.com/t/cannot-select-more-than-4096-columns-in-the-select-statement-error/322)
**Author:** [@Luçjano\_Capo](https://community.cdata.com/u/Lu%C3%A7jano_Capo)\ **Replies:** 0\ **Last updated:** [August 8, 2023, 6:21pm UTC](https://community.cdata.com/t/cannot-select-more-than-4096-columns-in-the-select-statement-error/322 "2023-08-08T18:21:38Z")
This is an SQL Server limitation, you can see more about that in the link below: Maximum capacity specifications for SQL Server - SQL Server | Microsoft Learn Even though you cannot select more than 4096 columns, you … --- ## [Linked Server: Joins in OpenQuery fail](https://community.cdata.com/t/linked-server-joins-in-openquery-fail/317)
**Author:** [@Luçjano\_Capo](https://community.cdata.com/u/Lu%C3%A7jano_Capo)\ **Replies:** 0\ **Last updated:** [August 7, 2023, 6:13pm UTC](https://community.cdata.com/t/linked-server-joins-in-openquery-fail/317 "2023-08-07T18:13:33Z")
Using OpenQuery throws the “Duplicate column names are not allowed in result sets obtained through OPENQUERY and OPENROWSET. The column name “id” is a duplicate.” error. This error occurs with every JOIN. The tests I ma… --- ## [SQL Gateway does not support multiple schemas](https://community.cdata.com/t/sql-gateway-does-not-support-multiple-schemas/311)
**Author:** [@Luçjano\_Capo](https://community.cdata.com/u/Lu%C3%A7jano_Capo)\ **Replies:** 0\ **Last updated:** [August 3, 2023, 5:47pm UTC](https://community.cdata.com/t/sql-gateway-does-not-support-multiple-schemas/311 "2023-08-03T17:47:14Z")
SQL Gateway does not allow you to select different schemas at once. Depending on the driver, in order to access different schemas, the main workaround is to create different Data Sources and Linked Servers. Based on the … --- ## [UPSERT is not supported in SQL Server Management Studio](https://community.cdata.com/t/upsert-is-not-supported-in-sql-server-management-studio/308)
**Author:** [@Luçjano\_Capo](https://community.cdata.com/u/Lu%C3%A7jano_Capo)\ **Replies:** 0\ **Last updated:** [August 2, 2023, 8:21pm UTC](https://community.cdata.com/t/upsert-is-not-supported-in-sql-server-management-studio/308 "2023-08-02T20:21:51Z")
Unfortunately, this issue has nothing to do with the CData ODBC driver itself, as our tool supports UPSERTS wherever applicable. The problem here is that SQL Server Management Studio itself does not support upsert operat… --- ## [Error message code 500: Could not execute the specified command: Unknown datatype: unique identifier.](https://community.cdata.com/t/error-message-code-500-could-not-execute-the-specified-command-unknown-datatype-unique-identifier/307)
**Author:** [@Luçjano\_Capo](https://community.cdata.com/u/Lu%C3%A7jano_Capo)\ **Replies:** 0\ **Last updated:** [August 2, 2023, 6:05pm UTC](https://community.cdata.com/t/error-message-code-500-could-not-execute-the-specified-command-unknown-datatype-unique-identifier/307 "2023-08-02T18:05:43Z")
Example scenario: declare @id uniqueidentifier = ‘123’ SELECT AccountId FROM \[CData\].\[dbo\].\[Test\] a WHERE a.AccountId = @id The driver is avoiding this process since the conversion is not supported in SQL … --- ## [‘Client unable to establish connection’ Error](https://community.cdata.com/t/client-unable-to-establish-connection-error/292)
**Author:** [@Orges\_Muzhaqi](https://community.cdata.com/u/Orges_Muzhaqi)\ **Replies:** 0\ **Last updated:** [July 26, 2023, 8:48pm UTC](https://community.cdata.com/t/client-unable-to-establish-connection-error/292 "2023-07-26T20:48:42Z")
“Client unable to establish connection because an error was encountered during handshakes before login. Common causes include client attempting to connect to an unsupported version of SQL Server, server too busy to accep… --- ## [CData SQL Gateway isn’t opening after being opened once](https://community.cdata.com/t/cdata-sql-gateway-isn-t-opening-after-being-opened-once/240)
**Author:** [@anonymous](https://community.cdata.com/u/anonymous)\ **Replies:** 0\ **Last updated:** [July 11, 2023, 5:08pm UTC](https://community.cdata.com/t/cdata-sql-gateway-isn-t-opening-after-being-opened-once/240 "2023-07-11T17:08:30Z")
CData SQL Gateway runs as a background process, as to ensure that the connection between the ODBC driver and your instance of SQL Server isn’t closed prematurely. When you exit out of the window of SQL Gateway, it closes… --- ## [User Defined Views missing from linked server](https://community.cdata.com/t/user-defined-views-missing-from-linked-server/103)
**Author:** [@Elizabeth\_G](https://community.cdata.com/u/Elizabeth_G)\ **Replies:** 1\ **Last updated:** [March 24, 2023, 6:11pm UTC](https://community.cdata.com/t/user-defined-views-missing-from-linked-server/103 "2023-03-24T18:11:23Z")
I created some User Defined Views for my ODBC driver, but when I use the driver with a linked server, I can’t find them anymore. Is there a way to access them? --- ## [Can't open CData SQL Gateway anymore](https://community.cdata.com/t/cant-open-cdata-sql-gateway-anymore/35)
**Author:** [@anonymous](https://community.cdata.com/u/anonymous)\ **Replies:** 1\ **Last updated:** [March 17, 2023, 7:56pm UTC](https://community.cdata.com/t/cant-open-cdata-sql-gateway-anymore/35 "2023-03-17T19:56:37Z")
I’m trying to use the CData SQL Gateway tool to create a connection between the CData ODBC driver and SQL Server. But after I closed the window, I can’t seem to open it anymore. How do I open SQL Gateway again after clo…