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 ?
ODBC for Shopify taking EXTRAORDINARY TIME TO LOAD
We have an ODBC Connector for both Mailchimp and Shopify. when pulling the data in it is taking upwards of 20 hours top pull a dataset with roughly 350,000 records.. Is this normal for this ODBC driver to take this long? is there a way to fix or help
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:
ODBC DRIVER FOR XBASE ERROR
HELLO IM TRIYING TO CONNECT TO THE DE .DBF FILES OF MY ERP. BUT IM GETTING THE FOLLOWING ERROR IN POWER BI: DataSource.Error: ODBC: ERROR [HY000] [Devart][ODBC][xBase]table CLIENTEAC already exists Detalles: DataSourceKind=Odbc DataSourcePath=dsn=TRY
DevArt ODBC Driver for NetSuite 3.00.01 Reports 'SuiteTalk endpoint version 2016_2 is no longer supported'
We had the ODBC connection working fine and returning data. Now the connection is returning the error: > SuiteTalk endpoint version 2016_2 is no longer supported A few weeks ago, we seemed to resolve the issue by upgrading the driver version to it's current
ODBC for DBASE
hi, i dont see an option to imply a decryption key, dbf databases are encrypted, is here a function to be able to access them ? Thanks a lot.
Error when writing to database
Driver does not support this function State:IM001, Native:0.Origin: [Microsoft][ODBC Driver Manager] even though we purchased and applied the license, when we attempt to use it to write to our database it connects perfectly but we keep getting this error
ODBC PostgreSQL: Data Source Error "Object not found"
Hi Community We use the DevArt ODBC PostgreSQL Connection on a daily base in order to connect Microsoft Excel directly to our Postgre-DB. All has been working fine until a few days ago. If I try to use an existing connection or create a new one, regardless
Arabic language
Hey devart The ODBC you present is very useful but when I'm useing it on microsoft access I found that arabic language apears as question marks like "حسين" apears "؟؟؟؟" so how can I make your ODBC support arabic language Thank you
Use Devart ODBC to retrieve and store Quickbooks access token
Hello, Is it possible to retrieve the access token that the ODBC connection uses? I was thinking I could use SQL Server Agent or other service to retrieve the access token and create 1x1 table with its value. Thank You for the help!
[DEVART][ODBC][PostreSQL]Trial period is expired
hi, last year i tried devart odbc driver for postresql on a server with windows2012 R2, it was for a POC with an instance postressql for test. now i want to industialise solution and before buy devart odbc driver, i want to try access on the same but
[Devart][ODBC][Adaptive Server Enterprise]Invalid activation key ??Trial version
hello, We have successfully installed and efficiently configured Devart on our iMac M1 with the latest operating system, Ventura 13.4. As we opted for the trial version, we encountered a minor setback during a connection test—a vexing error message appeared:
Slow connection using Dbeaver and ODBC <> BigCommerce Connection
We're looking for a solution to connect to BC using ODBC for my team. We managed to get the connection working but its unbelievably SLOW. Like 2-3 minutes for a select statement. We have enterprise BC so we shouldn't have any rate limiting issues, is
Devart SSIS Data Flow Components for Salesforce trial was expired
Good morning, We have several SSIS that stopped working after a month. We have the Devart license working in our computer using Visual Studio, but when we execute the SSIS from the server, it is throwing this error: "Tarea Flujo de datos:Error: There
[ASE] Error on connection: Finally we got Status param!!! Analyze it.
Hi everyone, I'm currently trying to connect to a ASE Sybase database running on version 17.0.10.5963. I've installed the devart ASE driver as version 3.3.0. When trying to connect with different connection strings from Python, C Sharp and when testing
Firebird ODBC devartodbcfireird.dll access violation
Hi, I need to update my 2 servers with ODBC for V4 of Firebird. When I test on my workstation running Windows 11 Home, I have success. When I install and run on both Windows Server 2008 64bit and Windows 2012 64bit, they both get the same access violation
OLAP Connection to Azure Analysis Services Data Cube on macOS
On Windows we're successfully connecting an Excel pivot table to an Azure Analysis Services data cube using Excel's built in functionality. It generates the following connection string: OLEDB;Provider=MSOLAP.8;Persist Security Info=True;Initial Catalog=***;Data
What is Query API for and what does SQL_ATTR_MAX_ROWS allowing you to do? I have ZOHO CRM
What is Query API for and what does SQL_ATTR_MAX_ROWS allowing you to do? I have ZOHO CRM
Mac DevArt -> Postgres connectivity issues
I've attempted to connect using the Devart Mac to Postgres driver. I've followed the instructions in the documentation. Upon hitting the test connection button I'm met with the error invalid activation key: I just downloaded the trial version on Friday
SOQL Query Syntax Issues
Trying to get all fields from our ACCOUNT table limiting it by 200 and getting an error in SSMS. Syntax: SELECT * FROM OPENQUERY(XXXX,'SOQL:SELECT FIELDS(ALL) FROM Account LIMIT 200') (where XXXX is the Linked Server) OLE DB provider "MSDASQL" for linked
MSSQL Managment Studio can link to Zoho CRM, I can see all the tables but I cannot access the fields
On the 2 ends Zoho and MSSQL I am the administrator with full privileges. -- [ZOHOCRM].[default]..[Users] contains no columns that can be selected or the current user does not have permissions on that object. GO Please see attached document.
Zoho CRM ODBC error when trying to update Subform
I am trying to update the values in a subform. The subform data is in a string field of the primary form's table, formatted as a JSON array of objects -- each object being a row of the subform table. When trying to modify the field via an Update query,
SOQL Queries with Salesforce ODBC Driver
Hi, I have connected the ODBC driver as a linked server in MS SQL Server and can read/write Salesforce data. Is there a way to issue a SOQL query directly to Salesforce from SQL Server using the ODBC driver or does one have to rely on the ODBC driver
Why should I buy Devart ODBC for SQL Server when I can get the MS equivalent for free?
Hi guys. I would be interested in purchasing the Devart ODBC driver for SQL Server, but I can't see it has a real advantage over the MS equivalent. Indeed, the server version price will raise from May 15th. Please, would you make it clear for me what
ODBC for Firebird: Problem with case sensitive table and field names
Hi, We've downloaded the trial version of the ODBC driver for Firebird. We are using Firebird 4. We are interested in purchasing the ODBC driver for Firebird, but it depends if the problem that we are seeing can be fixed. We are testing PowerBI with the
missing compatible file : libdevartodbcase.2.1.4.dylib
Hello, we installed odbc driver for sybase 2.1.4 on macos M1 bigsur 11.6 and the error below is generated when trying to connect excel to sybase DSN : Could you please help us with this urgent issue Thanks in advance for your attention Kind regards,
I can't update my ODBC driver in MS Server 2012 R2
It doesn't let me install a new version.
MySQL ODBC Driver SSH Connection with keys
I'm probably being pretty inept here, but I'm banging my head against the wall trying to get this to work. I'm able to setup an ODBC connection using the SSH tab (under the security tab) if I enter the server IP address, the username and the user password.
TOP N query to Salesforce returning all records
Any ideas why the single table select query with TOP N would return ALL rows, while using a join (second query below) will limit to 100 returned rows? SELECT Top 100 c.Name, c.Email FROM [SALESFORCE]...Contact c SELECT Top 100 c.Name, c.Email, a.Name
ODBC driver conenction to excel power query. Access to REST API is restricted by iTheme Security settings
HI, any help with this please?
Salesforce ODBC SQL Server linked server not able to browse catalogs/tables in SSMS, but can query them
I'm not sure we have our linked server security setup correctly - our Salesforce user seems to be working correctly as we can query data from various tables, but our SQL Server linked server (using Salesforce ODBC driver) is not allowing us to browse
SProcs using ODBC for QurickBooks
I'm trying to execute a sproc via a trigger to create a record in QuickBooks.... I'm getting "OLE DB provider "MSDASQL" for linked server "BT_QB" returned message "[Devart][ODBC]Optional feature not implemented". Doesn't the ODBC drivers for QuickBooks
Firebird ODBC driver can't open table using with BDE on Delphi11.2
When open database I tested Firebird ODBC driver using with BDE on Delphi11.2. I get error when openning TTable, "Dynamic SQL Error. Column unkown ID at line 1, column 8." I create database on Firebird 3.0.10, then create OBDC DataSoure using ODBC administrator
BigQuery ODBC driver | Data truncation
Hello, My company has recently purchased and installed the ODBC Driver for Google BigQuery. We are pushing data from BigQuery into a SQL Server database. It is working well for small datasets, however when we try to query for large datasets (e.g. 2 million
Inconsistent metadata - Connecting to Firebird from SQL Server Management Studio using ODBC Driver for Firebird
We have a Firebird 3.0.8 database we want to add as a linked server to SQL Server Management Studio. We downloaded the 'ODBC Driver for Firebird 3.3' and created a ODBC Data-Source: The database used in this test is a clean firebird 3.0.8 database with
Setup Linked Server in MSSQL Server with ODBC MySQL driver
Hi, currently I'm trying to setup a linked server connection in Microsoft SQL Server 2019 to access a MySQL Database via the ODBC driver. I've followed Connecting SQL Server Management Studio to MySQL via ODBC (devart.com) & Windows DSN Configuration
Next Page