# \#linked-server **URL:** https://community.cdata.com/tag/linked-server/94.md [Latest](https://community.cdata.com/latest.md) · [Categories](https://community.cdata.com/categories.md) · [Tags](https://community.cdata.com/tags.md) --- ## [Creating Linked Servers in AWS RDS for SQL Server (Without the SSMS UI)](https://community.cdata.com/t/creating-linked-servers-in-aws-rds-for-sql-server-without-the-ssms-ui/1258)
**Author:** [@Mohsin](https://community.cdata.com/u/Mohsin)\ **Replies:** 0\ **Last updated:** [January 9, 2026, 11:30am UTC](https://community.cdata.com/t/creating-linked-servers-in-aws-rds-for-sql-server-without-the-ssms-ui/1258 "2026-01-09T11:30:25Z")
AWS RDS for SQL Server simplifies backups, patching, and high availability, but its managed model restricts certain administrative actions — including creating linked servers through the SSMS UI. If you see errors like “… --- ## [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… --- ## [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 … --- ## [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… --- ## [Slowness & Latency Using SageIntacct ODBC Driver](https://community.cdata.com/t/slowness-latency-using-sageintacct-odbc-driver/369)
**Author:** [@lwhieldon](https://community.cdata.com/u/lwhieldon)\ **Replies:** 0\ **Last updated:** [August 30, 2023, 7:09pm UTC](https://community.cdata.com/t/slowness-latency-using-sageintacct-odbc-driver/369 "2023-08-30T19:09:24Z")
I have deployed CDATA Sage Intacct ODBC Driver on an Azure Virtual Machine that also hosts a SQL Server for which we want to copy data from Sage Intacct to table(s) on SQL Server. I have set up my environment 2 ways desc… --- ## [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… --- ## [User Defined Views missing from linked server](https://community.cdata.com/t/user-defined-views-missing-from-linked-server/261)
**Author:** [@Elizabeth\_G](https://community.cdata.com/u/Elizabeth_G)\ **Replies:** 0\ **Last updated:** [July 14, 2023, 2:37pm UTC](https://community.cdata.com/t/user-defined-views-missing-from-linked-server/261 "2023-07-14T14:37:19Z")
Due to the way that the catalog and schema are used in a linked server, only one schema can be accessed at a time. As User Defined Views are also stored in a different schema, which by default is named UserViews, they ar… --- ## [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?