Databases in Visual Studio 2012

[souly]

I have created a database in both Microsoft sql and in Visual Studio 2012 but I'm not sure how to connect to the database or run queries. I want this database to be local only, so it will always be on my system.
Does anyone have any links/tutorials I could view? Google is not being my friend.

[razzle]

If you want a "personal database" on your computer you could consider Microsoft Access,

http://office.microsoft.com/en-us/access/

[souly]

I'm actually making a .dll for mIRC. I'd like to be able to store some information on a database and have the data available for view/manipulation during runetime.
I guess my question is, if I make a database in Visual Studio 2012 and create queries for this database, how do I connect to the database and execute the queries I have created?

[zerver]

Are you going to store large amounts of data? If not, you should really look elsewhere. SQL server is a heavyweight "enterprise" product.

You could have a look at: SQLite and MongoDB

If the amount of data is really small, another option is to store it in the windows registry.

[2kaud]

If the amount of data is really small, another option is to store it in the windows registry.

Have a look at using .ini files. See GetPrivateProfileString()/WritePrivateProfileString() or the other private profile functions.
http://msdn.microsoft.com/en-us/libr...=vs.85%29.aspx
http://msdn.microsoft.com/en-us/libr...=vs.85%29.aspx

Another possibility would be to use xml. There are various free XML c++ libraries available.

The choice really depends upon what you want to store and how much and how you want to access it.

[GCDEF]

I'm actually making a .dll for mIRC. I'd like to be able to store some information on a database and have the data available for view/manipulation during runetime.
I guess my question is, if I make a database in Visual Studio 2012 and create queries for this database, how do I connect to the database and execute the queries I have created?

Look at the CRecordset and CDatabase classes.

[souly]

Look at the CRecordset and CDatabase classes.

Thanks I'll look into that and report back.

As to the others I appreciate the help but I could potentially be storing information for thousands of users. If you think this is still small enough to use in .ini let me know. I kind of figured using a ini file would be slow and really painful for retrieving data from users.

Edit:
Im storing data in columns like this: user(str), floodControl, banned(bit), link(bit), points(int), wins(int), loses(int)
this table will be accessed as long as a user is using the bot.

[2kaud]

As to the others I appreciate the help but I could potentially be storing information for thousands of users. If you think this is still small enough to use in .ini let me know. I kind of figured using a ini file would be slow and really painful for retrieving data from users.

Yes, for that volume of data.

[Igor Vartanov]

MS SQL Server Express Edition is a lightweight version of the well known "enterprise" product.

Though MySQL 5 looks same applicable for the task of this size, and same free as well.

SQLite is also fine for this, but not MongoDB which is non-SQL document oriented engine in contrast to true SQL engines above.

[OReubens]

it also depends if you need to do inserts/updates/deletes in the data.

if the data is static you have a lot more options available, including storing the data in const arrays in your code and compiling them into the exe.

If you do need insert/updates/delete, then ini/registry is usable for a few Kb of data (more is inapropriate/slow), xml is feasible up until a few Mb. anything beyond needs some form of database. I'd look at a lightweight embedded solution like SQLite first.

full databases are more complex to install, configure and set up, so this'll be an additional burden to your users, use it only if it really makes sense.

[souly]

it also depends if you need to do inserts/updates/deletes in the data.

if the data is static you have a lot more options available, including storing the data in const arrays in your code and compiling them into the exe.

If you do need insert/updates/delete, then ini/registry is usable for a few Kb of data (more is inapropriate/slow), xml is feasible up until a few Mb. anything beyond needs some form of database. I'd look at a lightweight embedded solution like SQLite first.

full databases are more complex to install, configure and set up, so this'll be an additional burden to your users, use it only if it really makes sense.

So I had some time to work on this and I was able to successfully compile using SQLite however the dll no longer loads into mIRC. Could adding an additional library to the dll cause it to fail? I tried including my dll and sqlite3 lib files and even the sqlite3.dll in the mIRC folder but still no luck. This is the first dll I have made so I'm new to the subject.

Also, if I create a database using my dll like so:

errHndlr = sqlite3_open_v2("test.db", &pDb, SQLITE_OPEN_READWRITE | SQLITE_OPEN_CREATE, NULL);

would the "test.db" be created at the location of my dll or at the location of the executable?