December 31, 2002 at 9:42 am
I'm trying to run the following:
SELECT *
FROM OPENROWSET('Provider=MSDASQL', 'DRIVER={Sybase ASE ODBC Driver}; SERVER=D_CORP4; DATABASE=HCTDB; UID=S048690; PWD=hctdb1',
HCTDB.dbo.APPLN_HITS) Where APPLN_NAME Like "Master*"
I keep getting this message:
Could not locate registry entry for OLE DB provider 'Provider=MSDASQL'.
I have checked the registry and found what appears to be the proper registry entry for using the syodase.dll driver. I can use this driver fine when connecting with any other application (Excel, Access, etc.), but query analyzer just won't accept it. Any ideas???
I'm also able to DTS using this provider.
Edited by - suestill on 12/31/2002 09:43:00 AM
December 31, 2002 at 11:05 am
Just to make sure I understand, where are you executing this from. If from your local machine remote to the SQL Server then you need to keep in mind QA executes on the SQL Server and that provider must exist there. As for Access, Excel and DTS if executed from your machine it will be based on the client installed on your local machine not whether or not on the SQl Server.
December 31, 2002 at 11:07 am
I am executing from my local machine. Are you saying that the msdasql provider has to be installed on the SQL server? If so, then that must be my problem!! I will check with my SA.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply