Hi, I am am currently trying out the Community ODBC Adapter (from TwoConnect) to call stored procedures on a MySQL database. I have been able to use the MySQL ODBC driver to connect to the database, but when generating the schemas for a stored procedure with input parameters I am getting the following error: Incorrect Number of argum...
I'm following the instructions here, and so far so good, but I'm having trouble figuring out this part: Lastly, download your target version from the ruby odbc project page and do a MD5 checksum on it. What exactly am I supposed to be running MD5 on? The tar file? extconf.rb? I've been poking around for awhile but I just don't ...
I need to be able to connect to an MDB-file in a LAMP-environment (running on Linux) and ultimately insert converted data into a Mysql db. The data I need to access is stored as a BLOB (Long Binary Data according to Access) in the MDB file. I have not yet been able to actually have a look at the data but I have been told that the BLOB ...
I have a .NET Wndows application in C#. It's a simple Windows application that is using the MySql 5.1 database community edition. I've downloaded the MySql ODBC driver and have created a dsn to my database on my local machine. On my application, I can perform get type queries without problems, but when I execute a given insert statement ...
Is there a way to detect the ODBC database currently being connected to with Java? For example, I would like to know whether an application is currently connected to Oracle 10g or SQL Server 2005. Thanks in advance. ...
I have a native C++ windows client application and a SQLServer 2008 server instance. I need to transfer a whole bunch of data both ways. I'm currently using SOCI (http://soci.sourceforge.net/) with an ODBC backend, but have already identified several performance problems with it and would like to try alternatives. SQL data types used are...
Hi guys, i recently got a prebuild application which uses MYOB odbc connection to myob file. the odbc connection works perfectly in that application i uses the same odbc connection string in other application but it failed to open in that application. the connection string is perfectly identical but it wont works the new application. Se...
Hi. I'm working on an e-commerce site (either bespoke with PHP, or using Drupal/Ubercart), and I'd like to investigate the site interacting with an internal (filemaker) database we use to manage stock and orders. Currently we manually transfer orders from the web site to our own database, and the site does not check or record changes in ...
I am not able to call setNull on PreparedStatement using MS Access (sun.jdbc.odbc.JdbcOdbcDriver) preparedStatement.setNull(index, sqltype). Is there a workaround for this. For LONGBINARY data type, I tried the following calls, neither worked. setNull(index, java.sql.Types.VARBINARY) setNull(index, java.sql.Types.BINARY) java.sq...
I am trying to remove an ODBC entry during uninstall. What is the best way to do this? I have a standard VS Setup project. ...
I'm a database n00b and am reading as many books as I can. I have been given responsibility for an ODBC tool where the databases were designed by a hardware engineer with some VB experience - which made him a s/w guru in the small firm at that time. Things are running slowly and I suspect that the db could have been designed better. I ...
I am using SQLConfigDataSource to create an ODBC MS Access data source programmatically. It works most of the time, but fails if the DBQ value (i.e., path to the Access database) in the lpszAttributes string contains more than 148 characters (far fewer than MAX_PATH). Has anyone ever run into this before? Any possible workarounds? ...
Is the Microsoft ODBC driver for Oracle compatible with JDBC? If so, could an example be given? ...
I have some procedures to execute in the database that has an OUT REFCURSOR parameter. When I am connecting with the JDBC thin client, everything works fine. However, if I were to change the connection string to refer to the ODBC data source pointing to the same database, those procedures will fail. The procedures that do not use an OUT...
Does anyone know how to implement a basic .UDL file (MS Data Link File) database connection using Java? Is it possible? Is there a special 3rd party driver I would need? ...
I'm looking to modify ODBC calls either directly before hitting the ODBC stack or between the ODBC stack and the dll driver for the connection I am using. For instance, if the application does a SELECT, I want to be able to modify it be SELECT_ALL How can I do that? ...
Let's say that I've created two different program executables, e.g. in C++. For some reason, the two programs internals representation of text are different from each other. Let's say the first program is using text representation A and the other text representation B. It could be a specific 8-bit ANSI codepage, Unicode/UTF-8 or Unicode...
Ok, so I need to populate a MS Access database table with results from a MySQL query. That's not hard at all. I've got the program written to where it copies a template .mdb file to a temp name and opens it via odbc. No problem so far. I've noticed that Access does not support batch inserting (VALUES (foo, bar), (second, query), (thi...
This is under Windows 7 64 bit. I downloaded the 64 bit drivers and as a matter of fact I tried all the windows drivers(uninstalling the previous ones first though). But when I try to configure a new ODBC connection the MySQL driver doesn't show up. Do I need to install some other package before I can get the connector to work? Like MDA...
I have a database upgrade tool that is misbehaving. I would like to catch one of the queries it sends to the database and change it before it is executed. The tool connects via ODBC. The tool and the SQL Server are on the same Windows 2003 Server box. Any ideas? EDIT: (More info) When the tool runs it dies on step 12 out of 100. It...