To solve this go to c:\windows, there you see a folder named SysWOW64.
It looks like you opened the default 64-bit view which doesn't show the 32-bit ODBC drivers.
Moreover, this driver is compatible with JDK 5 and 6, so developers can deploy either one of them within their projects.Īnother benefit of using this connectivity driver within an application is that it runs without any problems on multiple operating systems, such as Windows, Solaris and Linux - this can prove to be very important for the programmers who want to come up with cross-platform utilities.Īll in all, Microsoft SQL Server JDBC Driver can come in handy to all developers who want to want to create and distribute a reliable software solution that connects SQL servers to Java apps or applets. But on 64-bit systems, there are two views on ODBC - one is 64-bit, the other is 32-bit. To do this, create a file called phpinfo.php in the root of your PHP web server (default directory is C: xampp htdocs), with the. The next step is to view the information of your environment. In order to create the aforementioned connection, Microsoft SQL Server JDBC Driver uses standard JDBC APIs (Application Program Interfaces) that are available for Java. The first step to getting this connection is download Microsoft® ODBC Driver 13.1 for SQL Server® to your machine and perform driver installation.
Microsoft SQL Server JDBC Driver is one of the solutions they can rely to, as it can offer database connectivity between SQL servers and Java-based products.Īdditionally, this driver supports a wide range of servers, namely SQL Server 2012, 2008 R2, 2008, 2005 and SQL Azure, and each of them can be configured to establish a successful connection to a Java-powered program, application server or even an applet. There are many software solutions that need to connect to a database server in order to fully function and it is up to their developers to ensure that this process goes smoothly, without a glitch.