September 23, 2008 at 10:21 am
We are migrating all SQLServer 2000 to a new machine and upgrading to SQLServer 2005 at the same time. I have set up a linked server connection to our old VMS file structure system, just like we have it set up in SQLServer 2000. The new 2005 installation is on a new server running Windows Server 2008. We login to SQLServer using Windows authentication. I am able to login to the database using SQLServer tools installed on my local machine (running Windows XP) and successfully retrieve data from our linked server (Called EMS), but when I login to the server using the same windows authentication login, and run the sql query, the linked server returns errors:
OLE DB provider "MSDASQL" for linked server "ems" returned message "[Microsoft][ODBC Driver Manager] Invalid connection string attribute".
OLE DB provider "MSDASQL" for linked server "ems" returned message "[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed".
OLE DB provider "MSDASQL" for linked server "ems" returned message "Unable find/make local copy of CDD.".
Msg 7303, Level 16, State 1, Line 1
Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "ems".
I have a general idea what to look for but not where to look and adjust in the MSDASQL provider properties. I'm guessing that my connection string needs the server name for it to work but how on earth do I adjust connection string setting when using MSDASQL??? Any help would be much appreciated!
Thanks!
M Jones
~mj
April 14, 2009 at 3:46 pm
When I have encountered "Unable find/make local copy of CDD." on the CONNX drivers for VMS it has turned out to related to Security. When I execute my procedures from a workstation in SQL Server Management Studio it carries the credentials to the server and uses those credentials to access a temp folder. For my test server I granted permission on the temp folder to my department and no longer receive the error.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply