EA with PostgreSQL on a Linux/Crossover environmen

[mpserafim]

Hello,

We have installed a version of Enterprise Architect (6.1 Linux build 788) on a Fedora Core 5 with Crossover 4.1. The product works nicelly.  :)

But we're having a problem to integrate EA with a PostgreSql  database (8.1.3). After the installation and configuration of the Postgres ODBC driver (8.01.02.00) following the User Guide (http://www.sparxsystems.com.au/EAUserGuide/index.html?setupapostgresqlodbcdriver.htm), EA can connect and get the database information. It's possible to open, navigate and delete on any project but not to update or create new objects.

EA show some error messages like:

"-2147467259" - Insufficient base table information for updating or refreshing.
"-2146825069" - ADODB.Recordset. Operation is not allowed in this context.

Data transfer to DBMS shows error too:

"-2147467259" - Insufficient base table information for updating or refreshing. Field: cardinality

On a Windows OS, the PostgreSql ODBC driver and EA works perfectly.

Is there some incompatibility of the PostgreSql driver and EA on a Linux/Crossover environment?

Thanks in advance.

--
Marcos Paulo Serafim
Analista de Suporte Tecnico / Support Analist
Orlandia/SP - Brazil

[sargasso]

Postgres version?  and is it runnng on the WinOS or the Linux server.  Your problem likely lies in the postgres area rathe than EA.
hth
bruce

[mpserafim]

Server: PostgreSql 8.1.3 running on Debian 3.0 (Woody)

I think the problem is with the group "EA+Postgres ODBC+CrossOver", because when we do "EA+Postgres ODBC+Windows" everything works fine.

[«Midnight»]

Of course you could always try it with a new (Intel) Mac, the Boot Camp beta, and Windows XP...

Somebody has to try this. Otherwise we can all wait for Leapard (OS X 10.5) to come out, as it will come with a (probably non-beta) version of Boot Camp.

Doesn't exactly solve your problem, but there's been enough OS interest hereabouts that it's worth mentioning.

BTW, some unofficial - and less than comprehensive - benchmarks on the above configuration are pretty interesting. Performance appears to be similar to a 'raw' XP installation.

Now, back to Linux. Any possibility that the Crossover version you have is different than what Sparx used? Also, outside of working with EA, any other issues with PostgreSql, either on their site or your installation? In particular, look for ODBC issues. Also, is there an OLEDB driver for PostgreSql yet? Perhaps that will work, although it might not help you if you are importing a database schema.

Let us know.

[mpserafim]

EA don't let me register a "PostgreSQL OLE DB" connection, saying "Invalid Data Source...Check configuration".  

[«Midnight»]

That pretty much cuts EA off, I'd say.

Can you create a data source from the Control Panel? You might be able to work from there.

Also, just to be sure, did you remember to run the SQL script from Sparx to create the tables and load core reference data? If you don't you tend to get various strange (often very strange) errors when you try to connect from EA. [This is certainly true with SyBase, MS SQL and Oracle; I've not yet tried PostgreSql.]

David

[mpserafim]

Yes, I did all of this stuff. And yes, I made a load of data from a Windows installation and there everything works perfectly.

I have been playing with the Crossover's ODBC settings, looking logs and changing settings but the error don't go away.  :-/

Of course could be the Crossover version ... but what version would be the right one? (mine is 4.1)

[sargasso]

EA don't let me register a "PostgreSQL OLE DB" connection, saying "Invalid Data Source...Check configuration".

Slightly sideways of a solution but whjat are trying to use as the OLEDB driver for postgres?

b

[«Midnight»]

Are you attempting to connect to PostgreSql through the automation interface or manually through the File / Open Project dialog?

If you're using the automation interface you need to add a prefix to the connection string. Open the PostgreSql model by hand. You will be prompted for a model name. Then close EA. Open EA again and look at the File menu. Usually (for some reason) the model you opened will be listed as "2" at the top of the most recently opened models (at the bottom of the File menu).

You will notice the name you had to give the model earlier, followed by " --- " (no quotes, but spaces significant) and "DBType=x;" (again no quotes, but the 'x' will be a numeral [I don't remember which it is for PostgreSql] and the semicolon is required). This prefox must precede your connection string to open the model via automation.

Other than this I'm running out of ideas.

David

[mpserafim]

Hello David, thanks for the tip.

I did what you said and I could register the project on EA.

Now when I open the project with PostgreSQL OLEDB Driver EA shows "Loading Project..." but nothing happens. No connection is established with the database (tried on Windows).

In the meantime, I have upgraded the Crossover version to 5.1 (latest) and everything got worst, , now when I try to connect to database I receive the message: 0x8000ffff (Catastrofic failure) and EA crash.

Well ... I think I'll give up.

Thanks for all your help!

Warm hugs!

[«Midnight»]

Are you constrained to work with PostgreSql? What about MySql? Or perhaps see if you can get an Oracle 10g Express installation working in native mode on your system. [I recently got EA working with this product on Windows. It's free and seems to work pretty well.]

[mpserafim]

Do you know if EA works with IBM DB2 like server repository?

[«Midnight»]

Certainly not 'officially' in the way it does with Oracle, PostgreSql etc.

EA internally recognizes several databases - the DBType parameter in the connection string - and knows how to navigate the appropriate schema and syntax for each. As I mentioned I have had complete success (as far as I've tested to this point, so take it with a grain of salt) using Oracle 10g Express.

I have used EA with MS Sql Server 2005 with very mixed results. I think that in this case the problems related to a silent failure of other MS tools provided to manage SQL Server 2005 that occurred concurrently (but unrelated to) with the EA test period, and do not have answers from MS on this yet. Several other forum members seem to be having no trouble on this platform, and I expect to see it out 'officially' from Sparx soon.

Quite a while ago I ported EA 4.1 to Sybase SQL Enterprise (versus SQL Anywhere). Not much difference between the products, but there were a few small hurdles. Once cleaned up it worked like a charm through both the UI and the automation interface (and I pushed it pretty hard).

All that said. I'd like to see Sparx implement EA on a few platforms that have recently become available for free. Chief among these is DB2 (since SQL Server 2005 and Oracle 10g Express are sort of upgrades I have not included them in the priorities). Another would be Ingres. Another poster was quite recently asking about SQLite, but I don't know whether that engine has all the features required to effectively support EA. [That's not to suggest it wouldn't have the ability, I just simply do not know anything detailed about the product.]

TTFN,
David

[mpserafim]

Thanks again!!!

[«Midnight»]

Marcos,

I just noticed that this board has a new post from someone who got a Linux installation running. No great surprise there, but I did notice something that: was obvious, and I forgot to ask.

On a long shot, did you remember to install DCOM95 from Microsoft?

David