x

Search in
Sort by:

Question Status:

Search help

  • Simple searches use one or more words. Separate the words with spaces (cat dog) to search cat,dog or both. Separate the words with plus signs (cat +dog) to search for items that may contain cat but must contain dog.
  • You can further refine your search on the search results page, where you can search by keywords, author, topic. These can be combined with each other. Examples
    • cat dog --matches anything with cat,dog or both
    • cat +dog --searches for cat +dog where dog is a mandatory term
    • cat -dog -- searches for cat excluding any result containing dog
    • [cats] —will restrict your search to results with topic named "cats"
    • [cats] [dogs] —will restrict your search to results with both topics, "cats", and "dogs"

Office Holiday

Epic Games' offices will be on holiday from June 22nd to July 7th. During this period support will be limited. Our offices will reopen on Monday, July 8th. 

Is it possible to connect to Microsoft SQL Server database

I have a Visual Studio application, currently in vb.net, but could be moved to C#, which uses Microsoft SQL Server SQL Client very heavily.

I am looking to change the UI of my app from a Winform, datagrid-driven experience to a game engine, but still need capability to display small datatables in the UI. Is this possible?

Product Version: Not Selected
Tags:
more ▼

asked Jun 25 '14 at 04:43 AM in C++ Programming

avatar image

LaurenHill
1 1 2 1

(comments are locked)
10|2000 characters needed characters left
Viewable by all users

2 answers: sort voted first

I built a plugin for UE4 that lets me access a MSSQL database from Blueprints in UE4, so it is possible, but you will have to write additional C++ code to get it to work. You cannot use any of the higher level C# SQL libraries like Linq or EF. I used ODBC from C++ and it works great!

more ▼

answered Jun 25 '14 at 03:05 PM

avatar image

Dartanlla
2.6k 62 27 281

avatar image LaurenHill Apr 05 '15 at 03:15 AM

Thanks Dartanlla, I wonder if you could post your C++ code or a mini-project that would show how you did this?

avatar image sameek4 Dec 06 '15 at 04:40 AM

You can use any C# libraries you want in C++. I just did the same through dll import , since I am not from C++ background , I found it convenient to create database operations through C# and use C++ to call the C# function.

(comments are locked)
10|2000 characters needed characters left
Viewable by all users
more ▼

answered Apr 24 '15 at 02:51 PM

avatar image

VinceGee
16 1 3

avatar image Stunt Thumper May 08 '15 at 06:54 PM

Just wanted to mention this here:

SQLite only supports a single writer at a time (meaning the execution of an individual transaction). SQLite locks the entire database when it needs a lock (either read or write) and only one writer can hold a write lock at a time. Due to its speed this actually isn't a problem for low to moderate size applications, but if you have a higher volume of writes (hundreds per second) then it could become a bottleneck.

avatar image VinceGee May 10 '15 at 06:15 PM

That resource is not SQLLite, it is a full blown ODBC C++ connection library. It provides the linkage you need to make a connection to a SQL Server, MySQL Server, or any other ODBC compliant database.

(comments are locked)
10|2000 characters needed characters left
Viewable by all users
Your answer
toggle preview:

Up to 5 attachments (including images) can be used with a maximum of 5.2 MB each and 5.2 MB total.

Follow this question

Once you sign in you will be able to subscribe for any updates here

Answers to this question