Category "odbc"

MS Access ODBC Connection error - "cannot define field more than once"

Does anybody have some insight on why the following error "cannot define field more than once" comes up in ms access when connecting MySQL tables via ODBC? The

Decoupling Win authentification, ODCB driver authentification and SQL authentification - ODCB auth error and DLookup error

I'm trying to connect a user to my company's postgreSQL Server to access a postgres database via MS Access 2019. Connection should be established via ODCB drive

SQL Update query via VBA using ODBC connection

I have an ODBC connection to a database set up in Control Panel using a DSN. I can use this to see data from tables and Views in Excel. What I need to be able t

How to store encrypted SecretAccessKey in registry for Redshift ODBC driver?

Ideally you create a ODBC DSN using the "ODBC Data Sources" UI. I am creating a Redshift Driver DSN(TestDSN) using Authentication Type "IAM Credentials" The se

Overflow operation when compiling using AnyCPU

I have a legacy solution written in VB.NET. It writes to a DB2 database using ODBC. I have a Textbox that is filled with a numeric value then I use ToString in

Export HANA SQL query or table in CSV

I use a HANA 2.0 database. I want to export a table or a sql query from the database to an external client as fast as possible and using a command line (i'm on

How to connect over sshtunnel to remote sql server with "2 jumps" in python

after days of research and fails with this problem. Context: I need to connect remotely from a python script to a remote database and I have the following restr

How to properly install pyodbc and drivers on M1 mac

I have a new M1 pro macbook and I'm trying to install pyodbc and relevant drivers on my machine. So far I have installed unixodbc via homebrew and ODBC drivers

Sequelize dialect dependency on msnodesqlv8

We are using sequelize package to connect to mssql server. Our backend code is in javascript. We have a working code like below: const sequelize = new Sequelize

C# ODBC driver with DBF database in parallel not working as intended

Hi everyone this is my last resort, i think I'm getting something wrong but can't get unstuck I was trying to load some old DBF files at startup to create my da

Failed to connect SQL Server from Node.js using tedious

I am trying to connect to SQL Server in our domain network. I am able to connect using python but not able to connect in Node.js using Tedious. Node.js code sni

MongoSQLd not starting on Windows

I'm very new user of Mongo and I'm trying to enable MongoDB connector for BI. I want to change my connect address, but it only connects to 127.0.0.1... I made a

Access database error in R (RODBC connection)

I'm trying to get data from an Access database by using the RODBC package, but I get this error: Error in sqlTables(c) : first argument is not an open RODBC cha

Django connect SQL Server using active directory user

I'm using Django and mssql-django backend to connect to SQL Server. No problems to connect to SQL Server when using sql login. But, when I try to connect using

Use external packages in eth-brownie?

I am trying open a ERC721 smart contract in Brownie on VSCode and loop through the token ids and set the URI of each in each iteration. I execute the script wit

Weird OleDbDataAdapter Fill behavior (hangs with explicit fields) on IBM i System

we're migrating our IBM i System from OS 6.0 to 7.4; we're testing all the applications which somehow connect and read/write data to it and we found a weird beh

How to Connect SQL Server to MySQL using Linked Server ODBC Connection

I'm trying to create a linked server from my SQL Server to a MySQL db. No matter what I do, I get the following error: Cannot initialize the data source object

cannot access Postgres views from SSIS thru ODBC PSQL driver

I'm working with Postgres from SSIS thru ODBC Unicode driver ver 13.01. 32-bit connection. I can successfully connect to all Postgres tables but can not able t

R ODBC DBI error: database does not exist

I'm working on a Mac and trying to connect to my remote Postgres database in R Studio. Error First, the error: Error: nanodbc/nanodbc.cpp:1021: 00000: FATAL: d

How to do a "Select * from" query using odbc

I'm using the odbc package in R, and I have an SQL Server database with a table that has a Name column that is nvarchar(max) and a PublishStatus column that is