The tag has no wiki summary.

learn more… | top users | synonyms

3
votes
1answer
75 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 ...
0
votes
1answer
16 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 ...
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 ...
0
votes
2answers
356 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 ...
0
votes
1answer
38 views

Website can not connect to ODBC (no rights?) “Error: 80004005”

Background I am trying to migrate a website using MSSQL from MS Windows Server 2003 to a Server running MS WS 2008. It's been a while since I tried the last time (because I gave up on this problem) ...
0
votes
2answers
57 views

32bit ODBC++ dll on Windows 2008 Server 64bit

A client of ours is trying to migrate to 64 bit Windows. They haven't got an ODBC++ dll present and our solution linked against the version shipped with 2003 server (32-bit). However, when looking ...
0
votes
0answers
11 views

Log ODBC queries including execution times to solve performance issue

We are facing some Perdormance issue in out web aplication which uses an ODBC Connection, i would like to log running queries to analyse where the problem is, Is there any way to make ODBC log the ...
2
votes
1answer
297 views

Cannot create Oracle ODBC source on 64bit Windows 7

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

Client connectivity to MSSQL

I'm wondering if there is a policy that can be pushed that defaults a client to always dynamically determine the port for connectivity. I'm dealing with a custom C# application that connects to a ...
0
votes
2answers
41 views

Diagnosing sporadic MySQL fault

I have some C++ applications that access our MySQL database via unixODBC on Ubuntu 10.04. Once every few weeks for the last several weeks, I've seen this error appear in our error logs: ...
0
votes
3answers
2k 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 ...
0
votes
1answer
349 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
0answers
436 views

SQL Server 2008 R2 Express connection error

Hi I'm having issues with SQL connection for a client PC We have software that uses SQL database, and I have just updated from SQL2005 to SQL2008 We have 5 pcs: 2 x vista (32 bit) 2 x win7 (64bit) ...
0
votes
0answers
184 views

ODBC driver does not show up in the ODBC Data Source Adminstrator

We use an old Synergy database that is accessed through ODBC. No problems with the program we use to access the database, no problems accessing the data with Excel, Access, or Crystal Reports. I need ...
1
vote
2answers
3k 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 ...
0
votes
0answers
66 views

Installing Netezza 6.0.8 ODBC driver on Windows Server 2008

Below are four Netezza drivers that are available for Netezza 6.0.8. I installed the second one on Windows Server 2008, and it placed it into the system32 folder (64 bit folder). However, when I set ...
0
votes
0answers
478 views

[Microsoft][ODBC Driver Manager] Invalid string or buffer length (HRESULT: 80131500)

I am having an intermittent problem with a Spotfire Server accessing information models which connect to Microsoft Access databases via ODBC. The server is a Windows Server 2008 R2 64bit, we have ...
0
votes
0answers
100 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 ...
0
votes
0answers
79 views

SQL Server connection issue with ODBC Driver 11 for SQL Server

When creating a DSN's. I can create a DSN to our SQL Server (Windows Server 2003 with MS SQL Server 2005). With the SQL Server Native Client 11.0, however when i try to do the same thing with the ...
0
votes
2answers
243 views

Problem connecting to database after a RESTORE. SQL Server 2005 and Classic ASP

I have some Selenium test scripts which I'm using to test a Classic ASP web app, but I'm having problems after restoring the database (SQL Server 2005) with a backup file before every test is run. ...
1
vote
2answers
294 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 ...
2
votes
0answers
106 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 ...
0
votes
0answers
52 views

Proxy DMZ server to bounce data between sql server and clients

Is this feasible? I have a sql server that is setup behind a corporate firewall. I have clients that need direct connection to that sql server via ODBC. Instead of punching holes in the firewall I ...
2
votes
0answers
110 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
0answers
147 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 ...
-1
votes
2answers
1k views

Can't perform ODBC connection to MySQL server on local network

I have a wamp server running on LAN ip address 192.168.1.101 . From the browser on my PC which is on the LAN I can access the webserver and have as well set the phpmyadmin.conf file to be able to ...
-1
votes
1answer
106 views

SQL server ODBC connection for Active Directory user who doesn't log in to the windows

Do you think it is possible to create a SQL server ODBC Connection for an active directory user who doesn't log in into the windows. Ideally this type of users will be used in the batch process. So, ...
1
vote
0answers
65 views

How do I install linux ODBC driver for IBM iSeries?

