VBA to connect sql server (jTDS) , driver : JDBC

Neevan

New Member
Joined
Jul 4, 2014
Messages
3
hi ,

Please help me the connection string to connect DB Visualizer (SQL Server (jTDS)) with JDBC driver.

I am able to connect ODBC driver , below is my coding

Sub macro()
Dim con As ADODB.Connection

Dim rs As ADODB.Recordset

Application.ScreenUpdating = False

Set con = New ADODB.Connection

con.ConnectionString = "driver={SQL Server};" & "server=10.215.22.931;uid=read;pwd=read;database=empdata"

con.Open
Set rs = New ADODB.Recordset
rs.ActiveConnection = con
rs.Source = "SELECT distinct tdd.userid, tdd.CourtKey, tdf.docketnumber , Ind.loginname , Ind.emailaddress FROM tdata(nolock)
rs.Open
Sheet2.Range("A1", "E20000").CopyFromRecordset rs
Above is for connecting SQL using VBA
But i wanna connect dbvisualizer tool using VBA
database type : SQL Server
Driver (JDBC): SQL Server (jTDS)
url: jdbc:jtds:sqlserver://SERVER:1111;DatabaseName=DATABASE;domain=INT

Please help me to connect from excel to hit dbvisualizer personnel 8.0




 

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"

Forum statistics

Threads
1,216,175
Messages
6,129,309
Members
449,499
Latest member
HockeyBoi

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top