Hi,
Is there anyway we can connect MS SQL Server 2008 R2 with EDB Server.
I tried importing the data but there is no way importing data from EDB Server to MS SQL Server.
can you suggest any way to do this.

shahjaufar


>Is there anyway we can connect MS SQL Server 2008 R2 with EDB Server.
>I tried importing the data but there is no way importing data from EDB Server to MS SQL Server.
>can you suggest any way to do this.

What can MS SQL Server import? eg csv, excel.....

Roy Lambert [Team Elevate]

>What can MS SQL Server import? eg csv, excel.....

It can import csv and excel files too, i want to create a direct connection between ElevateDB Server and MS SQL Server.I have used the ODBC to connect it gives me this error msg

Error 0xc002f210: Preparation SQL Task 1: Executing the query "CREATE TABLE [dbo].[Invoice] (
[Number] int,
[Tr..." failed with the following error: "Incorrect syntax near '8'.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

If i use ElevateDB 2 .net Data Provider i get this error msg
TITLE: SQL Server Import and Export Wizard


An error occurred which the SQL Server Integration Services Wizard was not prepared to handle.
ADDITIONAL INFORMATION:
Exception has been thrown by the target of an invocation. (mscorlib)
The given assembly name or codebase was invalid. (Exception from HRESULT: 0x80131047) (mscorlib)

is there any other way that i could direct connect to MS SQL Server ?

<< Is there anyway we can connect MS SQL Server 2008 R2 with EDB Server.  I
tried importing the data but there is no way importing data from EDB Server
to MS SQL Server. can you suggest any way to do this. >>

Are you using the 32-bit or 64-bit version of SQL Server 2008 ?

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim,

<<Are you using the 32-bit or 64-bit version of SQL Server 2008 >>

I am currently using SQL Server 2008 R2 32bit version.

Tim,

I found the error
MS SQL Server had a problem importing blank fields where the data had to be converted to another data type.
And there were a datatype mismatch.The only thing i could do was to use a query to retrieve the data of the required data field.importing the whole table gives me the same old error msgs..

Sory for the trouble.
But i realy want to know how can i run both EDB Server and SQL Server at the same time so that i would be able to run both servers hand in hand with the same data.and getting both data synchronized.

Shahjaufar

<< MS SQL Server had a problem importing blank fields where the data had to
be converted to another data type.
And there were a datatype mismatch.The only thing i could do was to use a
query to retrieve the data of the required data field.importing the whole
table gives me the same old error msgs..

Sory for the trouble.
But i realy want to know how can i run both EDB Server and SQL Server at the
same time so that i would be able to run both servers hand in hand with the
same data.and getting both data synchronized. >>

Could you possibly send me (support@elevatesoft.com) a copy of your database
that you're trying to import into SQL Server 2008, along with instructions
on how you're trying to perform the import ?  I'll give it a try here and
see if I can figure out what the problem is.

--
Tim Young
Elevate Software
www.elevatesoft.com