Andrei DANEASA

Trying to connect to SQL Server 2000 or 2005 from Oracle SQL Developer having Windows Authentication enabled on SQL Server will fail with:
“I/O Error: SSO Failed: Native SSPI Library not loaded. Check the java.library.path system property.”

The solution is simple: place a dll called NTLMAUTH.DLL (NT authentication) in your system path and restart SQL Developer. Windows/System32 is always a wise choice.

Where to get this DLL? It is shipped with JTDS here.

Is there another option? Yes, enable SQL Server authentication.

Related posts:
%RELATEDPOSTS%

After we tested our JDBC connection to Firebird and then migrated from Firebird to MySQL we have just one more step to do:

Migration from MySQL to Oracle using SQL Developer Migration Workbench

For migrating MySQL to Oracle we need to have:

• Oracle Database XE (small footprint, free version of Oracle DB)
• SQL Developer

Read the rest of this entry »

Now that we connected successfully to Firebird through JDBC, let’s see if MySQL Migration Tool can connect and migrate the data to MySQL, our intermediary stage for migrating to Oracle.

Migration from Firebird to MySQL

In addition to what we installed during Part 1, we need to install MySQL 5.0 Community Server, the free version, which comes by default (not the Essential Edition) with MySQL Migration Toolkit.
Read the rest of this entry »

In order to do an automatic migration from Firebird to Oracle the only fully automatic process for Tables and Data is make a 2-step migration:
– Firebird to MySQL with MySQL Migration tool
– MySQL to Oracle with SQL Developer Migration Workbench
..but first:

Firebird connection through JDBC on Windows

Read the rest of this entry »