Our project uses AcuCorp's AcuODBC driver to access a legacy Vision database. The problem is that we only have a 32-bit driver and the installer simply won't run on our 64-bit servers. I need a way to use SSIS to pull data from that system. As far as I can tell, there are 3 options: Set up a whole new SQL Server instance with SSIS a...
I have a client that I'm trying to do some data migration out of an old route-accounting system for. The system has an Informix 3.30 database with SimbaServer middleware sitting on top of it. From what I gather, ODBC and JDBC support was not added to Informix until version 5.x, so that's out. Also, I have been unable to find the Simba...
I have an mdb which used to contain a bunch of linked tables. These links point to tables in another Access mdb. As part of a controlled migration, I'm changing these link table to point to an SQL server instance instead, by iterating through all linked tables and updating the connect string to an ODBC one, then calling RefreshLink on ...
I have a Vista machine that needs to remotely connect to Oracle 8.1.7 database. Installing the instant client with the ODBC pack gets an ODBC driver, but when you create a datasource with it, it says it's no longer compatible with that database version. What's the best way to get the correct ODBC driver? ...
We're trying to insert data into a clipper database file (DBF file with NTX index file). For a variety of reasons, we cannot change the database format. We are currently seeing two issues: With our existing code, we are not able to update or utilize the NTX index file (I believe). We would like to be able to do this. Do you know of...
Whenever I try to connect to MySql using vbscript, I'm getting an error: Script: E:\VBScript\CreateAccount.vbs Line: 6 Char: 1 Error:[Microsoft][ODBC Driver Manager] Data source name too long Code: 80000405 Source Microsoft OLEDB Provider for ODBC drivers Here's the code to open the connection to Mysql: dim cn, rs set cn = CreateObj...
I have Informix Dynamic Server 11.50 and Informix Client SDK 3.5 installed on my server. I am developing a .NET application to read data from Informix database using ODBC functions. In the database, i have a table with columns of Serial and BigInt data types defined. My data retrieve function looks like this. Dim cmd As New Odbc.Od...
I'm trying to connect my Ruby on Rails application to a legacy Database that is in a Microsoft SQL Server 2008. I have looked around different tutorials, pages, help pages, and question pages and still haven't been able to make it work. I'm using: Ubuntu karmic Rails 2.3.5 Ruby 1.8.7 activerecord-odbc-adapter 2.0 activerecord-sqlserve...
Hi Guys, I think I have a straight forward question. I'm writing a system that allows users from company A to single sign on to the system and for this I go back to the central database of users at company A and validate the user credentials passed to me. Currently my implementation involves building up my query using a stringbuilder a...
The downloaded installers from MySQL don't work - ie no mysql driver appears in the ODBC manager thing. I've downloaded the mysql-connector-odbc-noinstall-5.1.6-win32 version, copied myodbc5.dll and myodbcS.dll to c:\windows\system32 C:\dump\bin>myodbc-installer -d -a -n "MySQL ODBC 5.1 Driver" -t "DRIVER= c:\windows\system32\myodbc...
We have a lagacy VB6 app that uses an ODBC connection to a Oracle 10g DB. We are upgrading to a 11g drivers on our SOE and parts of the app have issues. Works fine with a 9.2 driver. Oracle Client 10g/11g does not like lower-case calls. This is evident in the fact that the calls that succeed are in upper case and the calls that failed a...
Hey! So I'm transferring an old filemaker database to MySQL and some repeating fields are causing me some problems. I've read that the ODBC standard support those fields, only when their types is "Text" and that each repetition is concatenated with a certain delimiter (see page 47 (PDF)). However, I just can't reproduce this. All I get...
My Delphi application connects to a SQL Server Database through BDE. In the process, my application queries SP_Who stored procedure to get the DbName column Value. But now I want to connect my application through ODBC to the SQL Server database. I'm using the SQL Server Native client driver for this, but when my application queries SP_...
Hi, I created a BIRT report and deployed it to tomcat. It runs fine on localhost, but not on the server. The app doesn't find the right ODBC datasource. But the datasource is configured exactly the same on both systems (Vista / Small Business Server). The ODBC datasources are configured on the local systems. I am using this url: jdbc...
I have been told that there is a bug in the Excel ODBC drivers, that prevents ODBC from providing updates while Excel has the spreadsheet open. Can someone tell me if this is true? Is there a known work-around? Thanks, Ken ...
I am very "lucky" to get to work with a VB application that was originally written in vb6 with an old version of Mysql ODBC connector. The problem is i can't open the project in my copy of VS2008 because i don't have the needed file MyVbQl.DLL and i can't find it anywhere on the internet and also Mysql ODBC connector versions 3 and 5 do...
I'm encountering problems in my ASP page. This is a login page which checks the user's credentials to the database before it allows access to the main page. I created a debugger page to find out what's the error details and this is the error message: Microsoft][ODBC Driver Manager] Data source name not found and no default driver speci...
Hi My remote database is Mysql database and i want to retreive some records and put into the Microsoft Access database which is a localhost database and i want to also create DSN for remote database please help me ...
Hi, I have an C# winforms app that works fine on all our XP machines. We want to put it on a new Win 2008 64 bit server and it breaks on the following code: using (OdbcConnection oConn = new OdbcConnection()) { oConn.ConnectionString = @"Driver={Microsoft dBase Driver (*.dbf)};SourceType=DBF;SourceDB=" + filePath + ";Exclusive=No; ...
$selectVolID = "Select COUNT(VolunteerID) from planetVolunteers"; $getVolID = odbc_exec($connect, $selectVolID); echo odbc_result_all($getVolID); gives: Expr1000 49 1 49 is the correct count. I want to change the Expr1000 to something legible and get rid of that 1 (which i assume means there are no more values to count). Any ideas? ...