Book a Demo

Author Topic: Has EA been used with SQL Server 2005?  (Read 2595 times)

HenryStock

  • EA Novice
  • *
  • Posts: 8
  • Karma: +0/-0
    • View Profile
Has EA been used with SQL Server 2005?
« on: March 18, 2006, 12:35:31 pm »
I used the corporate script to create an Enterprise Architect DB using SQL Server 2005.

Then I create an ODBC System DSN for that DB

Then I start EA and tried to transfer an eap file to the DB just to see if it could be done.  

I set the values for transfer, I test the connection successfully, but when I hit the transfer button I get the message "Could not open target database".

I am still running on a evaluation system, but I wanted to test this functionality.

Can someone guide me through this?

Henry Stock
Morristown, NJ

thomaskilian

  • Guest
Re: Has EA been used with SQL Server 2005?
« Reply #1 on: March 18, 2006, 01:15:02 pm »
Not sure whether the trial supports other formats than EAP files at all ??? The licensed version does work.

hd

  • EA Administrator
  • EA User
  • *****
  • Posts: 312
  • Karma: +0/-0
    • View Profile
Re: Has EA been used with SQL Server 2005?
« Reply #2 on: March 21, 2006, 01:38:12 pm »
Quote
Then I create an ODBC System DSN for that DB


You need to connect to SQL Server 2000/2005 using "Microsoft OLE DB Provider for SQL Server" as set out in EA Help "Upsizing to SQL Server".

ODBC connection to SQL Server is only for reverse engineering SQL Server databases.