Book a Demo

Author Topic: SQL Server Connection  (Read 3413 times)

Krasimir Kossev

  • EA Novice
  • *
  • Posts: 1
  • Karma: +0/-0
    • View Profile
SQL Server Connection
« on: September 29, 2011, 06:05:35 pm »
Hello,

I have a strange issue with the latest EA instance .
[ch1058]he EA is not able to connect to Microsoft SQL Server 2008 R2.

The default driver is not able to connect. The native SQL client driver,
that should be used for SQL server connection is not even included
in the EA installation .

Please help me? Have you been able to connect to SQL Server 2008 R2.

BR
Krasimir

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 13523
  • Karma: +574/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: SQL Server Connection
« Reply #1 on: September 29, 2011, 07:24:27 pm »
Yes,

You can either use the "Microsoft OLE DB Provider for SQL Server" (i think that is the standard driver for SQL2000) or you can modify the connectionstring in the eap file you get when you do "Save As"
Change the name of the driver to Provider=SQLNCLI10 for SQL native client version 10.

Geert