The first one turned out to be something trivial, which is SQL 4.21 would never listen on TCPIP. I've been having this problem for 3 months now.Enterprise Manager looking at the infamous PUBS databaseĪlthough I have gotten SQL Server 4.21a & 6.5 running on Windows 10 (The core from 6.0 works, but it’s pre-release COM objects for the Enterprise manager don’t like Windows 10) There were two stumbling blocks I never could get around. 60 to my list of drivers in ODBC Data Sources.īy the way, I apologise for mentioning Java in this, but that's what I'm using to connect to the database. Change the Driver that my SQL Server instance uses.However, my ODBC Data Sources App only shows 0.16384 in its list of drivers, as you can see below. SQL Server Management Studio IĪt the moment my SQL Server instance, which is called “SQLEXPRESS2012”, uses version ODBC Driver. I have only known how to create DSNs for a month. The ODBC driver that I use for my DSN, for connecting to my Database is different to the one that my SQL Server Instance uses. I have though identified why it doesn’t work though. I know because IĬan connect to the Database absolutely fine in School. I know how to create DSNs and the connection strings required in Java. The code I have written works fine, as well as the queries I have included. The Database is fully created and related. It is not because of the JDK I’m using, for even though I have Netbeans 8.1, it uses JDK 1.7, meaning that ODBC-JDBC Bridge will work. The problem I have is I can’t connect to it

I have coded a program in Java, the purpose of which is to connect to and manipulate data in a database in SQL Server Express 2012.

Windows 10 odbc driver for sql server