Questions tagged [odbc]
172 questions
2
votes
3 answers
User cannot access a system DSN on Windows Server 2008
We run our SQL Server services using a low privileged domain account. That account is NOT a local admin on the OS. Only access I give the user account is assigned during install of SQL: full control over its mount points and then everything else is…
![](../../users/profiles/9826.webp)
Ra Osolage
- 173
- 2
- 2
- 10
2
votes
2 answers
Unable to Create MySql 64-bit System DSN on Windows
I have a very similar problem to "Unable to Create System DSN," but none of the fixes suggested there have worked for me.
System: Windows 7 64-bit Enterprise.
I'm trying to create a DSN to use accessing MySQL from powershell.
When I open up…
![](../../users/profiles/212746.webp)
sdjuan
- 211
- 2
- 16
2
votes
0 answers
Failover_Partner connection in file DSN not working
I have an application which uses file DSNs to connect to a central database server. This database server is mirrored onto a secondary server, and in the event of a failover, it is my understanding that adding a line in the file DSN…
![](../../users/profiles/222036.webp)
JJBurgess
- 41
- 3
2
votes
0 answers
doing ODBC System DSN's from Active Directory
2008R2 Active Directory, workstations are Win7 Ent, Office/Excel 2013, Oracle 11.2. Excel fetches data from Oracle using System DSN's.
Where can I put ODBC System DSN's in Active Directory? Do I need to do anything special to the Win7 / Excel 2013…
![](../../users/profiles/52874.webp)
user52874
- 819
- 2
- 10
- 25
2
votes
0 answers
Website loses connection to database intermittently
Every so often our website loses connection to the sql server and I receive the following errors:
"The following error: A network-related or instance-specific error occurred while establishing a connection."
"The following error: A transport-level…
![](../../users/profiles/180011.webp)
Nixon
- 21
- 2
2
votes
1 answer
Is it possible to increase the maximum pool size on an ODBC connection?
I have a server supporting a phone system of about 300 phones. When calls are made, many different connections are opened and closed during the course of a call. I'm starting to see "out of database connections" and "timeout expired messages" when…
![](../../users/profiles/2280.webp)
scottm
- 349
- 3
- 5
- 18
2
votes
0 answers
Restricting access through ODBC to only schema views SQL 2008
I'm pretty green to SQL security, so maybe someone can help me. We've got a database application that, when installed, by default grants the public role access to all the tables in the database. When you create an SQL user, it adds the user to the…
![](../../users/profiles/160456.webp)
user160456
- 21
- 3
2
votes
1 answer
Issue With Case Sensitivity on IBM Power server queries
Where I work, we have an IBM Power System that we use for data storage and access. It is currently running i OS 6.1. We have a website on an IIS server that pulls data from this server and has several different web apps that do different…
![](../../users/profiles/151077.webp)
SausageBuscuit
- 165
- 1
- 11
2
votes
0 answers
Increase 32K BLOB limit in Postgres ODBC
Is there a way to increase the limit of a BLOB field from 32K in Postgres ODBC driver?
![](../../users/profiles/1215.webp)
Joshua
- 779
- 1
- 9
- 18
2
votes
0 answers
Can you use SQLite 64 bit odbc from powershell
I have installed 64 bit ODBC driver for SQLite, downloaded from this page. I am running PowerShell version 2 on Windows 7.
In the ODBC configuration I create a system DSN with name LoveBoat, pointing to a valid file. I don't have any "real" apps…
![](../../users/profiles/123674.webp)
Levin Magruder
- 121
- 4
2
votes
1 answer
Is TCP/IP required to connect to SQL Server 2008R2 with ODBC over a LAN *NOT* the internet
I have read one two three related threads but im not clear if SQL Server 2008 needs TCP/IP to make this work. Can it not accomplish with a pipe? I would prefer not to open up the machine to the internet just to test my development machine Win7 and…
![](../../users/profiles/28079.webp)
Mike Trader
- 179
- 1
- 5
- 19
2
votes
1 answer
Need help making an ODBC MySQL Connection
Short Version:
How do I connect from PowerShell to an ODBC 5.1 MySQL Driver? I can't seem to find any connection strings that accurately have a "Provider" field for this particular instance. (See bottom of this question for…
![](../../users/profiles/85261.webp)
Andy Moore
- 121
- 1
- 4
2
votes
2 answers
How to configure Windows user accounts for ODBC network with NT authentication?
I'm trying to create a connection to an SQL Server database from the ODBC Data Source Administrator using "Windows NT authentication using the network login ID". Both server and client are running Windows XP.
It appears that any account with…
![](../../users/profiles/50020.webp)
Ian Mackinnon
- 183
- 2
- 15
2
votes
1 answer
Is ODBC on Windows 2003 slower than on Windows 7?
I am seeing some MSSQL 2005 performance issues, and I am trying to diagnose the cause. I am using SQL Profiler to gather query execution times. Both the client app (using ODBC), and the SQL server are running on Windows 2003. I am also using Windows…
![](../../users/profiles/17170.webp)
Nick Bolton
- 5,016
- 12
- 51
- 62
2
votes
1 answer
Built PHP from source with custom DataDirect ODBC drivers, but can't auto start with systemd
I need to build PHP from source in order to use this customer ODBC drivers. I've followed these inspections: https://www.progress.com/tutorials/odbc/using-php and everything (including the ODBC driver) works fine when I manually start apache with…
![](../../users/profiles/517157.webp)
Barry Ralphs
- 181
- 1
- 10