The tag has no usage guidance.

learn more… | top users | synonyms

0
votes
2answers
767 views

Batch-script implementing 2 ODBC-connections

Thanks for all previous help! I have a question regarding av script. My computers is all XP, and needs the following when I do my thing : I have 2 ODBC-connections (towards MS-SQL-DB), which I have ...
1
vote
1answer
840 views

Windows 7 XP mode - ODBC host connection

I have a legacy application that installs fine in Windows XP mode on Windows 7 64 bit, but it requries an ODBC connection. Is it possible to have the XP mode application use the host Windows 7 ODBC ...
0
votes
3answers
9k views

ODBC connection is extremely slow

I have an ODBC connection to a providex database. We use the database in software throughout the company, and the ODBC connection is created by a standard installer. Trying to test the ODBC ...
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 ...
0
votes
1answer
427 views

How do I set up an installation script including ODBC-connection?

Easy question this time.... I have a installation file, and a registry edit in my script. How do I set up a ODBC-connection as well, actually I need to script up 2 ODBC-connections. Any advice for ...
1
vote
1answer
219 views

ODBC DSN Authentication Options

I was wondering if besides the standard username/password ODBC authentication, other options exist to authenticate an ODBC connection using an alternate method like PKI similar to SSH. Seems like a ...
1
vote
1answer
250 views

PHP ODBC Not Closing Connections

I just asked this question on stackoverflow, and it was recommended that I also ask here. I have a PHP application that uses the ODBC functions for database access. My DBA recently discovered that ...
1
vote
1answer
716 views

Fetching data from MS SQL Server 2008 to Oracle via ODBC: Getting ORA-28545: error diagnosed by Net8 error

Background: I am fetching data from a database on SQL Server 2008 (SQLA ) over to Oracle (ORCLA) . The data is pulled using a database link, via HS ODBC connection. Both the SQL and Oracle databases ...
0
votes
2answers
319 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. ...
0
votes
1answer
810 views

Credentials work for SSMS but not (ODBC) LogParser script

Via SSMS I'm able to connect and navigate the server/db in question. but trying to connect via a logparser script the same credentials fail. I'm trying to execute this from the same box on which the ...
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 ...
6
votes
7answers
66k 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' ...
1
vote
1answer
170 views

silent failure while creating odbc data source

I just got really confused trying to create an ODBC data source in Windows 2003 R2. I can create a connection to my chosen server (a MS SQL Server) on the "user DSN" tab, but when I try to do the ...
0
votes
1answer
565 views

informix odbc connection slow to open in asp.net

I have an application that takes a long time to open odbc connections (like 20 sec) also takes forever using arcmap and arcsde but when I try the connection on the odbc data source administrator, it ...
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 ...
2
votes
1answer
503 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 ...
0
votes
1answer
472 views

ODBC error state S1092: postgresql through ODBC

While performing an upgrade, our in-house software started to report the following strange error. It is a C++ application talking to a remote PostgreSQL database, defined through ODBC: ODBC error ...
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?
0
votes
3answers
1k views

What port does OpenLink ODBC Driver use?

I use Avaya Reporting Services and OpenLink ODBC Drivers for db connection. I know that it uses port 5000 for handshaking but after that I believe it uses an random port for communication. I want to ...
1
vote
4answers
11k 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
2answers
5k 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
317 views

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

Oracle 10g ODBC Drivers and Connectors

Hello Im using two machines : Windows XP and Windows Server 2003 , on both I have installed the oracle client 10g, and when I try to use ODBC for linked server option on SQL Server It just work on my ...
3
votes
2answers
160 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?
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 ...
1
vote
3answers
2k views

64bit UnixODBC and FreeTDS: a bug in libtdsodbc.so?

We have a legacy Windows web application which uses Microsoft SQL Server 2005. Two years ago we rewrote a part of this application using PHP and ODBC on a 32 bit virtualized Debian system. This ...
24
votes
10answers
254k 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 ...
0
votes
1answer
579 views

Access to SQL 2008 Server with ODBC

what do you think about using an SQL-ODBC-driver (SQLSRV32.DLL) with the name 'SQL SERVER' for accessing a SQL Server 2008 Server database? A first look shows that it works but is there something ...
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 ...
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 ...
2
votes
3answers
9k 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 ...
0
votes
2answers
2k views

Only allow ability to read the views for a particular SQL Server user over ODBC

Newbie question: I have a designer who reads information from a SQL Server [2008] database. I've setup a few views for him to pull his data from and granted his user a member of the db_dataread ...
1
vote
1answer
1k views

IIS ODBC logging doesn't work - solving “Could not initialize the logging module” problem

I'm absolutely new to IIS and hardly know what I'm doing. I've configured ODBC logging for our IIS server exactly following steps specified by Microsoft on this website: ...
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 ...
1
vote
1answer
8k views

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 ...
0
votes
4answers
3k views

ODBC connection to SQL Server through firewall

The Status Quo: There's a SQL Server (2005) database. On the same network, There's a user who connects a Visual FoxPro instance to said database via ODBC. This works, the user is happy, and ...
1
vote
4answers
4k 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 ...
0
votes
3answers
2k views

How do you connect to BusinessObjects?

I have the rights to log into a BOXI server and build queries and reports, but can only export 100,000 rows at a time. I have tools on my desktop that can connect to databases via things like ODBC. ...
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
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 ...
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, ...