# \#ado.net **URL:** https://community.cdata.com/tag/ado-net/135.md [Latest](https://community.cdata.com/latest.md) · [Categories](https://community.cdata.com/categories.md) · [Tags](https://community.cdata.com/tags.md) --- ## [ADO.NET Provider for Snowflake does not show tables/views in Analysis Services Data Source View dialog](https://community.cdata.com/t/ado-net-provider-for-snowflake-does-not-show-tables-views-in-analysis-services-data-source-view-dialog/1219)
**Author:** [@kde84](https://community.cdata.com/u/kde84)\ **Replies:** 1\ **Last updated:** [October 21, 2025, 1:45pm UTC](https://community.cdata.com/t/ado-net-provider-for-snowflake-does-not-show-tables-views-in-analysis-services-data-source-view-dialog/1219 "2025-10-21T13:45:40Z")
I am test driving the ADO.NET provider for Snowflake to connect to data in Snowflake from Analysis Services in Multidimensional Mode. I follow the descriptions in the article. Connection to Snowflake succeeds but wh… --- ## [ADO.net Provider for Access and Charset](https://community.cdata.com/t/ado-net-provider-for-access-and-charset/1117)
**Author:** [@Mortensp](https://community.cdata.com/u/Mortensp)\ **Replies:** 3\ **Last updated:** [June 23, 2025, 3:56pm UTC](https://community.cdata.com/t/ado-net-provider-for-access-and-charset/1117 "2025-06-23T15:56:21Z")
I can’t get the connection string to work with charset ie. DataSource=myaccesdb;Charset=windows-1252; The connection is fine, but Charset has no effect. Has anyone solved this? --- ## [Error 406 on Execute Reader](https://community.cdata.com/t/error-406-on-execute-reader/1049)
**Author:** [@sallys](https://community.cdata.com/u/sallys)\ **Replies:** 0\ **Last updated:** [March 12, 2025, 4:37pm UTC](https://community.cdata.com/t/error-406-on-execute-reader/1049 "2025-03-12T16:37:46Z")
We are using the ADO.Net QuickBooks Online driver which we have used for many years. Recently we are no longer able to connect with the QBO Profit and Loss statement. We are able to connect with the Balance Sheet. The li… --- ## [How to download and use CData ADO.NET providers in Visual Studio for Windows](https://community.cdata.com/t/how-to-download-and-use-cdata-ado-net-providers-in-visual-studio-for-windows/1032)
**Author:** [@Dibyendu](https://community.cdata.com/u/Dibyendu)\ **Replies:** 0\ **Last updated:** [February 28, 2025, 9:29am UTC](https://community.cdata.com/t/how-to-download-and-use-cdata-ado-net-providers-in-visual-studio-for-windows/1032 "2025-02-28T09:29:44Z")
Hey CData Community! To download, install, and use CData ADO.NET providers to develop .NET Core apps in Windows, you can also use the NuGet package manager in Visual Studio. First, to manage NuGet packages, right-cli… --- ## [Edit Generated Schema Files](https://community.cdata.com/t/edit-generated-schema-files/747)
**Author:** [@Naomi\_Y](https://community.cdata.com/u/Naomi_Y)\ **Replies:** 0\ **Last updated:** [June 5, 2024, 7:59pm UTC](https://community.cdata.com/t/edit-generated-schema-files/747 "2024-06-05T19:59:21Z")
In this article, I will outline how to edit a newly generated schema file using our Connectors. This article will use our QuickBooks Online Power BI Connector as an example; however, this walkthrough is applicable to any… --- ## [“\[INVALID\_PARAMETER\] Invalid search query” error when trying to query NetSuite tables](https://community.cdata.com/t/invalid-parameter-invalid-search-query-error-when-trying-to-query-netsuite-tables/741)
**Author:** [@DylanO](https://community.cdata.com/u/DylanO)\ **Replies:** 0\ **Last updated:** [June 3, 2024, 7:19pm UTC](https://community.cdata.com/t/invalid-parameter-invalid-search-query-error-when-trying-to-query-netsuite-tables/741 "2024-06-03T19:19:10Z")
When using any of our NetSuite connectors, you may see the following error when trying to query a table: \[INVALID\_PARAMETER\] Invalid search query. Detailed unprocessed description follows. Search error occurred: Field ‘\<… --- ## [Generating log files on Azure Application Services](https://community.cdata.com/t/generating-log-files-on-azure-application-services/683)
**Author:** [@Bergi\_M](https://community.cdata.com/u/Bergi_M)\ **Replies:** 0\ **Last updated:** [April 5, 2024, 1:17pm UTC](https://community.cdata.com/t/generating-log-files-on-azure-application-services/683 "2024-04-05T13:17:10Z")
In this knowledge-base article, we will delve into the process of generating logs for an application that utilizes the CData ADO.NET connector and is hosted on Azure App Services. After developing our ASP.NET Core app… --- ## [“Object reference” error when editing the connection string in a deployed SSAS project in SSMS](https://community.cdata.com/t/object-reference-error-when-editing-the-connection-string-in-a-deployed-ssas-project-in-ssms/647)
**Author:** [@John\_G](https://community.cdata.com/u/John_G)\ **Replies:** 0\ **Last updated:** [March 1, 2024, 2:23pm UTC](https://community.cdata.com/t/object-reference-error-when-editing-the-connection-string-in-a-deployed-ssas-project-in-ssms/647 "2024-03-01T14:23:34Z")
When attempting to change the connection settings on a deployed SQL Server Analysis Services (SSAS) package in SQL Server Management Studio (SSMS), you may see an “Object reference not set to an instance of an object” er… --- ## [DataTable.Remove/Delete do not seem to be working ADO.NET Provider for Presto](https://community.cdata.com/t/datatable-remove-delete-do-not-seem-to-be-working-ado-net-provider-for-presto/556)
**Author:** [@rocketmaniac](https://community.cdata.com/u/rocketmaniac)\ **Replies:** 4\ **Last updated:** [December 12, 2023, 6:48pm UTC](https://community.cdata.com/t/datatable-remove-delete-do-not-seem-to-be-working-ado-net-provider-for-presto/556 "2023-12-12T18:48:55Z")
PrestoDataAdapter dataAdapter = new PrestoDataAdapter("SELECT \_id FROM hive.transactional\_schema.\[TableName\]", connection);dataAdapter.DeleteCommand = new PrestoCommand("DELETE FROM hive.transactional\_schema.cached\_repor… --- ## [UpdateCommand.Parameters have wrong value in ADO.NET Provider for Presto](https://community.cdata.com/t/updatecommand-parameters-have-wrong-value-in-ado-net-provider-for-presto/540)
**Author:** [@rocketmaniac](https://community.cdata.com/u/rocketmaniac)\ **Replies:** 4\ **Last updated:** [December 11, 2023, 9:31am UTC](https://community.cdata.com/t/updatecommand-parameters-have-wrong-value-in-ado-net-provider-for-presto/540 "2023-12-11T09:31:54Z")
Following the example code for Update, we have this against one of our Hive transactional datastores: PrestoDataAdapter dataAdapter = new PrestoDataAdapter("SELECT \_id, name FROM hive.transactional\_schema.\[TableName\]",… --- ## [“Unable to translate bytes \[...\] at index 0 from specified code page to Unicode.” error in .NET Core applications](https://community.cdata.com/t/unable-to-translate-bytes-at-index-0-from-specified-code-page-to-unicode-error-in-net-core-applications/549)
**Author:** [@Hesjona\_H](https://community.cdata.com/u/Hesjona_H)\ **Replies:** 0\ **Last updated:** [December 4, 2023, 9:21pm UTC](https://community.cdata.com/t/unable-to-translate-bytes-at-index-0-from-specified-code-page-to-unicode-error-in-net-core-applications/549 "2023-12-04T21:21:07Z")
In .NET Core applications, when handling data with a character set that is not bundled with .NET Standard, you may come across the following error message: “Unable to translate bytes \[..\] at index x from specified code p… --- ## ['Unknown datatype: JSON.' in ADO.NET Provider for Presto](https://community.cdata.com/t/unknown-datatype-json-in-ado-net-provider-for-presto/533)
**Author:** [@rocketmaniac](https://community.cdata.com/u/rocketmaniac)\ **Replies:** 1\ **Last updated:** [November 22, 2023, 8:14pm UTC](https://community.cdata.com/t/unknown-datatype-json-in-ado-net-provider-for-presto/533 "2023-11-22T20:14:29Z")
I’m getting the following exception when trying to run the following code. Does the driver support the Trino JSON type? I don’t see json referenced in GetResultTypeData method source. string sql = "SELECT \_id, CAST(ex… --- ## [How to add/enable header X-Trino-User for ADO.NET Provider for Presto](https://community.cdata.com/t/how-to-add-enable-header-x-trino-user-for-ado-net-provider-for-presto/531)
**Author:** [@rocketmaniac](https://community.cdata.com/u/rocketmaniac)\ **Replies:** 2\ **Last updated:** [November 21, 2023, 4:54pm UTC](https://community.cdata.com/t/how-to-add-enable-header-x-trino-user-for-ado-net-provider-for-presto/531 "2023-11-21T16:54:21Z")
I’m getting the following exception when trying to run the following code. Is there a way to enable or set the HTTP Header X-Trino-User? PrestoConnection connection = new PrestoConnection($"Server={\_configuration\["Trin… --- ## [Resolving SnowflakeException: "Object Does Not Exist or Operation Cannot Be Performed"](https://community.cdata.com/t/resolving-snowflakeexception-object-does-not-exist-or-operation-cannot-be-performed/503)
**Author:** [@Alba\_Trupja](https://community.cdata.com/u/Alba_Trupja)\ **Replies:** 0\ **Last updated:** [November 1, 2023, 8:26pm UTC](https://community.cdata.com/t/resolving-snowflakeexception-object-does-not-exist-or-operation-cannot-be-performed/503 "2023-11-01T20:26:46Z")
If you encounter the System.Data.CData.Snowflake.SnowflakeException with the message “\[500\] SQL compilation error: Object does not exist, or operation cannot be performed,” this article provides guidance on addressing th… --- ## [SSRS project with ADO.NET provider throws “An error occurred while loading the query designer ‘CData (provider name)’”](https://community.cdata.com/t/ssrs-project-with-ado-net-provider-throws-an-error-occurred-while-loading-the-query-designer-cdata-provider-name/492)
**Author:** [@Altin](https://community.cdata.com/u/Altin)\ **Replies:** 0\ **Last updated:** [October 26, 2023, 7:41pm UTC](https://community.cdata.com/t/ssrs-project-with-ado-net-provider-throws-an-error-occurred-while-loading-the-query-designer-cdata-provider-name/492 "2023-10-26T19:41:15Z")
This error could be thrown when you try to access the Query Designer mode in an SSRS project using our ADO.NET providers. The root cause of this error is a mismatch between the versions of SSRS assemblies set in your “de… --- ## [How to setup ADO drivers for Visual Studio (ADO.NET Odoo v23 example)](https://community.cdata.com/t/how-to-setup-ado-drivers-for-visual-studio-ado-net-odoo-v23-example/487)
**Author:** [@Andrew\_H](https://community.cdata.com/u/Andrew_H)\ **Replies:** 0\ **Last updated:** [October 24, 2023, 9:23pm UTC](https://community.cdata.com/t/how-to-setup-ado-drivers-for-visual-studio-ado-net-odoo-v23-example/487 "2023-10-24T21:23:38Z")
Close all instances of Visual Studio Download and install the driver: Download ADO.NET Provider for Odoo ERP. 30-Day Free Trial (cdata.com) .NET Framework (No-Code approach using the Server Explorer)- Navigat… --- ## [HubSpot ado.net connector](https://community.cdata.com/t/hubspot-ado-net-connector/470)
**Author:** [@mmaxell](https://community.cdata.com/u/mmaxell)\ **Replies:** 3\ **Last updated:** [October 20, 2023, 6:07pm UTC](https://community.cdata.com/t/hubspot-ado-net-connector/470 "2023-10-20T18:07:59Z")
Hi guys, I cannot get the companies and deals table to execute in the data ingestion phase. Anyone has experienced this before? The error I keep getting is: Executing table \[HubSpot\].\[Companies\]: failed with error: S… --- ## [“Access to the path '…/OAuthSettings.txt.lock' is denied.” error when using OAuth data sources](https://community.cdata.com/t/access-to-the-path-oauthsettings-txt-lock-is-denied-error-when-using-oauth-data-sources/452)
**Author:** [@Brajan\_Hasmeta](https://community.cdata.com/u/Brajan_Hasmeta)\ **Replies:** 0\ **Last updated:** [October 10, 2023, 9:27pm UTC](https://community.cdata.com/t/access-to-the-path-oauthsettings-txt-lock-is-denied-error-when-using-oauth-data-sources/452 "2023-10-10T21:27:44Z")
To demonstrate the problem, I will be utilizing CData Google Analytics JDBC and ADO.NET Drivers as examples. However, it is important to note that this error can occur in any OAuth data source. When trying to authentica… --- ## [ADO.NET connector not visible after installation in Visual Studio](https://community.cdata.com/t/ado-net-connector-not-visible-after-installation-in-visual-studio/443)
**Author:** [@kristinab](https://community.cdata.com/u/kristinab)\ **Replies:** 0\ **Last updated:** [October 6, 2023, 9:49pm UTC](https://community.cdata.com/t/ado-net-connector-not-visible-after-installation-in-visual-studio/443 "2023-10-06T21:49:44Z")
This knowledge base article addresses an issue commonly encountered by customers who are unable to see the data provider within Server Explorer in Visual Studio after installing the CData ADO.NET drivers. The article pro… --- ## [SSAS: Tabular and Multidimensional Models](https://community.cdata.com/t/ssas-tabular-and-multidimensional-models/412)
**Author:** [@jerodj-cdata](https://community.cdata.com/u/jerodj-cdata)\ **Replies:** 0\ **Last updated:** [September 22, 2023, 3:07pm UTC](https://community.cdata.com/t/ssas-tabular-and-multidimensional-models/412 "2023-09-22T15:07:37Z")
SQL Server Analysis Services (SSAS) allows you to build both tabular and multidimensional models. Tabular models support the relational model (model, tables, columns) of most data sources. Multidimensional models are Onl… --- ## [The type initializer for 'xxxxxxx.xxx' threw an exception](https://community.cdata.com/t/the-type-initializer-for-xxxxxxx-xxx-threw-an-exception/353)
**Author:** [@Drin\_Karkini](https://community.cdata.com/u/Drin_Karkini)\ **Replies:** 0\ **Last updated:** [August 23, 2023, 2:29pm UTC](https://community.cdata.com/t/the-type-initializer-for-xxxxxxx-xxx-threw-an-exception/353 "2023-08-23T14:29:35Z")
The error message “The type initializer for ‘xxxxxxx.xxx’ threw an exception” occurs in our ADO.NET connectors when referencing an incorrect Dynamic-link library (DLL) in your project. Typically, our ADO.NET drivers a… --- ## [The type or namespace name 'DriverNameConnection' could not be found](https://community.cdata.com/t/the-type-or-namespace-name-drivernameconnection-could-not-be-found/289)
**Author:** [@Luçjano\_Capo](https://community.cdata.com/u/Lu%C3%A7jano_Capo)\ **Replies:** 0\ **Last updated:** [July 26, 2023, 2:25pm UTC](https://community.cdata.com/t/the-type-or-namespace-name-drivernameconnection-could-not-be-found/289 "2023-07-26T14:25:54Z")
This error occurs when our driver’s file is missing from the References. In this example, I will be using Survey Monkey provider. To be able to use our ADO .NET for SurveyMonkey in Visual Studio follow these steps: Op… --- ## [How to download and use CData ADO.NET providers in Visual Studio for MacOS](https://community.cdata.com/t/how-to-download-and-use-cdata-ado-net-providers-in-visual-studio-for-macos/259)
**Author:** [@Silvio\_A](https://community.cdata.com/u/Silvio_A)\ **Replies:** 0\ **Last updated:** [July 13, 2023, 8:01pm UTC](https://community.cdata.com/t/how-to-download-and-use-cdata-ado-net-providers-in-visual-studio-for-macos/259 "2023-07-13T20:01:35Z")
To download, install and use CData ADO.NET providers to develop .NET Core apps in MacOS, you will have to make use of NuGet package manager. To manage NuGet packages, right-click on your solution’s name and navigate to … --- ## [CData Drivers - Getting Started (video playlist)](https://community.cdata.com/t/cdata-drivers-getting-started-video-playlist/146)
**Author:** [@Luc](https://community.cdata.com/u/Luc)\ **Replies:** 0\ **Last updated:** [April 5, 2023, 8:04pm UTC](https://community.cdata.com/t/cdata-drivers-getting-started-video-playlist/146 "2023-04-05T20:04:14Z")
Real-Time Data Connectors - Connect your BI, Analytics, ETL, & custom applications with any SaaS, NoSQL, or Big Data source. What is a Driver? Watch our short video to answer the question, “what is a driver?” and lear…