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.
| Author |
Topic |
|
CaffeinatedCoder
Starting Member
1 Post |
 Posted - 2011-01-14 : 10:43:33
|
| Hello,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',demo.sys.test)MonetDB is the name of the server and DSN.It is installed on the localhost as is sqlport=50000I am testing it on SQL 2005 Express 32-bit on my laptop Thank you |
|
|
SwePeso
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" |
 |
|
|
|
|
|
using openrowset with monetdb ODBC