The tag has no usage guidance.

learn more… | top users | synonyms

24
votes
10answers
263k views

How do I get this SQL Server ODBC Connection working?

Note: I've obviously changed the server names and IPs to fictitious ones. Here's what's going on. I've got a server, which I'm calling MYSERVER, running Microsoft SQL Server Express 2005. Right on ...
9
votes
1answer
24k views

Create a ODBC connection from file .bat at Windows

How to can create a ODBC DSN connection from file .bat at Windows? ¿ Is possible ?
7
votes
7answers
70k views

Remote MySQL connection fails (10060)

When I am trying to connect to a MySQL database from a remote computer I get a prompt saying: Connection Failed: [HY000] [MySQL][ODBC 5.1 Driver]Can't Connect to MySQL server on 'XXX.XXX.XX.XX' (10060)...
4
votes
3answers
5k views

ODBC: trouble removing system DSN

I have a colleague who has two DSNs with the same name - one's a user DSN and the other, a system one. He removed the user DSN but can't remove the system DSN in ODBCad32 Anybody encountered this ...
4
votes
2answers
4k views

How do I install Informix ODBC on Windows Server 2003/2008?

I installed the Informix Client SDK on my PC (32 bit) and on the server. I could create an ODBC connection on my PC easily, but on both Windows 2003 and 2008 (64 bit) I can't. I don't know if there ...
4
votes
1answer
1k views

32bit ODBC Postgres driver on Windows 2008 R2 x64

I'm trying to install the Postgres ODBC 32bit driver on a Windows 2008 R2 64bit machine. After installing it, with no errors, I go to the ODBC panel, the 32bit version under the /syswow64 folder and ...
4
votes
3answers
1k views

What is the difference between running a Windows service vs. running through shell?

I am trying to troubleshoot an issue on a Windows 2008 server where running attempting to connect to a "Timberline Data Source" ODBC driver crashes if the call is in a "service" context, but succeeds ...
3
votes
2answers
14k views

Unable to Create System DSN

Environment: Windows 7 Professional 64-bit Operating System Problem: (ODBC Data Source Administrator) Opening Administrative Tools -> Data Sources (ODBC) -> Click "System DSN" tab. Error: ODBC ...
3
votes
3answers
11k views

Lotus NotesSQL Driver - cannot install

I need to install Lotus NotesSQL Driver (current version is 8.5) onto a virtual machine running XP. Here's what's I've done so far: I retrieved the file (CZOWFEN.zip) from the IBM website. I ran the ...
3
votes
1answer
227 views

Windows 7 WMI ODBC driver installation?

I am interested leveraging the ease of report production provided by Microsoft SQL Report Builder, but I would like WMI as an available datasource. Since SQL Report Builder relies only on SQL, I ...
3
votes
2answers
165 views

for-free installation of php-mssql and dependencies

Problem: trying to install RPMs for RedHat EL, php-mssql. There does not appear to be a free open-source option for connecting to MSFT SQL Server database. Has anyone had any luck with this?
3
votes
3answers
3k views

Windows 2003 ODBC Issues - Error 10055

Using data integrator for ETL's pulling data from DB2 to SQL Server, after some time, will get these odbc errors: Communication link failure. comm rc=10055 - CWBCO1003 - Sockets error, ...
3
votes
1answer
53 views

What kind of file and folder permissions are necessary for ODBC?

In our network, we are using an application that connects to an *.mdb access database through ODBC (User DSN). The mdb is based on a subfolder of a share that is locally mapped to W: What kind of ...
3
votes
1answer
2k views

Native SQL Server connection vs ODBC?

What is the difference between native SQL Server connection and ODBC? What are the benefits when using native SQL Server connection?
2
votes
2answers
285 views

Sharing SSH port tunnel with local network

I've successfully created a SSH tunnel to our cloud postgresql server on a local linux server, with this command: ssh -N -f -L 5431:localhost:xxxx mycloudserver.com (where xxxx is remote port) ...
2
votes
1answer
2k views

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 ...
2
votes
1answer
13k views

Cannot create Oracle ODBC source on 64bit Windows 7 [closed]

