Any plans to create an ODBC driver for Xero?
Hi Just wondering if there is any plans in the works to create an ODBC driver for the Xero platform?
Define ClientID and ClientSecret in Dynamics365 ODBC DSN
Hello, how is it possible to store a ClientID and a ClientSecret in a Windows ODBC connection for the Devart driver in the ODBC Manager? I only see the option to generate a token, and I am then prompted to log in. However, I would like to create an app
XDBGrid sort function doesn't work
I'm using the XDBGrid sorting feature in FireDac, but it doesn't work in uniDac. If you have any solutions, please let me know. XDBGrid Designer -> Contrlo2 -> sortingControl
SOQL queries - field/column aliases not recognized and/or toLabel() function duplicate field errors
Currently running Devart ODBC Driver for Salesforce 3.4.1, set up as linked server in MSSQL 2019 (15.0.4405.4), and I don't seem to be able to use field aliases when running SOQL queries via an OPENQUERY statement. For example: SELECT * FROM OPENQUERY(PCCUSFPROD,
Skip exception
hi all ! I have the following code that returns a bool value. If there is no connection it should be false. The problem is that I always get the exception and get out of the program. Is there a way to avoid it? private static bool IsMariaDBServer(string
SOQL error: unexpected token: '('
I have a complex SOQL query that includes nested queries of child objects that works in the Salesforce workbench but fails with the error "OLE DB provider "MSDASQL" for linked server "SALESFORCE" returned message "[Devart][ODBC][Salesforce]Invalid SOQL:
Salesforce ODBC driver exceeded API Requests allowed
A few days ago we used more than the 249k API requests our Salesforce license allows within 24 hours using your Devart ODBC driver. I can see the current number next to the label "API Requests, Last 24 Hours" on https://*.lightning.force.com/lightning/setup/CompanyProfileInfo/home
Trial Period expired
Hello! We have been using the ODBC driver for SalesForce (SQL Server) for almost a year and it has started in the last 24 hours giving the trial period expired error. Our license is valid until 2026, has anyone experienced this before?
Error Connecting Through DSN
I'm trying to connect to Shopify through a 32-bit DSN in Windows 10, using the Devart ODBC driver for Shopify. The owner of the site created a custom app and gave it all permissions, and got an Admin API Access Token, which he shared with me. The Devart
Salesforce ODBC forgets about it's license every few months?
I own a valid license and am using it on a Windows 2022 Server running on AWS. It mostly works, but every few moths it seems the driver loses the license and I get errors like this when running queries through my Microsoft SQL linked server setup: ```
UniDac with Quickbooks QODBC - Enterprise
I am trying to use the QODBC driver to create a "simple" report for Positive Pay for the bank using Delphi, UniDac, and QODBC. I can connect to the QB DB, but opening the BillPaymentChecks table only returns ONE record. Presumably the top/first record.
Salesforce ODBC - null-able columns marked as not null?
Your ODBC driver reports some columns as not null-able and then sends rows containing null values for them: Calendar.Name DuplicateRule.Language EntityDefinition.LastModifiedById FeedComment.HasEntityLinks FlowDefinitionView.LastModifiedDate Folder.Name
Salesforce ODBC + MSSQL linked server - select column metadata?
Via the CLI tool `isql` I was able to retrieve column metadata using the "HELP TableName" command / query, but trying to send the same query via MSSQL linked server only produces an error: SELECT * FROM OPENQUERY (SF_LINKED_SERVER_NAME, 'HELP Account')
Can't create a new SSIS Connection Manager
The connection type "DevartSqlServer" specified for connection manager is not recognized as a valid connection manager type. This error is returned when an attempt is made to create a connection manager for an unknown connection type. Check the spelling
Salesforce ODBC - How to work with *ChangeEvent tables?
Hi there! We've recently bought our Devart Salesforce ODBC license and set it up so we can query our Salesforce via Microsoft SQL LinkedServer. I've now seen that nearly every Object has an additional ObjectChangeEvent table and I was wondering how we
woocommerce - unauthorized
Hello, We've just installed the Woocommerce ODBC driver, configured it with domain name, customer key and customer secret, but we keep getting the following error message The remote server returned an error 401 : unauthorized The same credentials work
SQLite data access issue
I have successfully installed the Devart SQLite ODBC driver and I can connect to the SQLite database using MS Access. I can update data and delete rows but I am having 2 issues I hope you can help me with. · I am unable to add new rows to any SQLite table
Issue with Dynamics ODBC
Good morning, We've a recurrent issue with this ODBC...every 2 weeks - more or less - we're not able to use it due to this error: We bought a full license months ago. We've tried several times what you suggested on previous communications: remove the
OperationalError: Trial period has expired
Hi guys! I'm trying use devart.ase lib for python (3.10) and i get this message: "OperationalError: Trial period has expired." Is this lib free for use? if not, how much is? and how can i get a valid license? Thank you in advance
GetDate() error for Dynamics ODBC Driver
I'm getting an error message when I use GetDate() in a SQL query I'm writing using the ODBC driver. Basically I only want to pull records created today. Has anyone run into this issue and found a work around? Thanks
ItemInventory missing custom fields in QuickBooks Desktop
I'm trying to select from ItemInventory with a python script and I'm finding that the table structure is different, when I use the DevArt driver rather than the QODBC driver. Particularly, the custom fields are missing. I'm not seeing any settings in
ODBC Driver for BigCommerce
We are currently evaluating the ODBC driver for BigCommerce 2.4. Our products table in BigCommerce Enterprise has 500,000+ records and would like to query it. We are using a criteria in our query to display 1 product or 1 SKU but it doesn't show up (or
Connecting to PostgreSQL or MSSQL Using Oracle Database Link and ODBC Driver
I want to connect PostgreSQl and MSSQL in Oracle using dblink. I do everything from this page https://docs.devart.com/odbc/postgresql/oracle_dblink.htm and it doesn't work. Please help
Concurrency violation when updating SQLite database using DevArt ODBC Driver
Hi, I'm trying to debug errors produced when updating an SQLite database using the DevArt ODBC Driver from a Win32 application. I'm using COM/MSADO in C++ to interface with the Microsoft OLE DB Provider for ODBC Drivers, which in turn uses the DevArt
Magento ODBC Driver with Filemaker
I am trying to use the Magento ODBC driver with Filemaker, but this is totally useless. My first try was the category DB which has something like 100 records. And this worked fine, after about 10 seconds the table was available. Of course that is still
ERROR: devart_ase_connector-1.0.1-cp37-cp37m-manylinux_2_34_x86_64.whl is not a supported wheel on this platform.
Guys, I'm trying to install the "Python Connector for ASE 1.0 - Python 3.7 for Linux" library on Linux and I ended up coming across the following message: ERROR: devart_ase_connector-1.0.1-cp37-cp37m-manylinux_2_34_x86_64.whl is not a supported wheel
Problem with Firebird ODBC on Ubuntu
After setup and running isql -v DEVART_FIREBIRD I get: [S1000][unixODBC][Devart][ODBC][Firebird]Cannot load library: libcrypt.so [ISQL]ERROR: Could not SQLConnect Here is my setup [ODBC Data Sources] DEVART_FIREBIRD=Devart ODBC Driver for Firebird [DEVART_FIREBIRD]
Insert into Sybase: The token datastream length was not correct. This is an internal protocol error.
I'm trying to insert data into a Sybase table, with Python, (with one column) through a procedure and I'm getting this error message. "The token datastream length was not correct. This is an internal protocol error." Below is the code I'm using: my_cursor
Salesforce ODBC driver - select from ContentDocumentLink slow buggy
Hello! I am running this simple query in SSMS via a linked server against the ContentDocumentLink table. It its not only EXTREMEMLY slow, bit it does not respect the LIMIT clause and keeps slowly pulling more records into the output window maybe 30 seconds
Salesforce ODBC - Update Record
Whats the best way to update a record in salesforce using the ODBC driver? I have this setup as a linked sever in SQL Server Management Studio, and would like to update a salesforce record from a local table.
Remotely connect to xBase ODBC driver from an external service
Hi, I'm wanting to connect an ETL (Azure Data Factory) to a FoxPro database on an on-premise server. I see that some of your ODBC drivers provide connection options like port etc, but the xBase one doesn't. Does that mean that there's no way to connect
ODAC TOraQuery cannot popup window to enter SQL query
My environment is: Delphi 10.2 and C++Builder 10.2 Update 3 Devart Oracle Data Access Components 11.1.3 While I add a TOraquery to a form, and then in Object Inspector I click on SQL trying to bring up the editor window. Delphi dies. What I can do is
How to move to a new computer?
I need to move the QuickBooks ODBC driver to a new computer. What is the process to do that?
WooCommerce connection to the ODBC driver
I want to control the data on my WooCommerce site using Microsoft Access. I installed the OCDB driver and I don't understand how to proceed further. I guess I know how to connect Access to the driver, but I don't understand how to connect the driver to
PYODBC sample code for Devart & QuickBooks Online
I am just starting to work with Devart (moving from QODBC). I am using PYODBC with Python and QBO. I am looking for some sample code for queries particularly journal entries. Surely someone else besides me is doing this, but I am not able to find any
Connecting to QBO Sandbox
I am working with the trial and just setting things up. I can connect to the Live QBO environment but when I try to connect to the Dev environment (sandbox) I get the following error. I do have a sandbox account under the same userID as my prod account.
Salesforce ODBC driver "unexpected NULL value" error if Name column NULL?
I am using driver version 3.3.0 17-Aug-23. When I try to select the Name column from the Calendar object and the Name column is NULL, the driver gives me the following error. SELECT * FROM OPENQUERY ([SF_CPQ_PROD],'SELECT Id, Name FROM Calendar'); An
Problem when adding new Linked Table (from DEAR to MS Access) using DEVART ODBC
I have two linked tables already in the database. These were added in an earlier version of MS Access. However, when I add another linked table it comes up with #Deleted# in every field and record. I use the same ODBC driver and have the same linked Table
ODBC Driver for Oracle - Oracle Cloud
The connection to Oracle cloud is not successful. What is wrong / missing ?
Trail Period has expire, but I updated the license key and Still Fails
Trail Period has expire, but I updated the license key and Still Fails. TITLE: Microsoft SQL Server Management Studio ------------------------------ The test connection to the linked server failed. ------------------------------ ADDITIONAL INFORMATION:
Next Page