I dont know the root cause of the problem.

But when i have installed MSXML 4.0 in my machine, the problem is rectified

:-):-)

Thanks WayneS.. It worked Perfectly

Please observe thelast record inserted in temployee_leave_application.

The From_DT value is 04/30/2009

and TO_DT Value in 02/05/2009

It means that Total Number of leaves in April will be 2

and for may it is...

Mohan Kumar (4/29/2009)

---

Swati

Windows Authentication requires that SQL Server services must run as domain users in trusted domains or as network services.

To authenticate both ends of a connection, Windows Authentication uses...

Thanks For Your Reply Mohan.:-)

The above code which you gave works fine when logged in using sql server authentication. But does not with Windows authentication. The Error Message was like...

Florian Reischl (4/18/2009)

---

Hi

I'm no pro for MS-Access but did you have a look to BOL for "linked servers"? Look for "sp_addlinkedserver", there are some examples how to connect to MS-Access...

Thanks A Lot For ur Reply,,,,,,

This is really what i wanted.

I wanted this as a PArt of Stored Procedure for a Report GEneration.

Thanks Again.... :):):):):)