VBA: Create a connection to a OLEDB with user ID and Password

Question

I have created some macros to do some SQL queries into the data-base. My problem comes when I try to create a macro to define the connection. Macro recorder doesn't give any answer and none of the posts I have seen on the internet seem to help me. I need a macro to define the IP of the server and to give the user and password credentials.

Do any of you have any idea or can send a link to a webpage that explain how this can be achieved?

Thank you very much!

check on www.connectionstrings.com which works for ADODB but should work for Excel connections, too. — Kazimierz Jawor
Thank you. Which of all these examples do you think should I use to implement it in my VBA macro? — Martin Router King
on the front page search for provider, and next search for the scenario which is closest to your situation. — Kazimierz Jawor
Possible duplicate of VBA macro save SQL query in a csv file — Ralph
Thank you to both of you for your help and scuse me for the duplicate. I couldn't find any related post before. — Martin Router King

Tianna Wrona Tianna Wrona · Accepted Answer · 2016-11-16T15:57:10

Is this what you are trying to do? This works for me. Just keep in mind you have to switch out the right fields.

Public Const pathName As String = "Driver={Microsoft ODBC for Oracle};" & _
                            "SERVER=serverName;UID=usernameHere;PWD=passwordHere"

VBA: Create a connection to a OLEDB with user ID and Password

1 Answers