May 5, 2006 at 10:57 am
Using Management Studio (right click on database, "Tasks","Import Data..."), I am attempting to import an Access file to my database.
It gets to the point of actually executing the import, and then comes up with this error:
Could not set up data flow connections.
The connection type "OLEDB" specified for connection manager [very long hex number] is not recognized as a valid connection manager type. This error is returned when an attempt is made to create a connection manager for an unknown connection type. Check the spelling in the connection type name.
I then exported the table to an Excel file (in Access) and tried to import that into SQL Server. I get the exact same error, only with the connection type as "EXCEL".
Something is seriously wrong with my import function. Only a subset of the normal connection types is present in the dropdown list. Notably missing is "text file".
Is there something I have to set up in Management Studio to activate these connection types?
May 5, 2006 at 12:13 pm
Google is my friend ...
I found this thread in an MSDN forum that resolves this problem --
http://forums.microsoft.com/MSDN/ShowPost.aspx?PageIndex=4&SiteID=1&PostID=363238
Apparently the problem is, certain third-party programs that are installed adversely impact the permissions on certain registry entries. Changing the permissions on those entries solves the problem. I even have "text file" back!
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply