Windows x64: 32bit Odbc vs 64bit Odbc

I run into a very big trouble on these days.

  • My big company delivered to me a Windows7 64bit system (first error)
  • I asked for Office 64 bit and Visio2007 32 bit
  • I tried to connect to Oracle (second error) to reverse engenieer a DB with Visio2007

I got a “driver architecture” error under Visio2007. Launching
%WINDIR%\System32\odbcad32.exe

(the 32bit guy of the odbc drivers side)
I was able to get the same error… and this was helpful:

It’s important to understand which kind of DSN you have. On an x64 system, you can create an ODBC connection(DSN) on the 32-bit side of the system or on the 64-bit side of the system.

32-bit applications will only see ODBC connections created in the 32-bit side, and 64-bits applications will only see ODBC connections from the 64-bit side. Each kind of application has is own registry.To setup DSN for 32-bit application you must use:

%WINDIR%\SysWOW64\odbcad32.exe

and for 64-bit application you must use:

%WINDIR%\System32\odbcad32.exe

via Windows x64: 32bit Odbc vs 64bit Odbc « a developer’s breadcrumb.

This  Microsoft KB article explains it.

So I re-installed the 32bit version of the Oracle11g drivers, after ensuirng it was possible.

Remember: on 64bit system, you will probably need a double odbc driver declaration to mix 32 and 64 applications.

 

 

Introduzione a SQL Server 2008 Express

This entry is part 1 of 1 in the series SQL Server

In questo articolo parleremo di Microsoft SQL Server.

SQL Server nasce inizialmente da uno sforzo congiunto di Microsoft, Sybase and Ashton-Tate che nel 1989 creano tale prodotto avente come target OS/2.

Dopo alcune vicessitudini Microsoft si smarca da Sybase e SQL Server versione 6.0 è la prima versione per Windows NT che non ha più dipendenze di copyright da Sybase.

Continue reading “Introduzione a SQL Server 2008 Express”

Java JDBC Probe

Tired of prepared statement written down on the code?

Tired of Hibernate, and willing to come back to crude SQL debugging?

No problem, dudes!

We tried Elvyx, a  JDBC probe, without a full success. Our quality vote is 5, because of the following bad aspects:

  • Very poor documentation. It is unclear if timings are returned in milliseconds or in seconds: no word about it!
  • Returned value are often inconsistent, so we cannot use it very well.

Anyway, for a “quality oriented” sampling of data, for finding out most used calls and so on, Elvyx can help a bit.

From the website:

Elvyx is a tool designed to monitor and profile the jdbc activity.

This jdbc profiler has a wrapper that intercept the access to the database and send this information to the elvyx server. The server receives the information, store the data into a database and serve this information to the client. The client shows sql statements, bound sql statements, elapsed time, elapsed time preparing the statements, etc.

To get started, check out the installation guide.

And do not forget the screenshot.

Hibernate Speedest introduction

In this article I will introduce you to Hibernate 3 persistence framework.
This article is worth to read, because give you a very fast track to Hibernate; I have used this tool for the past six years, when only the good 2.x series was out of there.
Then I have the lucky of training two teams on two different and big projects, with a “zero time” to teach them hibernate.
So I decided to put here my advices, hints, tips and tricks, for the rest of the guys around the World.

Continue reading “Hibernate Speedest introduction”