Connect to DB SQL Server via driver JDBC

[Mpozzi59]

I would like to connect from VBA excel to a SQL Server DB through the JDBC driver. Can someone help me.

 

[CSmith]

Look here

 

[Mpozzi59]

I downloaded the jdbc driver but I can't interface it with the VBA.
I can't place the dll in the VBA references

 

[CSmith]

I downloaded the jdbc driver but I can't interface it with the VBA.
I can't place the dll in the VBA references

I believe all you need do is instantiate a connection correctly specifying it use that driver in your project (not VBA) . . . JDBC is for java project connections
You don't need JDBC for SQL connection through VBA . . .

You should have read the link I sent above.
Here is a link to connection strings for connecting to SQL server. . .

 

[Mpozzi59]

Thank you very much for your suggestions that made me realize that I was on the wrong way to solve my problem.
Now my sw works perfectly and interfaces very well with the DB Sql Server.
Thank you.

 

[CSmith]

Welcome and thank you for the feedback!