Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [odbc]

179 questions
1
vote
5 answers

DSN, ODBC: How to create DSN using different windows account

Is there a possibility to create DSN (ODBC to SQL Server) using different Windows account than current coputer login account? I’m trying to create System DSN to SQL Server and I would like to create this connection using Windows authentication using…
atricapilla
  • 615
  • 6
  • 12
  • 15
1
vote
1 answer

Is it possible to create a linked server between the ServiceNow ODBC driver and an AWS/RDS SQL Server instance?

I have an internal .NET 7 web application that uses an MSSQL database hosted on Amazon RDS. I have a requirement to create a linked server to query data from a separate ServiceNow DB instance. The only way I can see to do this is: Install a new…
paulsm4
  • 280
  • 1
  • 12
1
vote
1 answer

Sql Server ODBC connection error Table access error

TSystem.Data.Odbc.OdbcException was unhandled Message: ERROR [42S00] [SmartWare Software][SmartWare ODBC Driver][ISAM]Table access error Just curious as to what usually causes this error, or how better to find out what is causing my error. Thank…
george9170
  • 149
  • 1
  • 10
1
vote
0 answers

How to optimize network throughput with AWS Redshift

I've read about the sslcompression ODBC option in PostgreSQL, which seems to have some artifacts left in Redshift. But, I'm unsure if it is supported at all, and documentation seems to show that sslcompression has been deprecated for security…
Appleoddity
  • 3,488
  • 2
  • 13
  • 33
1
vote
1 answer

Error: File home.asp Unexpected error. A trappable error (C0000005) occurred in an external object. Using ODBC Connector

How can I get my application pool to stop crashing on me? Background All was working well for many years, until I updated Windows 10 Pro to the suggested update Windows Feature Experience Pack. Current System: Edition Windows 10 Pro Version …
MeSo2
  • 254
  • 1
  • 3
  • 18
1
vote
1 answer

how to do a mass update of an ODBC system DSN?

What's the best way to do a mass update of an SQL Server ODBC system DSN (change the server name)? Group policy? A Login script? Something else? It's an Active Directory domain (windows 2003) with mostly Windows XP clients, but there are some…
Booji Boy
  • 295
  • 2
  • 5
  • 11
1
vote
1 answer

How i can install mariadb odbc connector on Ubuntu 20.04

How i can install mariadb odbc connector from sources https://github.com/mariadb-corporation/mariadb-connector-odbc? i tryed install by using this https://blog.sleeplessbeastie.eu/2018/01/08/how-to-install-and-configure-mariadb-unixodbc-driver/…
mocart
  • 121
  • 1
  • 5
0
votes
0 answers

How to login to MS SQL Server using Ubuntu OS & ODBC with disabled SQL Server Authentication and only accept Windows Authentication?

It is only part of my problem but technically, I am trying to access an SQL Server with disabled SQL Server Authentication using ODBC connection string in Ubuntu OS. I already tried to connect with SQL Server Authentication enabled and it is…
Rei
  • 23
  • 2
  • 7
0
votes
1 answer

SQL Server ODBC Driver

When I create a new ODBC data source, I'm offered 4 different controllers to access SQL Server: ODBC Driver 13 for SQL Server (Version 2017.140.1000.169) SQL Server (Version 10.00.17763.01) SQL Server Native Client 11.0 (Version…
Jordi
  • 101
  • 1
  • 4
0
votes
1 answer

Is there any way of backing up the ODBC drivers of a server?

I need to replicate the ODBC drivers from one environment to another located on other server, the one that has the drivers I want to backup is running Windows Server 2012 Datacenter and the other Windows Server 2016 Standard (in case it matters).…
Vladimir
  • 33
  • 1
  • 1
  • 6
0
votes
1 answer

Unable to Connect to SQL Server 2014 SP2 using the SQL Native Client 10

Attempting to connect using the SQL Server Native Client 10.0 Results in the below error: Client Unable to establish connection Shared Memory Provider: No Process is on the other end of the pipe. Forcing the connection to use TCP just changes the…
Rhys
  • 26
  • 4
0
votes
1 answer

MariaDB 10.2.9: Storage Engine 'CONNECT' not found when trying to map MSSQL table

I am running a MariaDB Galera cluster and am trying to access MSSQL from within MariaDB on the first node. I have done this in the past on SLES 12 SP2, this time I am trying to do the same on RHEL 7.3. Unfortunately, MariaDB says "Unknown storage…
PythonLearner
  • 1,032
  • 2
  • 12
  • 31
0
votes
1 answer

Powershell Get-ODBCDSN error - Timeout when waiting for another concurrent operation to complete

After some database issues the night before, multiple servers (separate from the database servers) are getting the following error when just running the 'Get-ODBCDSN' function from a powershell console: Get-OdbcDsn : Timeout when waiting for…
PlainJay
  • 5
  • 4
0
votes
0 answers

Simba ODBC driver (130) Unable to authenticate with Google BigQuery

When I trying to connect to BigQuery with Simba ODBC driver using service authentication, I have error (130) Unable to authenticate with Google BigQuery. But only on Windows Server 2012 R2. For development I using Windows 7 and same settings…
maximelian1986
  • 101
  • 1
0
votes
1 answer

Mysql Login wildcard not working on a single machine

I am trying to login into mysql on a pc and I just can't figure out what is wrong with it. The error: Acces denied for user 'username'@'xxx.xx.xxx.xx' There are 15-20 connections already made to this mysql server with the same user and the same…
Efekan
  • 171
  • 7
1 2 3
…
11 12