I just installed Microsoft Visual Studio 2008 Express edition, and it installs some sort of stripped down version of SQL Server. It comes with no tools for connecting to your "local" database, creating tables, etc., but it does allow you to create database files in SDF format within the IDE.
My question is: How do you then connect to these database files in Perl? I tried creating an ODBC connection, but there seems to be no way to tie an ODBC alias to this file. I've searched the web in vein trying to a way to make a connection to this file directly, but to no avail.
In short, I want to create a database connection to a file called Database1.sdf, which has a table in it called 'entry', and then query the table.
I had hoped it would be as easy as connecting to an Access file, but not!
Any help would be appreciated. Thanks.
Bob.