Book a Demo

Author Topic: How Connect to Sql Server  (Read 5551 times)

pegah

  • EA Novice
  • *
  • Posts: 8
  • Karma: +0/-0
  • I love YaBB 1G - SP1!
    • View Profile
How Connect to Sql Server
« on: May 28, 2007, 08:21:07 pm »
 Hi.

I want Connect to Sql Server 2000/2005.I connect to it and  testconnection is ok.but when i click ok button in "connection name & type menu" and set my database name .i get this error "Invalid Objcet name usys_System ".

can you help me?


and if i must create a repository in sql server?
or if i must install MDAC 2.6 in my computer?


thanks very much.

Eve

  • EA Administrator
  • EA Guru
  • *****
  • Posts: 8110
  • Karma: +119/-20
    • View Profile
Re: How Connect to Sql Server
« Reply #1 on: May 28, 2007, 08:51:00 pm »
You'll need run the setup script available on the corporate resources page to setup the tables.

«Midnight»

  • EA Guru
  • *****
  • Posts: 5651
  • Karma: +0/-0
  • That nice Mister Grey
    • View Profile
Re: How Connect to Sql Server
« Reply #2 on: May 29, 2007, 03:44:40 pm »
Once you do so, remember to do a project transfer from a base project in an EAP file to your new schema. This will 'initialize' the new schema, which must happen before you can use it to store a model.

You can do this from the EA main menu via Tools | Data Management Project Transfer. When you start the transfer process EA will coordinate with Windows and walk you through the connection process.

David
No, you can't have it!