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

 All Forums
 General SQL Server Forums
 Script Library
 using openrowset with monetdb ODBC

Author  Topic 

Starting Member

1 Post

Posted - 2011-01-14 : 10:43:33
I have successfully set up an ODBC connection to a monetdb server and can link to it from Access. I have tried to create a linked server and use openrowset in sqlserver unsuccessfully.

This is what I have been working with:

Select * from openrowset('MSDASQL',
'DRIVER={MonetDB ODBC Driver};SERVER=MonetDB;uid=monetdb;pwd=monetdb',

MonetDB is the name of the server and DSN.
It is installed on the localhost as is sql

I am testing it on SQL 2005 Express 32-bit on my laptop

Thank you

Patron Saint of Lost Yaks

30421 Posts

Posted - 2011-01-16 : 17:39:30
I think you have to specify port 50000 in the connectionstring, unless you have the SQL Browser service running.

N 56°04'39.26"
E 12°55'05.63"
Go to Top of Page

- Advertisement -