Could not install latest build

[GoogleCodeExporter]

Tried to install first the client then the server.  OML Database editor 
said it could not connect to server.  Tried to install MS SQL Server 2008 
Express, said it could not since I had SQL Server 2005 Express.  Could not 
find SQL Server 2005 Express anywhere to uninstall it.  I do however have 
SQL Server 2005 installed.

Reinstalled the previous version, but now the OML Database editor is a few 
versions behind and doesn't allow for the selection of fanart.

Original issue reported on code.google.com by thoml...@gmail.com on 28 Aug 2009 at 1:10

[GoogleCodeExporter]

Getting sql server 2k8 and 2k5 is not a directly supported feature.  Im 
surprised that 
this would be a problem but I would consider reviewing Microsofts sites for a 
possible 
solution.

What is the previous version you re-installed? 0.3?

Original comment by DJShultz@gmail.com on 28 Aug 2009 at 5:54

• Changed state: Accepted

[GoogleCodeExporter]

Yes, it was 0.3.

Original comment by thoml...@gmail.com on 28 Aug 2009 at 1:36

[GoogleCodeExporter]

BTW, Does OML require that the DB be 2K8?  Does it use any special features of 
2K8?  
If not, couldn't I just create a 2k5 datasource and catalog?

Original comment by thoml...@gmail.com on 28 Aug 2009 at 1:38

[GoogleCodeExporter]

I beleive the method used to access the database Linq to SQL required sqlserver 
2008.

Original comment by mikem...@googlemail.com on 28 Aug 2009 at 7:07

[GoogleCodeExporter]

I have verified that linq DOES work with sql server 2k5.  You should be able to 
use the 
.sql files from the source repo to create the database, then modify your 
\programdata\openmedialibrary\settings.xml file to point at the correct 
instance/machine and you should be good to go.

I'm going to assume this issue is closed (we don't officially support 2k5 but 
it should 
work as far as I can tell, also issues with 2k5 and 2k8 on the same machine 
fall under 
the domain of MS).

Original comment by DJShultz@gmail.com on 28 Aug 2009 at 9:34

• Changed state: WontFix

[GoogleCodeExporter]

That last part is not a good thing to say.  The company I work for, we have 
client 
on SQL 2K through SQL 2k8.  We still have to make certain that our apps work 
for all 
of them.  I think it would be better to look for a SQL Server that meets a 
minimum 
standard and offer to install the DB there if nothing else.

Original comment by thoml...@gmail.com on 29 Aug 2009 at 4:02

[GoogleCodeExporter]

Well none of that worked.  I went throught the process of manually creating the 
db, 
downloading the scripts, running them on the DB, reinstalling the server, and 
still 
I am getting the same thing.

Original comment by thoml...@gmail.com on 29 Aug 2009 at 5:10

• Changed state: HelpNeeded

[GoogleCodeExporter]

to comment 6: i also work for a company that requires I continue to support ie6 
and 
it sucks.  OML is not a company, nobody pays for our stuff, and no warranty is 
offered, implied or otherwise in place.  We decided to go with 2k8 and I can 
assure 
you we considered many options for quite a while.

to comment 7: can you show here your settings.xml file from 
\programdata\openmedialibrary\

Original comment by DJShultz@gmail.com on 29 Aug 2009 at 6:54

[GoogleCodeExporter]

Unable to reproduce the SQL2k5/SQL2k8 issue. My copy of the OML SQL instance is 
on a 
box with SQL2k5 ENT. 

PLEASE NOTE: Although Linq does somewhat "work" under SQL 2k5, it is not 
supported 
fully and will result in requiring additional hand-coding of the dbml files to 
prevent casting errors. Search the forums for my initial testing around this 
(I'm 
not providing a link because it was a long time ago and I don't feel like 
digging). 
Minimum SQL requirements are SQL 2008.

Original comment by davidtj...@gmail.com on 6 Sep 2009 at 4:33

• Changed state: Invalid