|
CaffeinatedCoder
Starting Member
1 Posts |
 Posted - 01/14/2011 : 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 |
|
using openrowset with monetdb ODBC
