The tag has no wiki summary.

learn more… | top users | synonyms

-1
votes
1answer
12 views

Windows 20003 R2 Missing mapped drives under ODBC Administrator

When I try to set up an ODBC datasource (MS Access) I can't select the network drive where the mdb file is. The network drive is accesible from My Computer.
0
votes
0answers
74 views

Microsoft ODBC SQL Server Driver [DBNETLIB] error from client desktops connecting to SQL Server 2005 databases

Problem We have a program installed on numerous client computers making database connections to SQL Server 2005 databases running on a Windows 2003 Server. Client computers are Windows 7. Recently ...
0
votes
0answers
55 views

Linked Server in SSMS: role of “String Column Lengths” values

I'm using linked server in SQL Server Management Studio in order to connect to Mongo database through ODBC. I have hard time trying to get data from Mongo. Here is a query I try to make: Select * ...
0
votes
1answer
33 views

Is it safe to Update and/or Insert records into an accounting software's database? (Pastel Evolution)

Our CRM system can post transactions to our accounts software (Pastel Evolution), but it doesn't perform the required currency conversion. Both systems have different "base" currencies (because of our ...
0
votes
1answer
346 views

Problems configuring DB2 CLI/ODBC System DSN ODBC Data Source Administrator

I am trying to create a System DSN ODBC connection to a DB2 9.5 database, but I am getting a very strange problem. I've looked through the internet and found the following page that has some ...
-3
votes
1answer
94 views

Windows Server 2008 iis 7.5 classic asp mdb DB via DSN odbc [closed]

I had a a simple site on a 2003 IIS 6 server for years. I have a small DB in a Mdb file. Everything was great, until I've upgraded to a windows 2008 R2 64bit IIS 7.5 server. I've transferred the site ...
0
votes
1answer
154 views

ORA-01019 under Win 8.1 / Server 2012 R2, ODBC Excel

We getting error message ORA-01019 when trying to connect to an Oracle 9.2 database with ODBC in an Excel macro running in Office 2013 32bit (!!!) under Windows 8.1. We are having the same issue ...
2
votes
0answers
66 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
209 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 ...
3
votes
1answer
325 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 ...
1
vote
2answers
65 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 ...
0
votes
1answer
94 views

How can I delete this ODBC?

I am unable to delete a specific ODBC of type system DSN. I am able to create and remove other ODBC connections on the same server, but a particular ODBC (name = Default) cannot be removed. If I try ...
0
votes
1answer
390 views

Plesk error when adding a subscription: ODBC error #08S01 can't connect to local MySQL

I'm getting this error after updating MySQL to 5.6 (Plesk 11.5, fresh installation) using the official MySQL repository right after adding a new subscription. Internal error: ODBC error #08S01: ...
0
votes
1answer
62 views

Access to Windows event observer with ODBC

Is there a way to access the Windows Event Observer data from something like an ODBC datasource? Or a way to export data (lets say that we limit age of data to 1 week or one month) in a structured ...
1
vote
1answer
39 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 ...
3
votes
1answer
133 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
2answers
6k 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
104 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) ...
2
votes
1answer
4k 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
281 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
124 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 ...
1
vote
2answers
52 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: ...
1
vote
1answer
1k 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
1k 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) ...
1
vote
0answers
234 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
249 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
1answer
194 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
172 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 ...
0
votes
2answers
447 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
2k 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
806 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 ...
2
votes
2answers
6k 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 ...
2
votes
0answers
268 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 ...
1
vote
2answers
706 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
0answers
825 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
106 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 ...
1
vote
1answer
1k 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 ...
-1
votes
2answers
3k 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 ...
0
votes
1answer
241 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
80 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
621 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 ...
5
votes
1answer
7k 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
1answer
531 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 ...
1
vote
0answers
363 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
3k 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 ...
2
votes
0answers
132 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?
1
vote
0answers
379 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 ...
0
votes
1answer
311 views

Create ODBC Connection from Access to SQL Server

I need help connecting from a blank access 2010 database to my remote SQL Server 2005 database. This is because I'm going to write all my client apps in Access, and store everything on the server with ...
1
vote
0answers
427 views

What does the error message “Communication link failure (SQL-08S01)” actually mean?

Our application is running on dozens of servers and only a few get this error message. What is worse, is that the SQL query that causes this error message seems to be executing. The application is ...
0
votes
3answers
362 views

How do I trace from my client PC what databases it connects to

I wonder if there is some way to trace what servers my program using OLEDB tries to connect to. Problem: I have a program displaying some reports made in Crystal Reports. The loading of some reports ...