I managed to link the SQL server and succesfully did it .
Thanks very much to you all.
But now how to add a linked access dataebase.
I tried the following :
USE master
GO
EXEC sp_addlinkedserver
'Test',
'OLE DB Provider for Jet',
'Microsoft.Jet.OLEDB.4.0'...
I used sp_addlinkedserver 'ServerName'
And then can someone tell me on what syntax should I use to access a table within a database in the server.
Save the server 'ServerName' had a database called 'DatabaseName' and which has a table called 'TableName'
can I use
Select * from...
Well I am also having a similar problem. But in my case I can send mails via the ADSL connection using the SMTP Server of my ADSL ISp. But havent been able to configure Exchange to retreive mails using the ADSl connection and still is dependent on a dial up connection. I have no idea how to go...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.