openrowset for datadirect driver

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

openrowset for datadirect driver

Author

Topic

dmaxj
Posting Yak Master

174 Posts

Posted - 2009-05-21 : 11:30:23

Has anyone had any success with using OPENROWSET and the DataDirect 32-BIT SequeLink 5.5 (version 1.41) driver?

I am trying to access a Filemaker database via SSMS.

Thanks

dmaxj
Posting Yak Master

174 Posts

Posted - 2009-05-22 : 13:13:32

I worked on this issue some more and I think that I am making progress. Here is my error after I issue my query:

Msg 7403, Level 16, State 1, Line 3
The OLE DB provider "Dsn=datasourceName" has not been registered.


SELECT *
FROM
OPENROWSET('Dsn=datasourceName','DRIVER={DataDirect 32-BIT Sequelink 5.5};SERVER=servername;UID=username;PWD=password',
'SELECT *
FROM tableName')

So I am thinking that the SQL Server needs to be linked to my server that is hosting the data that I want to view in SSMS. Am I on the right track? If so, I guess I should make this request to the SQL Server DBA?

Regards

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources