Error: EA has experienced a network error....

[Emergrin]

Hi:

In the first case i have to apologize for my English, I'm not native (i'm spanish) and I'm not very good with English.

I have a trouble in Enterprise Architect with connection to server DB as project source and I need some help to resolve it becouse I couldn't find answer in internet.

When I connect my EA client with the DB client I always see a same error message: "Enterprise architect has experienced a network error and will close down".

I test the connection in a ODBC driver and I test the connection in a windows's options of ODBC conection in the EA. In the two case the result is ok, or the program lie to me.

I can connect to DB with other software and the conection is ok and I use the DB.

I use a EAUserGuide pdf to configure the program and I'm sure that the program is well configurate like the pdf

I use Enterprise Architect 8.0.863 (build 863) and  PostgresSQL DB 8.4.5 for Windows with use a ODBC driver, 8.4.0200 version. I did test to use a PostgresSQL 9 and her ODBC driver, 9.00.0100 version, but the problem is the same.

I have explained clearly?, Someone can help me?

Thank

[Geert Bellekens]

In these cases this is probably either an issue with the database driver (EA is rather picky in which driver it wants to work with, check the documentation) or an issue with database rights.

Geert

[Emergrin]

How kind of driver do I use to connect to PostgresSQL?, I used the official driver for the DB and I'm testing the connection on the ODBC's properties windows on EA and he said it's ok.

The only different between the EAUserGuide pdf and my EA is the name of the DB... but looking the pdf  I think is a oldest versión that my EA. I will try to change the name to the same of the pdf and I will launch the test again.

Thanks for the answer...

Emer

[Geert Bellekens]

have you seen this page?
http://www.sparxsystems.com/enterprise_architect_user_guide/8.0/projects_and_teams/setupapostgresqlodbcdriver.html

Geert

[Emergrin]

Yes, I followed the document and when I couldn't make the connection I post the problem in the forum...

I solved the problem right now .... I had to give superuser privileges in the DB the user to use to connect.

There really isn't a good policy... Why will could to be a superuser in the server but not a owner of the DB?