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
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
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
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
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
To connect to Azure SQL Database using MFA (which is in SSMS as "Active Directory - Universal") Microsoft recommends and currently only has a tutorial on connec
I have a Laravel installation running on a Debian 9.9 server and PHP 7.4. I need to connect to a SQL Server database on a remote Windows server. I followed th
Consider a table defined by CREATE TABLE Example (id INTEGER) and an INSERT statement for adding tuples to Example, having a single quote in a SQL comment:
When I run $ odbcinst -j it prints unixODBC 2.3.7 odbcinst: symbol lookup error: odbcinst: undefined symbol: odbcinst_system_file_name How can I fix it? Acco
When I run $ python manage.py inspectdb --database=mssql_database I have the following error django.db.utils.Error: ('01000', "[01000] [unixODBC][Driver Manager
When I connect to a DB2 database via ODBC using the recently released R 4.2.0 the database appears to have no objects. Connecting to AWS has no such issues, and
Good day! I get this error: SQL STATE 37000 [Microsoft][ODBC Microsoft Access Driver] Syntax Error or Access Violation, when trying to run an embedded SQL s
I am working on an application that connects to a legacy database, Eloquence, through ODBC and SQL/R. I set up my server with UnixODBC and setup the drivers and
I have a huge dataset in SQL server, I want to Connect the SQL server with python, then use pyspark to run the query. I've seen the JDBC driver but I don't fin
I'm trying to make my analysis workflow more efficient connecting my SQL Server Database to R-Studio. What I do now? I develop my queries using MS SQL Managem
the last days I was trying to learn how to access mySQL databases via Java. I am able to load the driver and get a connection to the database ( at least I thin