import from microsoft sql server

[Georgiu Konstantinos]

Another issue. I can connect and fetch the tables (structure) of the ms sql server database. But, it popups an error 
error fetching results:

error executing SQLExecDirect
error fetching result
error fetching result
error executing SQLExecDirect
error fetching result
error fetching result
... and so on

What does this mean?

And when i try to see the data with the data browser it popups the same error as above and after some tries studio crashes. It isn't possible to fetch the data? 

It is possible to clone the database, although it creates a banch of side tables because of compatibility issues. In this case how can I import the data then? Some fields with incompatible types (like nvarchar) have dissapeared.

Thank you ,
Kostas

-----Original Message-----
From: valentina-studio-bounces at lists.macserve.net on behalf of Georgiu Konstantinos
Sent: Fri 27/04/2007 12:59
To: valentina-studio at lists.macserve.net
Subject: RE: import from microsoft sql server
 

Thank you for your response. The problem was that I hadn't connect first to the database. 
Now I have another problem that isn't related with valentina. MS SQL Server uses t-sql and the conversion is
problematic. Anyway thanks a lot

Kostas


-----Original Message-----
From: valentina-studio-bounces+georgiu=cti.gr at lists.macserve.net on behalf of Ruslan Zasukhin
Sent: Fri 27/04/2007 09:51
To: valentina-studio at lists.macserve.net; Jochen Peters
Subject: Re: import from microsoft sql server
 
On 26/4/07 11:10 PM, "Georgiu Konstantinos" <georgiu at cti.gr> wrote:

Hi Georgiu, 
 
> Hello,
> I want to ask if it is possible to connect to microsoft sql server and import
> a database to valentina db.

YES, using Import from ODBC source.

> But through valentina studio, and after creating
> an odbc dsn for the server, i do "import" -> odbc but when I check the dsn and
> click next nothing happens. So is it posible? Is it a limitation for the
> unregistered version? What is the problem?

Should work.

Jochen?

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]


_______________________________________________
Valentina-studio mailing list
Valentina-studio at lists.macserve.net
http://lists.macserve.net/mailman/listinfo/valentina-studio


-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/ms-tnef
Size: 3849 bytes
Desc: not available
Url : http://edison.macserve.net/pipermail/valentina-studio/attachments/20070427/f9d96790/attachment.bin