I have developed my software using NetBeans IDE 6.9: very simple, a db on a remote server, a JDBC:ODBC bridge connection in order to access it and everything was working fine, until I was ready to deploy it, and I fell in this problem of 32-64 bits conflict.
I changed the jdbc:odbc connection to the sqljdbc from Microsoft.
the program is accessing the database and reading/writing to it, only in Netbeans. when I build it and try to execute the project.jar file, i always get this exception :
SQL Exception: java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver
even though I have included the jar file into my project library, and Netbeans classpath, but still, I am facing this problem.
I am using the NetBeans IDE 6.9, and SQL Server 2008 R2 on my remote server.
This is urgent, i have to deploy the software as soon as possible.
thx in advance