Error in loading Model from DBMS-sql server

[yiki]

I'm getting the following error when I try to load my model from the database. (we just setup the database using the script provided for SQLserver on sparkx's stie, and I was trying to upload my model for the first time after it has been succefully transfered from .EA to DBMS)

[highlight]An error has occured loading the requested object.
Microsoft OLE DB Provider for SQL Server [-2147217900]
Cannot resolve the collation conflict between
"SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS" int equal to operation"[/highlight]

Appreciate any help and suggestions
Thanks

[qwerty]

What do you mean by "upload your model"? I understand it has been transferred from EAP to SQL Server with no problem. Now you open it? Or  what?

q.

[yiki]

Sorry I mean load not upload
thanks

[yiki]

or open "_

[qwerty]

I *guess* its something wrong with the schema creation script. AFAIR there are different versions. Check whether you used the latest from Sparx. If so you should contact Sparx support directly.

q.

P.S. What DB connection do you use? The native SQL Server or ODBC?

[yiki]

Thanks, for the reply. The problem was that we first ran the script and then we changed the Collation. so we tried to change the collation first and than run the script and it works.

Thanks

[yiki]

Once we transfer a .EAP to the DB, we cannot transfer another .EAP to the same DB again right?

[hd]

Correct. Each project transfer will blow away the existing SQL Server repository.