displaying data from linked server

[andreadd]

Hello,

I have SQL2000 sp4 on my win 2003 server. I have a lotus nsf file that I have installed the odbc connoector for and successfully created a system dsn. I then used that to create my linked server. I can see the list of tables and a matching list of views. So I thought o' happy day. I open QA and type in the following:

select * from openquery(LOTUS1, 'select * from contact')

you'd think it would return info but I am getting ODBC Msg 0, Level 19, State 1

So I am clueless as what the deal is. I am wondering if my userid for lotus is the issue. the data came from one domino box and the id came from another. Like I said ODBC and linked server didnt complain any about.

any ideas would be greatly appreciated!

p.s. odbc is ver 3.526.3959.0

 

[SDB15]

Not sure if this is what you're looking for but I've seen syntax using OpenRowSet that includes a username and even password.