forum question came in. Here my answe, if it helps anyone…
I have not made a video of specifically that plugin, but I have made videos and tools for SQL Server (I’m a Microsoft Partner). Search for Pete Schieck on YouTube. Anyway, I spent some time, but not a lot, with Sameek’s plugin, to prove to myself that it works. I build industrial equipment that can now talk to Unreal (build-a-gizmo.com, we are NOT a big company, we’re just a couple guys)…
anyway, the plugin does work, but it’s hard to find the blueprints that Sameek uses in his sample files. I just needed to see if I could change one of the values he was sending in the query, you know? So, I found the blueprint that did that, and changed the value. You have to do something in Unreal to show all blueprints, because it doesn’t show in the regular blueprint query.
Then, the connection string was the big one. I have been doing connection strings for many years, but it’s alwsts hard, because programmers and companies don’t tend to show fundamentals.
So, I messed around to find my local SQL Express connection string, usually by running a blank .udl file, in Windows. You just make a text file, change extension to .udl, double-click (some versions, you right-click and choose OLE …) on it. Then, you choose your database source, close it. Then, you ‘edit’ the text file (change it back to .txt), and it will have the connection string in it! Weird Microsoft trick.
Put that in the connection string parameter in Sameeks blueprint, and it works. I have a comment in the thread that shows samples for localdb and Azure SQL Servers.
Ask me anything. I’ll see if I can help.
- peace