Create connection to SQL server DB from Oracle data modeler
jdbc, oracle, sql-server-2005
Solution
I was able o figure it out.
Here's what I did:
JDBC URL: jdbc:sqlserver://testServer\SQLEXPRESS/Databases/testDB:1433;user=sa;password=pass; Driver Class: com.microsoft.sqlserver.jdbc.SQLServerDriver
Also I added sqljdbc4.jar in Prefrences. (under Tools option).
Make sure that 1433 port is set in SQL Server. to do so, perform below steps:
- Open SQL Server Configuration Manager, and then expand SQL Server 2005 Network Configuration.
- Click Protocols for InstanceName, and then make sure TCP/IP is enabled in the right panel and double-click TCP/IP.
- On the Protocol tab, notice the value of the Listen All item.
- Click the IP Addresses tab: If the value of Listen All is yes, the TCP/IP port number for this instance of SQL Server 2005 is the value of the TCP Dynamic Ports item under IPAll. If the value of Listen All is no, the TCP/IP port number for this instance of SQL Server 2005 is the value of the TCP Dynamic Ports item for a specific IP address.
- Make sure the TCP Port is 1433.
- Click OK.
Problem
I'm trying to connect to MS SQL Server 2005 from Oracle SQL Developer Data Modeler 3.1.4.710. I go to File -> Import ->Data Dictionary and then try to create a connection to SQL Server. I keep getting `"Status : Failure -Test failed: Driver class not found. Verify the Driver location" error.` I’m using JDBC URL: `jdbc:sqlserver://testServer/sqlexpress;databaseName=testDB;integratedSecurity=true;` `Driver Class: CLASSPATH =.;C:\Program Files\Microsoft JDBC Driver 4.0 for SQL Server\sqljdbc_4.0\enu\sqljdbc.jar` I tried `sqljdbc4.jar` to no avail. I also tried "`com.microsoft.sqlserver.jdbc.SQLServerDriver`" still no luck. Could you please help? Here is the screenshot..