seenu_61281 (6/20/2008)

---

iam using sql server 2005 express. we have two branches for our company.we have lotus notes is the only connectivity...i also have sql server in other branch...

can i get...

pduplessis (6/20/2008)

---

You misunderstood me.

I meant that you are currently using a stored procedure and deriving NAME from Firstname and Surname.

If you do a merge join you can achieve the same...

pduplessis (6/20/2008)

---

You would select firstname and lastname from your respective tables, and write a derived column which now becomes NAME.

Merge join is all about knowing if you want to do...

Thanks for your response.

Why means I have written a query by joining two tables t1 and t2 and taken the necessary columns. The result set contains the needed columns for...

pduplessis (6/4/2008)

---

Hey,

The more I read up on your specific problem, the more the hair on my neck stands on end...

I have honestly never heard of Lotus Notes DB before. And...

Sorry, I am new to this database it self.

I am not clear about link server. Did you mean you want me to register the lotus notes Domino Server into...

Open Record set means, I didn't understand. I think as per my knowledge, we can not connect to Lotus notes DB with out DSN.

If you let me know the procedure...

🙂 Thanks a lot for your response. But I only possed that questions there. Venkat Thota is me only. There also no body responding. No body aware with this type...

Please, any body help me out?

I configured the connection manager as

.Net provider/ODBC data provider

If I try to configure with ODBC connection the it is showing error. The error is attached.

I found in one...

Thanks for your response. Yes I am quering the right table.

When I link that table to MS Access db and checking then it is showing the 10000 records. Linking to...