We are using MS Access as a reporting front-end for Oracle. The data is accessed via an ODBC connection, and there are two linked tables in Access to Oracle that are the raw data tables. I'd like to be able to set up the connection and link the tables from within the Access file. That way users don't have to worry about setting up an DSN...
Using either the v19 test drive software to install Premier v19 or the NZ_ODBCv7013.exe file to install the v7 ODBC driver. Both of these methods work on 32 bit systems but fail to install anything on x64 - there were no error msgs either. Am I using the right install files? Has anyone completed this installation successfully? ...
We need to access a InterSystems ODBC data source via php. The current default odbc driver is db2. Apache user can access datasource via isql on the command line using /etc/odbc.ini. Does anyone have any recommendations? This is what we have tried: 1) $conn = new PDO("odbc:DI01", "", ""); SQLSTATE[08001] SQLConnect: -1013 [IBM][CLI ...
I am having problems remotely connecting to my mySQL database in Java. Here is my error message: java.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified I am sure my ip address & port I am using work, since I am using the same ip & port for a mySQL client program. My hosting c...
Does anyone know how to create an ODBC or OLE driver preferably in C#? What I want to do is creating a custom data source which I can use in Excel and Access. Or do think of another way how to do this? Thanks in advance for your responses! ...
Hi, I've created an ODBC connection to an Excel 2007 Workbook using ACEODBC.dll, which is supposed to work for both .xls and .xlsx files. However when I try to open a connection using JDBC I get a SQLException: [Microsoft][ODBC Excel Driver] External table is not in the expected format. The Workbook is also password protected and encryp...
I write MS Access / VB / SQL Applications, customized. One of my clients has a truly massive Access application I wrote them, and their number of active users have just expanded to over 15. Running into more data corruption issues, I am recommending they port to an SQL backend for stability. (Of course). They would prefer to invest in a...
I have an application that reads a delimited file using ODBC. The connection string is as follows: cs = @"Driver={Microsoft Text Driver (*.txt; *.csv)};DBQ=" + sPath1; One of the companies providing a file is not using a header row, and I'm losing the first row of data. Putting HDR=No in the connection string does not seem to help. T...
While worked in Windows, I developed a ODBC driver for a database, I installed and registed it in system, and created a data-source(I'am sure about this,because I can see these utils in system's datasource manager), while I call SQLConnect() use the data-source name, the IM003 throwed and the native error is 160, it means that the SQLCon...
I'm trying to query a DBF file using System.Data.Odbc.OdbcConnection. It works correctly when the file doesn't have a space in it, but I get the following error "Error opening DBF File: ERROR [42000][Microsoft][ODBC dBase Driver]Syntax error in FROM clause" if the file path or name has a space in it. I'm using the following code: oConn...
I need to uninstall an ODBC data source on ~30 computers and was hoping there'd be a quicker way than using the ODBC Administration GUI. This is a one time deal so I'm hoping to use a VBS or a Batch file. I've tried using reg delete but the data source still hows up in the ODBC Administration GUI. Anyone know how to uninstall an ODBC da...
This .NET application used to work. When it did we were using the Oracle ODBC 9i. We moved to 10 g did not work anymore. Now at 11g stills does not work. I have set SQL Command Timeouts all over the place. I have set the connection timeout and the query timeout in the linked server properties to 120. I can run the proc from SQL Ser...
I see in the Excel documentation the QueryTables collection and ODBCConnection object, but not how to use them in powershell. I want to create a new workbook with a single worksheet, connect to a System DSN (doesn't need login/passowrd), and run "SELECT * FROM someTable" and have the results go into the worksheet. Excel is 2007; powers...
I have a project in which I'm accessing a MySql database on my web server via MySql ODBC driver 3.51. So far I've stuck to writing the ASP.NET C# code for this web app in notepad and just using runtime compiles on the server side to operate everything. So instead of using something like: <%@ Page Title="Add Order" Language="C#" MasterPa...
Background Information: Visual Studio 2010 (.NET Framework 4.0) Informix Server 7.31 Informix ClientSDK 3.50 TC7 (Windows 32-bit) was installed as well. I have tried multiple ways suggested online to connect to the Informix server, but all of them do not work for me for whatever reason. I have looked at articles such as Connect Info...
I have a database which manages login information for an application, and find myself (for rather tragic reasons involving combo boxes - don't ask) needing to manage the registration of new users through a web frontend. Quite literally all it needs to do is have a single form composed of a few edit boxes and a handful of combo boxes. Kee...
I'm reading a record from a DB2 database via ODBC connection. The data is populated into an ODBCDataReader. As I'm going through my foreach loop I'm running into problems trying to parse the multiple different DateTime fields. Some of the fields are null, some have null date time value (9999-12-31 24:00:00.000000) and some have valid ...
I am trying to insert , update some data into MS Access database using ODBC , that data came from $string=html_entity_decode($unicodedata, ENT_NOQUOTES,'UTF-8')."\n"; that look like this " ബാലകàµà´¯à´·àµà´£à´¨àµ*à´¨à ",actual data needed like this പ്രമോദ്കുമാര്, i have worked on this with Mysql , which has connection collatio...
I need to get data out of SQL Server2005 tables, and into another system. My vendors says: "We don´t recommend that you go directly in the SQL and collect data, because it can result in corruption of data or you can lock tables while exporting." Is that true? ...
I'm trying another method to connect mysql and vb.net. I didn't have any difficulties connecting mysql and vb.net when using mysql net connector. And I also used the same codes. I just replaced the ones that needed to be replaced with odbc. Imports System.Data.Odbc Public Class globalclass Private cn As New OdbcConnection("DSN=k...