Setting up SQL Database

[sic0048]

I'm an idiot when it comes to databases.  That being said, there use to be a nice "how to" about how to set up an SQL Express database to use with the DB Logger driver and graphmatic.  I use to have this all working on an older system.  I had to change servers however and I never got the DB up and running.  I'm finally sick and tired of seeing my blank graphmatic images in my IV that I started to play around with creating a database.  I didn't get very far.

I have MS SQL Server 2014 running on my CQC machine now.  I created a database called "CQC_Blank_DB".  However I am lost as to what the next steps are.  I created a new table called "DataLogSchedule" but I don't know the next steps or even if this table has been created correctly.

Does anyone still have the old instructions or would be willing to walk me through creating a new DB that will work?

Thanks!

[sic0048]

Looking at the DataLog DB driver details, I think I needed to add a second table (called DataLogValues) and a "clustered index".  Below is a screen shot of my work.  Hopefully someone can tell me if it's right or not.

[Dean Roddey]

Here's the driver thread, which hopefully would have the instructions in there?

https://www.charmedquark.com/vb_forum/sh...ata+logger

[sic0048]

OK, like I said I'm an idiot when it comes to setting this up..... I had read that thread before, but totally missed the first part about setting the DB up. DOH!

That being said, I've successfully set the database up (parts 1-3) as well as set up the ODBC connection (part 4) on the same computer that runs CQC and the database. In step 4, when I create the ODBC connection and in the last step I "Test Data Source" I get a positive "Tests completed successfully" message. However, when I attempt to install the Data Log Database driver, there are no "Available ODBC Sources" to choose from. Clearly there is a disconnect happening somewhere. I think the database is up and running properly, but CQC cannot see the database to connect to it.

I restarted the CQC service and there was no change in this behavior. Any suggestions?

Thanks!

[Dean Roddey]

There are various wierdnesses about ODBC sources when it comes to where they are accessed from and the 32/64 bitness involved and the 32/64 bitness of the Windows version you are on. CQC is a 32 bit program so you may need to create a 32 bit ODBC source.

Here are some related threads in the How-To section:

https://www.charmedquark.com/vb_forum/sh...p?tid=5751
https://www.charmedquark.com/vb_forum/sh...p?tid=5751