API versus SQL Repository

[TomVercauteren]

in stead of connecting to a file, I need to connect to SQLServer.  Anyone got an idea of how to do it?
I connect to a file using:
EARep = New Repository
EARep.OpenFile("C:\SomeRepository.eap")

But how do I fit the actual connectstring in there: Provider=sqloledb;Data Source=SERVER;Initial Catalog=EnterpriseArchitect;User Id=sa;Password=;
-------------------
(Reply does not work, so I edited my original post)

The solution below works fine, thx.
Only,... any request to the SQLServer doesn't get through, it seems...

This works fine:
       Dim EARep as New Repository
       EARep.OpenFile("C:\Localfile.eap")
       Dim EADia As Diagram
       EADia = EARep.GetDiagramByID(1)

I copied the EAP to the SQL, so it holds exacltly the same model.  Yet, this does not work:

       Dim EARep as New Repository
       EARep.OpenFile("MYSERVER --- DBType=1;Connect=Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=EnterpriseArchitect;Data Source=MYSERVER")        
       Dim EADia As Diagram
       EADia = EARep.GetDiagramByID(1)

[«Midnight»]

Hi Tom,

Siince I've stubled over this one twice (slow learner) myself I can certainly help.

EA requires that the "connection string" passed to the API be prefixed with a few characters. What you need is the 'user friendly' name you have given the model when you first created it, followed by a space, three dashes, and another space. You can get an example if you open a repository-based model in EA and then exit and restart EA. Look at the File menu and note how the model you references (probably as "2" in the list) is referenced; that is your connection string. Note that you want this string (or at least the prefix) exactly - punctuation, whitespace and capitalization all seem to count.

Once you've got this trick down you can adjust the balance of the parameters to suit your purposes, as you would any other OLEDB (or ODBC) application.

BTW, you can also open an EAP file this way. Simply use the appropriate provider and such in your connection string.

HTH, David

[colo]

Hi Midnight!
Could you bring me some example please?
I need open a SQL Server Repository from VB..
Thanks in advance..

[«Midnight»]

Colo,

I don't have an example handy just now and am trying to dash out the door.

Take a look at the File... menu from the 'human' UI to EA after you've opened and closed your SQL repository by hand. You'll see an entry - usually number 2 if you've just opened the repository - with the name you gave the repository, followed by " --- " (spaces included, but not the quotes) and then the ODBC or OLE connection string EA used to open the model.

When you open the repository from VB, use the string above (the whole thing including the name, punctuation, and connection string) instead of a file name. EA should open the repository and you'll be in business.

David

[alesliehughes]

A trick you can use. Connect to you DMBS, and select "File --> Save Project As", enter a Filename.

Now to connect, all you have to do is.

Dim EARep as New Repository
EARep.OpenFile("filename.eap")


Alistair