I have installed the 64-bit version of the Oracle ODBC driver (instantclient-odbc-windows.x64-12.1.0.1.0 from http://www.oracle.com/technetwork/topics/winx64soft-089540.html) on my 64 bit Windows 7 ...
2
votes
6answers
5k views

Why am I getting this 500 error from IIS?

I'm running PHP 5.3.1 on IIS 7.5 on Windows 7 Ultimate x64. I've been trying to make PHP connect to my local installation of SQL Server 2008 Express over ODBC using ADODB. At first I had trouble ...
2
votes
1answer
154 views

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 ...
2
votes
2answers
6k views

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 ...
2
votes
1answer
2k views

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 ...
2
votes
3answers
10k views

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 ...
2
votes
1answer
159 views

IBM's iSeries ODBC driver not sending any traffic when invoked via isql or otherwise, getting [08S01][unixODBC] and [ISQL]ERROR: Could not SQLConnect

Note: I've replaced IP addresses, database names, and server users with examples. That shouldn't affect anything. The Setup I've installed unixODBC (yum install unixODBC) and IBM's official ...
2
votes
2answers
323 views

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 ...
2
votes
0answers
191 views

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 ...
2
votes
0answers
391 views

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 ...
2
votes
0answers
445 views

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 ...
2
votes
0answers
359 views

System.Data.Odbc.OdbcConnection.Open() takes a second for every db call

My experience is with LAMP stacks and not so much with .NET on Windows, but I've been given the task of trying to debug a slow site and I've run into a dead end after Googling everything I can think ...
2
votes
0answers
638 views

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 ...
2
votes
0answers
157 views

Increase 32K BLOB limit in Postgres ODBC [closed]

Is there a way to increase the limit of a BLOB field from 32K in Postgres ODBC driver?
2
votes
1answer
504 views

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 ...
2
votes
1answer
3k views

ORA-12705: invalid or unknown NLS parameter value specified

I have a J2EE application hosted on JBoss on Linux. When I try to access the application, I see following error in the server.log file. ORA-12705: invalid or unknown NLS parameter value specified ...
1
vote
1answer
244 views

Managing mass SQL Server ODBC Changes when migrating to a new SQL Server

How do you manage changing out a SQL Server and updating all the clients that connect to it to point to the new server? If I have SQLSERVER1, then buy new hardware and call the new server SQLSERVER2 ...
1
vote
2answers
3k views

Windows Server 2003 - Are ODBC Data Sources set per-user?

When I'm logged into our Windows Server 2003 server, I don't see any ODBC Data Sources, but when a different user logs in (who doesn't have Administrative rights), they have a big list of ODBC Data ...
1
vote
2answers
2k views

how does odbc driver work?

I have an application hosted on jboss. use jdbc driver of oracle to connect to an oracle 10.2g database. Can anyone guide as to what happens when a session is established. Just trying to understand ...
1
vote
3answers
1k views

Is Access connecting to a remote Postgresql database via ODBC usable?

I currently have an MS Access application that connects to a PostgreSQL database via ODBC. This successfully runs on a LAN with 20 users (each running their own version of Access). Now I am thinking ...
1
vote
2answers
161 views

ODBCs by Application

I am familiar with ODBCs by system (system DSNs) and ODBCs by user (user DNSs). I want to have ODBCs by application. I want to limit the ODBC connections available to a specific application, GP 2010....
1
vote
1answer
1k views

Connect MS SQL server with Filemaker Pro using ODBC

I would like to connect to MS SQL server with running on Microsoft 2008 R2 Server to filemaker pro server 11 running on Mac server 10.6.8 using ODBC. HOw can i get to go about this? is there an easier ...
1
vote
2answers
5k views

ODBC (SQL Server): How do I turn on Multiple Active Result Sets(MARS) for a System DSN?

I need to turn on Multiple Active Result Sets for an ODBC data source, but I can not figure out how to set it. And the end of the wizard I see this in the configuration summary: Multiple Active ...
1
vote
2answers
7k views

Error creating ODBC connection to SQL Server 2008 Express

When creating a System DSN, I get the error: Connection failed: SQLState: '08001' SQL Server Error: 2 [Microsoft][SQL Server Native Client 10.0]Named Pipes Provider: Could not open a ...
1
vote
4answers
12k views

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 ...
1
vote
4answers
5k views

Is it possible to connect to a System DSN on remote machine?

We have a DSN on machine A that points to a DB on machine B. We have a machine C, that we want to be able to use that DSN on machine A...but we don't want to create the DSN on machine C. Is there a ...
1
vote
1answer
3k views

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 ...
1
vote
2answers
2k views

make microsoft access use TCP/IP instead of Named Pipes

I got a Microsoft Access database which is constantly trying to contact the corresponding Microsoft SQL Server using named pipes, even though only TCP/IP is available and the ODBC is configured to use ...
1
vote
2answers
487 views

What's needed to enable JDBC or ODBC to MySQL database?

I have a MySQL server on my Scientific Linux 6.2 system. Right now I know how to create a new database, and set up users. I need to setup LibreOffice Base to connect to the MySQL server, via either ...
1
vote
1answer
42 views

How to copy ODBC Composite data sources from one server to another?

Both servers are Windows 2008 R2 x64. I have tried exporting [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI] but it doesn't contain the actual data source configuration for a Composite 6.1 data source. ...
1
vote
1answer
67 views

Report all ODBC DSN on workstations in the network

In preparation for retiring SQL Server A (2005) and deploying SQL Server B (2012), I've discovered numerous Microsoft Office assets (Excel, Access) that connect via ODBC DSNs. Is there a method to ...
1
vote
3answers
23k views

How to connect an ODBC DSN to nondefault SQL Server instance on default port?

We are migrating an SQL Server 2000 database on one server to SQL Server 2008 R2 on another server. The client application use a User DSN to connect directly to the SQL Server on the internet. I have ...
1
vote
1answer
4k views

How to establish ODBC connection through ssh tunnel?

I have SSH access to an iSeries (DB2 Database) through a firewall. I am trying yo make queries to a db in the machine using ODBC. I have found several tables explaining what ports are used by the ...
1
vote
1answer
3k views

SQL Server ODBC Connection via Command Line

I need to create a number of ODBC connections to a MS SQL Server, the clients are mainly XP machines. The connection has to use SQL server authentication - is there a way to do this remotely via ...