import from microsoft sql server

[Jochen Peters]

Hi Georgio,

> 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
>

This happens during IMPORT?
Or during fetching of database structure?

Have you choosed to let Studio create alll necessary tables for you?
Have you checked all new tables? Have you checked the field mappings  
for each table?

To isolate the problem it would be helpfull to know WHICH table and  
WHICH fieldtypes causing it.
Maybe it is possibel to import the tables ONE by ONE to see which one  
causes the trouble?



> 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.

I do not understand this - you only can clone Valentina 2 databases -  
not ODBC databases - (at least not with vStudio). So - what you mean  
with cloning here?
And what "side tables" ?

Another possibility to import data is to export them first to text- 
files and importing these text-files using Valentina Studio#s Import  
Wizard.

-- 
Best regards,
Jochen Peters
PIIT GmbH

------------------------------------
http://www.valentina-db.de

>
> 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
>
>
> <winmail.dat>
> _______________________________________________
> Valentina-studio mailing list
> Valentina-studio at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina-studio