Hello, I am trying to connect to an informix database on a 64 bit windows 7 pc. I have been able to make the connection just fine on a 32bit pc, but I get the above error when trying to run it on the 64 bit pc. It is looking for the IBM.Data.Informix driver, but says it can't find it. I've got 2 versions of that dll in my GAC - 3.0.0....
I've found instructions on how to connect MS Access as a front-end to a DB2 database, but it appears that installing DB2 locally is a prerequisite (so that you have the DB2 ODBC driver). But I don't want to install locally. I want to connect to a remote DB2 database. I can't seem to figure out how I can get that driver installed without ...
Hey all, Working on Progress 9.1E on a Windows box. We've got a standard 4GL GUI application up and running which connects to a series of personal databases running on the same box. It's sort of like a big graphical catalogue application with ordering capabilities. Anyhow, we're looking to run a .Net application on the same box and Pro...
I use codes below to inserts values to database by executing stored procedure. Dim connstring As String = "dsn=test" Dim oConn As Odbc.OdbcConnection = New Odbc.OdbcConnection(connstring) Dim com As New Odbc.OdbcCommand("{? = call sp_test1(?,?,?,?)}", oConn) com.CommandType = CommandType.StoredProcedure com.Parameters.AddWithValue(...
I'm trying to execute multiple statements on a MySQL server and get the results into an Excel pivot table. As an example: create temporary table if not exists a select 1 as testcol; select * from a; Even if I have the MULTI_STATEMENTS flag set to 1 it returns a "problem obtaining data" error. Is there a way to do this? It's a read-o...
I fear this has been beaten to death, but I'm still struggling with the problem of reading Excel files in my ASP.NET application that has recently been ported to Server 2008 and 64-bit. Many posts I find point to the existence of 64-bit Microsoft drivers here: here and here. My concern is the warnings I'm also reading about these not...
How to create ODBC or DSN file for connection so that Access Linked Tables are pointing to hosted SQL Tables? ...
Hi everyonoe, I have installed Oracle Client 10g 32 bit and ODAC 11g R2 on my Windows 7 machine, but I cannot see any Oracle Providers in MS ODBC Administration or when I try to created a linked server to Oralce in SQL Server Management Studio or in Visual Studio 2010. Can anyone please help me out as what to do? I can connect to Oracle...
I need to set up a one-way transactional replication from a SQL Server 2005 database to MySQL 5.1 Database. I have installed the ODBC driver and started to work on creating the publication, but I am getting an error that I have not found a solution for. The error is Failed to set publication parameter @enabled_for_het_sub because...
I am testing the error-handling of an Access-VBA controlled process: A script in an Access 'controller' DB starts. The script starts a macro in a 2nd Access file (the 'database'). The macro in the 'database' file runs a bunch of maketable queries. These queries pull from tables linked to an ODBC source (SQL-Server actually). When thi...
Hi All, I need an expert insight to my problem. most of my experience is development so i dont have enough grasp regarding server issues or maintenance. Main problem is when traffic is high request to this SQL server times out. there are several applications connecting to this server, some are web some are windows app. i would like to k...
We have an Access database migrated from Access 97 to Acces 2007 with some linked tables to an SQL Server 2008 database. We are using a File DSN in the ODBC Administrator. Connection tests work fine there. In fact, we have a main form in the Access 2007 application that shows the data always correctly. The problem appears when we exec...
I have an old app that I need to get functioning. Right now it uses some invalid SQL. It connects to the db using ODBC. I would just like to shim the ODBC so I could watch for the invalid SQL and replace it with some valid commands. Any ideas? MySQL proxy would fit the bill if it would fly over ODBC. http://dev.mysql.com/downloads/mys...
I'm using pyODBS to connect to Oracle database. Connection and executing SELECT query works fine. The only problem is error on UPDATE query executing. I have table: CREATE TABLE stud (num NUMBER(6) NOT NULL, fname NVARCHAR2(70), year NUMBER(4), bday DATE, plata NUMBER(1) DEFAULT 0 CHECK(plata IN (0,1)), mb NUMBER...
I have created a user dsn named "harshi" To insert rows in a table getting data from Java code I want to insert in SQL table. The connection statement is: String url = "jdbc:odbc:Harshi"; Connection conn = DriverManager.getConnection(url,"",""); Statement st = conn.createStatement(); Still I am getting output as: Got an excepti...
I'm dealing with an issue that has arisen for an application I've been working on which connects to a Access file via JDBC-ODBC. On other Windows platforms, this issue hasn't been encountered, but on Windows 7 64-bit boxes, attempting to connect with DSN-less connection strings return: java.sql.SQLException: [Microsoft][ODBC Driver Mana...
I am building a report in Reporting Services 2005, where the data is retrieved from an Informix database. The connection to the database is declared via ODBC. Here is the simpler version of the query: select prodtype, familynum, family, sum(invested) invested, month(recevdate) month, year(recevdate) year, d...
I have a C# .NET program running an ETL which connects to a DB2 database. Sometimes this database is down, so I'd like to do a health check at the beginning of the application to see if the database is available, without actually calling any stored procedures or pushing any data. Here's an example of the code I'm using now: OdbcConnecti...
Today I downloaded and installed MyConnector so I can use Mysql with ADO, everything installed, OK!, I can make connection with ODBC and do a connection from my delphi environment. when I build my Query at runetime, I get an error saying : --------------------------- Debugger Exception Notification --------------------------- Project P...
Hi, I'm using the following setup to access a MS-SQL database from a PHP application RedHat Enterprise Linux 5 PHP 5.2.14 with PDO and PDO_ODBC unixODBC 2.2.11 FreeTDS 0.82.1.dev.20100810 Unparametrized queries work fine. The only issue is being forced to close cursor on single result statements (with PDOStatment::closeCursor) to av...