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]
ODBC 链接EXCEL 后出现数据错乱
2024年2月27日购买,前期一直使用适用版本,数据链接没有任何问题。购买后再次链接出现错误 。比如,表中数据为4.21,但链接过来后为3.85,数据毫无规律的错误。已经给贵公司发邮件,未得到回复。主页上也留言未回复,请论坛的工作人员尽快联系我。
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.
Not able to connect macOS DSN Configuration
I am trying to connect ODBC with my Excel (macOS DSN Configuration) . Getting the error message Authentication Failed.
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?
ODBC ASANA
I am currently trying out ODBC ASANA because I would like to use it with MSACCESS. However, I have noticed that I cannot write to the "projectID" field. Can you please explain why this is the case?
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 ?
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
Next Page