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
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