January 6, 2014 at 3:03 am
i used sql 2005 on my computer and i need to export-import table from a database to a new database that is still blank. i do this step:
1. create new database that named DATABASE B
2. right click on DATABASE A(my source data table) - task - export - then the problem come. it's shown by this words:
could not step up data flow connection.
the connection type "OLEDB" specified for connection manager"{some numbers}" is not recognized as a valid connection manager type. bla bla bla
additional information:
the connection type "OLEDB" specified for connection manager"{some numbers}" is not recognized as a valid connection manager type. bla bla bla
the problem shown too when i tried to import on DATABASE B from DATABASE A.
Please help me fix this problem...
January 6, 2014 at 4:15 am
When exactly do you get the error?
Are the client tools connectivity installed?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 6, 2014 at 6:50 am
how can i see that if it's already installed on my computer?
i installed sql 2005 on typical way
January 6, 2014 at 6:52 am
You can re-run the SQL Server set-up, add features to an existing installation and check what is already installed.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply