PDQ Live! : How Do I Connect PowerShell To A Database?

[@payalkalantri7525]

I am trying to connect to Postgres Db , Implemented exactly as shown however it throws error [IM-002] , Help is much appreciated.

[@pdq]

I'm not too sure, unfortunately. Have you tried connecting via IP Address rather than hostname?

[@captainfuture2882]

I am trying out a few methods. I installed the MySQL connector, but if I try to open the connection I get the error that the file or assembly "Renci.SshNet" could not be found.

[@aham_abhishek]

How can I get these codes. I want to copy this then want to use. Is there any GitHub file or any link or anything where I can get this code?

[@pdq]

We did not initially add these because it is querying a specific DB that we built for the examples. I was able to dig them up. I added them to github.com/pdq/Bonus-Content/tree/master/SQL%20Webcast%20Examples. You will need to set your Server, port, and build your own credentials. -Jordan

[@tfre3927]

I have been trying to connect to MariaDB Connector (Program Files\MariaDB\MariaDB ODBC Driver 64-bit\maodbc.dll) using the add-type as shown and failing miserably :( can't work this out. Any clues? Perhaps it's something Captain Obvious didn't tell me.

[@tfre3927]

After a week of playing around and watching this vid on and off.. I think I just realised you mean the MySQL ODBC 3.51 Driver will work with MariaDB.. so I don't need to use the separate MariaDB ODBC connector... lol oops.

[@tfre3927]

..... got it working lol cheers

[@AgusKurniawan_-iq5gs]

halo, how do you find file .XML??

[@pdq]

In this video the xml we are using for credentials was something that Kris had made, so it was where he saved it. For how he built the credential object, he has a blog here: www.pdq.com/blog/secure-password-with-powershell-encrypting-credentials-part-1/. Other options would use Secrets Management within PowerShell to get the credential when connecting to a database.

[@susandotmark521]

How to make connection to firebird database?? pls reply

[@pdq]

Install the firebird ODBC driver from www.firebirdsql.org/en/odbc-driver/ From there build the connection string(changing the port and everything to match his system.)$connStr = "Driver=Firebird/Interbase(r) driver;Server=localhost;Port=****;Database=*.fdb;Uid=user;Pwd=userpassword;" Then run the query the same way we showed in the odbc section at 2:27