The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
1answer
425 views

Is it possible to share an ODBC connection with other computers on the network?

I will try my best here but I am going a little out of my comfort zone so bear with me. Computer A: Windows XP Pro Computer B: Windows 7 Computer A has an SSH Tunnel to our web server (linux). ...
0
votes
1answer
33 views

what is DDODBC.DAT

The file /var/local/odbc/DDODBC.DAT is being created/accessed on some (not all) servers when the database is accessed via Perl dbi:ODBC. I did a full crawl through /var/local/odbc on a server that ...
0
votes
0answers
627 views

Configuring ODBC for Sybase on SqlAnywhere10 FOR Linux

I am trying to configure an ODBC for Sybase on Sqlanywhere10 for a Linux Machine. When I reference the "ODBC Data Source Name" it finds the .odbc.ini file correctly but when it looks for the driver ...
1
vote
2answers
375 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
185 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
1answer
1k views

MySQL ODBC Issue: Data source name not found and no default driver specified

I'm currently trying to run a classic ASP application which I've been given source code for. I want to set up on my 64bit Windows 7 dev machine and am having trouble with an ODBC based data connection ...
1
vote
1answer
529 views

MySQL ODBC Connector & unixODBC Issue - Garbled connections

Having a heck of a time trying to isolate an issue on a new server install: I've installed MySQL, unixODBC and the MySQL Connector for ODBC, setup odbc.ini and odbcinst.ini as I have on my other ...
1
vote
1answer
759 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 ...
0
votes
1answer
211 views

Multiline statements via ODBC fail

I have written an ODBC wrapper in C++ and use it to execute queries, bind results and return data sets. Everything appears to work fine and I have been using it for a long time for single line ...
1
vote
2answers
622 views

What might cause and ODBC connection to report Data source name not found

I'm working with a small business that uses an Access-based database for work order mgmt. The system has been around for years and they have 6-7 PCs using custom software from an ISV to access the ...
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 ...
1
vote
1answer
111 views

Can I have multiple Sybase (or any other) ODBC Drivers installed?

Is it possible to have two different version of an ODBC driver installed on a single server, specifically Sybase Adaptive Server Enterprise 12.5 and Adaptive Server Enterprise 15.5? Obviously any ...
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
104 views

Add new ODBC driver libs to PHP on OS X 10.6?

I'm trying to access a PostgreSQL datasource via ODBC from the installed stock PHP (OS X 10.6). Queries just hang, and I'm suspecting it can't find the PostgreSQL driver library which was installed ...
0
votes
2answers
848 views

Encrypting an ODBC connection

Situation: We have a SQL Server 2008 R2 database sitting in a data centre We would like to allow analysts to connect to the database and query the data using desktop based tools (e.g. Tableau) via ...
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 ...
1
vote
0answers
209 views

Oracle ODBC: DB on Windows Server 2003 – Windows 7 Client Connection Problems

I have an Oracle DB on a Win 2k3 Server (64-Bit). I have to access the database from a Win7 (64-Bit) machine. I have downloaded Instant Client and the 64-Bit ODBC driver, and have apparently ...
0
votes
1answer
614 views

FileMaker Server not listening on Port 2399 for ODBC/JDBC

I am trying to create a ODBC connection from an OSX machine to a Filemaker server 10 using a DataDirect SeQuel Link 5.5 JDBC drive. I have ODBC/JDBC enabled on the server and I followed all of the ...
2
votes
1answer
1k 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 ...
1
vote
1answer
144 views

Installing Sql Server 2008 Express edition installation removes ODBC configurations

My company distributes an application that requires Sql Server 2008 R2 Express Edition. We use the Microsoft Offline installer for Sql and make exstensive use of the command line switches to get the ...
0
votes
1answer
445 views

ODBC config files on Ubuntu

I am trying to set up an ODBC connection on Ubuntu. I've been swimming in various config files. Could someone please remind me the directory in which the odbc config file is stored? It is called the ...
1
vote
0answers
397 views

Oracle Instant Client DSN via unixODBC

I've got the Oracle Instant Client installed on a SuSE webserver and I'm attempting to connect to an Oracle Database with PHP via unixODBC. The connection seems to be working properly, after issuing ...
-2
votes
1answer
988 views

404 page when accessing http://localhost:1111/ [closed]

Is the port 1111 reserved as a default port for the ODBC connection? When I try to point my browser to http://localhost:1111/ it gives a 404 and not a page not found. What is the best way to ...
0
votes
1answer
3k views

Registry for odbcad32 on Window Server 2003 64-bit

I used to use below registry to import some settings for setting up odbc on Windows Server 2003 32-bit. Now I want to do the same on a Windows Server 2003 64-bit for 32-bit odbc driver not the 64-bit ...
0
votes
1answer
3k 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 ...
0
votes
0answers
631 views

SQL Server 2008 Server-Side “Invalid userid” (Error 18456, Severity: 14, State: 5)

Errors Database administrators report Microsoft SQL Server 2008 server-side error "Invalid Login" (error 18456, Severity: 14, State: 5). Error examples from the server log: Dec 1 2010 10:12AM - ...
1
vote
2answers
266 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
1answer
949 views

Can I create an oracle ODBC driver without installing the Oracle Client?

recently I got a task to migrate the back end of an access database to oracle (the front end should still remain in access), I need an odbc connection for that and on the PC I am working on I don't ...
0
votes
2answers
598 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
685 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
4k 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
4k 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
336 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
0answers
180 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
187 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
607 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
257 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
602 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
2k 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 ...
5
votes
5answers
29k 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
157 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
514 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 ...
0
votes
2answers
5k 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 connection to ...
2
votes
1answer
456 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 (using ODBC), and the SQL server are ...
0
votes
1answer
379 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
1k 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
2answers
959 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 ...
0
votes
3answers
3k 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
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
258 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 ...