Author Topic: 3065 while transfering to MSSQL (Read 6256 times)

Gobo · « **on:** April 26, 2004, 08:08:19 am »

DAO.Database [3065]
Cant execute select query

I have such error while transfering EAP file to MSSQL 2000. Not at the begining but at about 70% (t_diagrams). I have followed all the instructions (MDAC 2.8, script passed, EAP file checked and valid)

Have anyone any advice??
Gobo

Jeroen_Wyseur · « **Reply #1 on:** May 07, 2004, 12:49:29 am »

I just found out that you have to initialize the database first with a database script. See the following web page:

http://www.sparxsystems.com.au/EAUserGuide/index.html?createanewsqlserverreposi.htm

The script is only available to registered users so no trail here I think!

Kind Regards,
Jeroen

Gobo · « **Reply #2 on:** May 09, 2004, 11:41:39 pm »

Thanks Jeroen, but I followed all the instructions. Without mentioned script the trasfer fails at the begining. In my case transfer stops after a while.

Thanks anyway.
Gobo

thomaskilian · « **Reply #3 on:** May 10, 2004, 01:22:59 am »

Not a very good advice, but would it be possible to delete the diagrams and see if you can import the rest? I had a siminar problem with stereotypes.

yryu · « **Reply #4 on:** December 15, 2004, 10:44:36 pm »

Hello,
I met the same problem.
It is related stereotypes.
I deleted the locale language stereotypes. I use Korean.
It works fine.
I think it is a EA bug to solve.

thomaskilian · « **Reply #5 on:** December 16, 2004, 12:25:33 am »

I actually do not remeber well (too long ago) but there might have been some fix. However, deleting the appropriate sections, transferring and manually (or XML-based) restauration worked for me.

yryu · « **Reply #6 on:** December 16, 2004, 03:31:05 am »

I think you don't have to delete the locale language stereotypes.
I think you can change the locale language to English.

Gobo · « **Reply #7 on:** December 16, 2004, 05:04:02 am »

Hi, I almost forgot this thread...

anyway, I solved this problem and it was my and only my fault!

I imported some classes by Automation Interface and
created diagrams. I set its type as "Class" by mistake. Everything worked fine while it was running local Access Database or MySQL. But MSSQL checks FKs in better way so I change diagram type to "Logical" and that was it. However such situation is strange the problem is solved. (same situation in other EA repository FKs)

By. Be carefull during automation!

thomaskilian · « **Reply #8 on:** December 16, 2004, 05:19:42 am »

Backup? Backup!

Sparx Systems Forum

News: