Tagged Questions

The tag has no wiki summary.

learn more… | top users | synonyms

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
139 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
4k 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
1k 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 ...
18
votes
8answers
163k 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
571 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
1k 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
7k 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
1k 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
7answers
9k 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
5k 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
3answers
2k 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
3answers
2k views

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

We have a DSN on server A that points to a DB on server B. We have a server C, that we want to be able to use that DSN on server A...but we don't want to create the DSN on server C. Is there a way ...
0
votes
3answers
1k 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, ...