Solved.
I`ve tried to use jTDS driver. Everething is working fine now :)
>Yes I do. Theese are: dbo, guest, INFORMATION_SCHEMA, system_function_schema. That`s all.
>
>>I don't keep my Windows test box online, so I can't check this right
>>now, but AFAIK 'dbo' is one of the schemas in Java terms.
>>
>>When you are doing reengineering, Cayenne presents a panel with
>>schema selections (ok, "schema" is what the driver thinks is "schema"
>>on the target DB, whatever it might be called by the DB vendor). Do
>>you see any other choices in this dropdown besides 'dbo'?
>>
>>Andrus
>>
>>
>>On Nov 24, 2005, at 4:10 PM, noban wrote:
>>
>>> Looks like there are no such concept as 'scheme' in MsSQL2000, at
>>> least I was unable to find it. 2000 server have only different
>>> 'data bases' looks they work as 'schemes' one DB server can have
>>> multiple 'data bases'. So all my tables are located in the same
>>> databases (by name) in both my and main DB servers. They all have
>>> the same owner - dbo. And they all are - user tables. Thats all I
>>> was able to find. I can`t find any other differencies.
>>>
>>>> Likely this has something to do with your default schema on each
>>>> server. IIRC schema name on MS SQLServer matches the user name you
>>>> use to log in. So the tables probably exist, only in some other
>>>> schema... Just a guess - you can browse different schemas in the
>>>> Enterprise Manager to confirm that.
>>>>
>>>> Andrus
>>>>
>>>>
>>>> On Nov 24, 2005, at 2:46 PM, noban wrote:
>>>>
>>>>> Actually I`ve tried to create test table on DB server using its
>>>>> (server) MS EnterpriceManager. The same result.
>>>>>
>>>>> Does anybody have some hints?
>>>>>
>>>>>
>>>>>> Hi!
>>>>>>
>>>>>> Recently I have reinstalled my MsSQL, it works fine. I`ve loaded
>>>>>> my dev. DB from the server and added couple of tables. Also I`ve
>>>>>> exported these tables to Main dev server. So now when I`m
>>>>>> launching Cayenne modeller on my machene it reengeneers only
>>>>>> system tables, and when on main DB server it reengeneers only old
>>>>>> tables without new exported one`s. I`ve tried both 1.1.3 & 1.2.M7
>>>>>> - the same result.
>>>>>>
>>>>>> As I remeber now My old configuration on my machine was MsSQL2000
>>>>>> SP3, as well at server, but my new configuration is MsSQL2000
>>>>>> SP4a. Can this (SP4a) be the cause?
>>>>
>>>
>>>
>>> --
>>> Сегодня удачный день, чтобы завести
>>> почту на Яндексе http://mail.yandex.ru
>>>
>>
>
-- Яндекс.Почта: объем почтового ящика не ограничен! http://mail.yandex.ru/monitoring/
This archive was generated by hypermail 2.0.0 : Wed Nov 30 2005 - 04:52:48 EST