About

Hello. My name is Peter House (Twitter: Peter_House) and I currently work as a public sector IT manager in Alaska. I hold a couple of Microsoft certifications for database administration (947689/31415926). I have other professional passions outside of mathematics and databases but this blog really focuses on logic and data.

The tools that I choose to use are Mathematica and SQL Server 2008. SQL Server and Mathematica both have phenomenal communities and documentation. I would highly recommend them to anyone.

I chose the name, “Cold Logics” for my blog because I live in Alaska and the blog focuses on playing with logic via Mathematica and SQL Server. It’s unbelievably difficult to come up with a good blog name. Months down the road I’ll think of a really good one but it’ll be too late!

Oh, and sometimes I create Mathematica demonstrations too!

Leave a response and help improve reader response. All your responses matter, so say whatever you want. But please refrain from spamming and shameless plugs, as well as excessive use of vulgar language.

12 Responses to “About”

  1. George

    Hi Peter, I too use Mathematica and MS SQL Server. I am becoming increasingly frustrated trying to connect to to SQL Server 2008 (straight or R2) on my 64-bit Windows (7 and Vista) machines. I have no problem with 2008 R2 on Win 7 32-bit machine (or 2008 on XP 32-bit) when both are 32-bit apps. However, on my 64-bit machines – it just doesn’t work.

    Have you any experience with Mathematica v8 as a 64-bit install (on Intel x86-64)?

    (I only just found your site – so I have not spent much time reading your posts. But it looks like you are doing a great job).

    • phouseak

      Hello, George,
      I’m glad you find this site! I look forward to hearing about your experiences further. I’m using Mathematica and SQL Server 2008 on my 64-bit Windows 7 computer. What sort of problems are you having? Any errors of note?

  2. George

    Hi Peter,

    Well, just paint me stupid. After commenting on this to you, I went back and tried using DatabaseExplorer to setup the connection – and voila! it worked. Previously, I had been creating the odbc connections thru Windows Data Sources and I never succedded. So your screen shots using the mathematica DatabaseExplorer GUI prompted me to give that method a try. Great!

    But I do have a question about non-local, named instance access. I can get to – for example “Nazgul” (the default 2008 install) but I cannot seem to succees in entering “Nazgul/SQL2008R2” (which is the name of my R2 named instance instaled on the same machine (i.e., Nazgul). I tried using double slashed (both forward and backward – but no luck. Have you experience in accessing a second instance?

  3. phouseak

    George, I haven’t tried connecting to a non-default instance of SQL Server yet. I would try using an inline connection from your notebook as described here: http://wp.me/p1ays3-1C

    I intend to install a new instance of SQL Server on my laptop here shortly but it’s going to be SQL Server 2011 “Denali”. Have you had a chance to download and fiddle with Denali? If so, what do you think?

  4. George

    Peter, No, I have no experience with Denali. I am not able to connect with the inline connection. It appears that Mathematica is expecting the database name immediately following the instance name (that is, the parser is only accepting a single ‘slash’ separator, e.g., INSTANCE/database…. so an attempt to use HOST/NAMED_INSTANCE/database does not work.) I tried escaping a backslash version (e.g., HOST\\NAMED_INSTANCE/database) and variations on that theme. But that did not work. I will call Wolfram Support and query them and let you lnow the result. Thanks, George

  5. phouseak

    I’m certainly interested in the outcome!

  6. George

    Peter, The syntax for a named instance is as follows:

    OpenSQLConnection[
    JDBC[“Microsoft SQL Server(jTDS)”,
    “Host:1433;instance=instancename”],
    “Username” -> “user”, “Password” -> “$Prompt”]

    Be careful not to leave a space between (“…Server(jTDS)”) in the driver string (which is what happens if you cut-and-paste” from the DatabaseLink reference for SQLServer in the online help.

    Good luck with Denali !

  7. phouseak

    Hey, that’s great. I’ll update my blog post. Thanks!

  8. phouseak

    I finally got around to it and I’ve added your notes on how to connect to a non-default instance to https://coldlogics.wordpress.com/2011/01/24/connecting-to-sql-part-ii/.

  9. MGQ

    My friend, I’m using Mathematica to connect to databases, but I am new to databases. I’m unable to connect Mathematica to Microsoft access databases. Could you help me with that? Also, what I’m planning to do is a product selector similar to the one present in the Nissan website http://www.nissanusa.com/buildyournissan/?fromSav=true where you can set parameters to find the best car for you; however, I’m becoming frustrated in saving images in this database. Do you know any workaround this? Lastly, do you know of a way to create databases in a easy way and then manipulating them in Mathematica? Could you make a .nb example available for us? Thank you my friend!

    • phouseak

      MGQ, I don’t have a lot of experience with Access but I would recommend setting up an ODBC connection and then directing Mathematica to use that. If you search for the term , “ODBC” on this link, you will find the documentation you are seeking: http://reference.wolfram.com/mathematica/DatabaseLink/tutorial/DatabaseConnections.html

      As for saving images in a database, you have two options (double check with Access as there are many differences between SQL and Access but the principle is likely the same): the first option is to try and save the image in a column of a datatype as binary or you can store the images on the filesystem and track their location via the database. A quick Bing search turned up the following link that would be useful for you: http://office.microsoft.com/en-us/access-help/store-images-in-a-database-HP005280225.aspx

      Good luck!

      • MGQ

        Bing search! never heard that one (i use google). well, thanks for answering i kind of gave up in using databases. i get confuse with having to explicitely state what kind of information will go on each place, so in mathematica im using metatags as my stored data and im able to filter, sort, etc with the metatags actually much faster than with the database.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s