![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB Connectivity » View Thread |
Messages 1 to 7 of 7 total |
![]() |
Mon, Mar 21 2011 7:04 AM | Permanent Link |
shahjaufar | 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. |
Mon, Mar 21 2011 7:15 AM | Permanent Link |
Roy Lambert NLH Associates ![]() | 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] |
Mon, Mar 21 2011 8:34 AM | Permanent Link |
shahjaufar | >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 ? |
Mon, Mar 21 2011 5:13 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. ![]() | << 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 |
Tue, Mar 22 2011 1:04 AM | Permanent Link |
shahjaufar | 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. |
Tue, Mar 22 2011 6:40 AM | Permanent Link |
shahjaufar | 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. |
Wed, Mar 30 2011 11:27 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. ![]() | 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 |
This web page was last updated on Monday, July 15, 2024 at 07:03 PM | Privacy Policy![]() © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |