Book a Demo

Author Topic: support for SQL 2008  (Read 2418 times)

pr1smiley

  • EA User
  • **
  • Posts: 33
  • Karma: +0/-0
  • EOD is a Blast!
    • View Profile
support for SQL 2008
« on: December 11, 2008, 05:31:35 pm »
Hello All,

Version  7.1 834 includes support for SQL 2008 stored procedures , however there still is no support for SQL 2008 in the default language dialog .

Thanks

«Midnight»

  • EA Guru
  • *****
  • Posts: 5651
  • Karma: +0/-0
  • That nice Mister Grey
    • View Profile
Re: support for SQL 2008
« Reply #1 on: December 11, 2008, 11:55:40 pm »
Here's a long shot...

I found a similar issue when EA 7.0 (or so) came out. While the product supported SQL Server 2005, only the 2000 version appeared in the dialogs.

It turned out that since DBMS product support is determined by reference data, any projects I had created before 2005 support was added knew nothing about the new product. I needed to take two steps to resolve the issue.

First, I needed to ensure that my EABase project - or any other reference project I used as the 'seed' for a new EA file; this included any DBMS repositories that I set up for this purpose - were updated to the new EA version. This is easy if you do a full installation, but you need to do this by hand if you used a patch file.

Remember that you will have to re-add any customizations you might have made to the seed files after this step.

Second, I needed to update the reference data for any project I created before 2005 support was added. What I did was create a new project - using my recently updated seed file - and export the reference data for DBMS products. I then imported it into my older projects.

I have not checked this out with Build 834, so please let us know what happens if you try it.

HTH, David
No, you can't have it!

pr1smiley

  • EA User
  • **
  • Posts: 33
  • Karma: +0/-0
  • EOD is a Blast!
    • View Profile
Re: support for SQL 2008
« Reply #2 on: December 17, 2008, 03:05:21 pm »
Thanks Midnight, ill check it