Been following instructions here: http://www-03.ibm.com/systems/power/software/i/access/linux/guide.html Trying to install in CentOS instance after installing unixODBC. Installed all dependencies ...
4
votes
5answers
25k 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' ...
0
votes
2answers
236 views

PDO ODBC error just resets connection

Trying to write an ODBC PDO driver for CakePHP. Seems like I get closer and closer however whenever a PDO function is called that it doesn't like the connection just gets reset immediately and I'm not ...
0
votes
1answer
571 views

Listing ODBC Connections on Remote Machine

I'd like to connect to a Windows (XP & 7) machine remotely (command line or Powershell) & list the ODBC's installed on that machine, ideally I'd be able to list the server name/database setup ...
1
vote
1answer
383 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 ...
1
vote
0answers
359 views

Windows Server 2003 ODBC Drivers

I have ran into a problem with Windows Server 2003 and SQL Server 2005 using ODBC Drivers. Here is my following scenario. I have an application that currently uses ODBC System DSN's to connect to a ...
2
votes
1answer
87 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 ...
0
votes
2answers
4k views

ODBC Drivers Missing on Windows Sever 2003 64 bit OS

I am working on a Windows Server 2003 x64 bit OS. Under ODBC connections, I am seeing only "SQL Server" and "SQL native Client". I wanted to make a datasource for xls. I have already performed the ...
1
vote
1answer
509 views

Migrating ODBC information through a batch file

I am a desktop support technician currently working on a large scale migration project across multiple sites. I am looking at a way to transfer ODBC entries from Windows XP to Windows 7. If anyone ...
2
votes
3answers
6k 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 ...
1
vote
2answers
234 views

How do I automatically connect my client to an ODBC data source on another machine with dynamic IP?

At the customer's place, we've got a postgres DB on a server, and a few clients. We connect them through ODBC-drivers, and all machines run windows (usually XP). Now we had a few annoying issues: ...
0
votes
2answers
2k 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 ...
0
votes
1answer
187 views

Confused with creating an ODBC connection, apparently I have two separate odbcad32.exe files?

Alright, this is my first time working with this so forgive me if I'm a little confusing or vague. I have a server with Windows Server 2008 Standard without Hyper-v (6.0, Build 6002). I'm running a ...
0
votes
1answer
60 views

Local Db Data To Remote Db Data Connection

Ok guys I was approached by a client to create a web service that will allow users to sort through a bunch of proprietary data. This is all fine and dandy but the catch is, all of this data comes from ...
4
votes
3answers
414 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 ...
0
votes
1answer
371 views

Automatically reconnect to ODBC sources?

I am using Asterisk 1.8.10.1 and a MySQL database connected via ODBC to store CDRs. When my MySQL database isn't available when Asterisk starts or has an outage while Asterisk is running, I would ...
3
votes
1answer
3k 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 ?
0
votes
0answers
2k views

Configuring DB2 ODBC driver on Windows

I'm trying to configure a DB2 DSN on a Windows 7 machine, to a remote DB2 server. I've installed the driver, per the instructions here. That appeared to work fine; I've already cataloged the node and ...
0
votes
1answer
3k views

The 32-bit ODBC client for MS-access does not work and installing the 64-bit client is not allowed, what to do?

I have a 64-bit Windows 7 laptop that I use for development. I have office 2003 installed, because I have a client that works with Office 2003. Microsoft Access is not installed, because it's my ...
1
vote
0answers
287 views

Sybase ODBC driver not working over a VPN

I need to run a client's software locally on my machine and have it talk over a VPN link (Team Viewer VPN) to connect to the live database so I can attach a debugger to the client software and figure ...
0
votes
1answer
2k views

SSIS DSN Not Showing as ODBC Data Source

I have been following the directions here: http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/05ccd778-b78c-4a83-a10a-c4ae412cc6e4 And ran into a problem where my System DSN ...
0
votes
1answer
2k views

Are Sybase ASE ODBC drivers for Windows x64 available for free?

Are Sybase's own ASE ODBC drivers for Windows x64 available for free? If not, does anyone know of a cheaper (preferably free!) alternative? I believe the ODBC drivers are available as part of the ...
1
vote
0answers
290 views

Can you use SQLite 64 bit odbc from powershell

Basically, my question is "Does this combo work for anyone," and, "Can you see what I am doing wrong" I have installed 64 bit ODBC driver for sqlite, downloaded from this page. I am running ...