DBMS Repository Methodology

[thomaskilian]

SQL Server definitely works better.

According to the documentation: if I were Sparx, I'd rather correct the behaviour than documenting the current state

[sargasso]

Without having read this thread too carefully  (swakal again?) I had I think similar issues with postgres - the schema creation ran like a clock, the database transfer failed, but once the model was successfully transferred (in parts manually) the resutl runs like a tram.


bruce

[austin_hastings]

 In Data Transfer, if I have set the default db in the ODBC connection and I just leave the EA connection details blank, it works and I can export data to that DB.

I'm in the same boat. Thanks for posting this tidbit, since it's the only thing I've been able to find that makes the connection work at all -- heretofore I was trying to use the EA dialogs to configure the connection (go figure!).

I agree, too, with your later point: the ODBC connection should be just that -- a connection. Once the tool connects to the server, why should there need to be a separate DS created for every database? Even if creating databases isn't built in (it should be, with user security!) using them last time I checked required the amazingly complex "USE dbname" SQL statement. How hard is this stuff?

Regardless of how simple (or not) it is to use multiple databases, it's certainly far too hard (and face it: far too buggy) trying to get access to just one.


=Austin

[Molto Mike]

Hi there,

in a different context I also had a lot of trouble with the MySQL OBDC driver.

I then switched from MySQL to PostgreSQL and this works like a charme. (PG is also much more capable and SQL compliant than MySQL!).

Haven't tried EA with PgSQL, but maybe this gives you another option to look at.

Mike

[thomaskilian]

Today I tried again. I managed to open the ODBC connection, named it and was done. Now I can open the repository from EA's startup screen.

Here are my steps:
- Connect to repos
- Select ODBC driver
- Use data source (or Build/New DSN)
- Enter username/password
- Check Allow saving password
- Do NOT use inital catalog!
- opt. Test Connection
- Name the connection for the startup screen
- Voila

Next time you can enter via the startup without problems.