Invalid Data Source

[Marko Filipovic]

Hello,

I am trying to create a PostgreSQL data repository for EA. I have followed instructions from the section "Create a PostgreSQL Repository" in the manual:

• set up ODBC connection
• run scripts to populate the database
• connect to server from EA.

Driver connection test says that the connection is OK. However, when I try to connect from EA, I get the message "Invalid Data Source..."

I am using PostgreSQL version 8.3. and EA 7.0.817 corporate edition.

Any idea what the problem is?

Thanx,
Marko

[hd]

You need to transfer a model to the repository before a connection will succeed.

[«Midnight»]

In case you're not used to this procedure...

You can do this from the main menu. Use Tools | Data Management | Project Transfer. You do not need to have a project open in EA to perform the transfer, nor do you have to close the current project if one is open. You will need a source and target for the transfer; use the Transfer Type radio buttons at the top of the Project Transfer to determine where EA will look for these, then use the browse ("...") buttons to identify the source and target.

Before you do a transfer, you can create an empty project, or one with default settings appropriate to your local (corporate or personal) preferences. This is the 'seed' configuration that will be transferred to your repository.

HTH, David

[Marko Filipovic]

Hello David,

thanks for your response. I have tried to transfer an empty project to DBMS as described. But, when I press the "Transfer" button, I get the error message "Could not open target database".

I can't say what is going wrong. All tables in the database are created. Connection test says everything is OK, but in the ODBC driver log the following line appears any time I select the driver as a target project:

CONN ERROR: func=PGAPI_GetInfo, desc='', errnum=-2, errmsg='The buffer was too small for the InfoValue.'

Am I still overseeing something?

Best regards,
Marko

[«Midnight»]

Things to check...

First, which DBMS are you using? Have you ensured that you used a fresh - as in recently downloaded - script to create the repository?

Have you ensured that you have privilege to connect to the repository, and to create records? I know these are pretty obvious question - "are you sure the computer is plugged in?" - but sometimes that's the problem?

What build of EA are you using? What version - major and minor - of the DBMS are you using? The same goes for client (and perhaps server) side drivers. [As examples, EA can be sensitive to Oracle drivers from MS, and MySql has failed with some driver versions but not others.]

David