Problem when I try to connect SQL server

[agrizhnevich]

Hi, All

I want to ask you about next problem with Enterprise Architect and SQL server. I try to connect SQL server from EA 6.1 and try to transfer data from DBMS to EAP.
If I test connectiton, that's OK, but when wizard finished, it gives error
 - Enterprise Architect has experienced a network error and will close down

I have tried also SQL Native Client (it tests OK too) but then fails with
Invalid Data Source/ You must provide a connection name.

I can't see any place where I can provide it.

Anybody using EA and can share some info?

Thank you
Best regards, Alexandr

[«Midnight»]

I had a similar problem some time ago. It was around the time that EA 7.0 came out (one side or the other) but this could still apply.

It turned out that the script I had used to set up the database schema was out of date. The apparent version number was the same but the schema produced a similar result when I tried to connect.

Using a newly-downloaded script fixed things up.

However, I still had a problem connecting to some servers in the organization. We did not get that resolved, though I think it had to do with incorrect credentials. Have your DBA verify that your account - including domain account you might have on the target domain - has the necessary privileges to access the schema for read and write.

Let us know...

David

[canderson]

I can't comment on your original problem but I can confirm (that in my experience) the Native SQL client doesn't work.

You hit the test connection button and the connection is fine - it's just EA doesn't like that connection provider so the transfer fails.

Similarly, it's the same deal with Oracle - you have to the use OLEDB provider written by Oracle or you get the same error message.

Maybe someone can comment on the accuracy of what I'm saying as this is purely based on my experience?

Anyway, hope it helps if only a litte.

CA.

[«Midnight»]

I can't comment on your original problem but I can confirm (that in my experience) the Native SQL client doesn't work.

You hit the test connection button and the connection is fine - it's just EA doesn't like that connection provider so the transfer fails.
...

Just a thought...

What happens if you try connecting through a 'generic' provider (perhaps one of the non-specific OLEDB or ODBC providers) instead of the SQL Server provider?

Note that I did not try this when I was having the SQL Server problem. I was working on a client's network and did not tinker with configuration issues.

[Dave_Bullet]

The data link types available I know of for connecting to SQL server from EA are:
1. Microsoft OLE DB Provider for ODBC Drivers
2. Microsoft OLE DB Provider for SQL Server
3. SQL Native Client

I get crashes with 1. and 3.  Only 2. works reliably for me.  Which version of SQL Server are you using?  If your client and server are SQL2K SP4 or greater (I've also tried SQL2K5 SP1) then you are ok.

David.