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 sql
port=50000
I 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