Sorry it works I had last " in the wrong place...

Now I need to add a line to write error to a text file...

I was tying to use batch file to execute proc, but did't work and I was not able to see error...

here is the script I used:

I am trying to use...

Is it possible using ACCESS forms or reports? Thanks guys for the help.

Thanks Sean for the response. I tested many regExes I found in google, but I couldnt find the one which will work with a char string where it will have...

Yes Jeff I just need to isolate those row... I do not need to find the numbers. I will go through the response from everyone now. Thanks a lot to...

Yes it is working. Thanks a lot Leeland!

For linked server provider "MSDASQL" I have enabled only "Allow Inprocess" and it is working fine.... I wanted to check with you which...

When I enabled "Allow Inprocess" in the "MSDASQL" from Providers folder... the 4 part naming is working fine too... I will restart the server and test again...

Leeland thanks a lot for your help... there is some progress and I think I am very close in solving this issue with your help...

I created a SYSTEM DSN "TEST_ODBC"...

Leeland I get this error:

Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "TEST2".

OLE DB provider "MSDASQL" for linked server "TEST2" returned message "[Microsoft][ODBC Driver...

Hi Leeland thanks a lot for detailed information...

I can also see the catalogs; however, when I run a select I get the same error:

Msg 8522, Level 16, State 3, Line 1 Microsoft Distributed Transaction Coordinator (MS DTC)...

Thanks for the information... I just completed the upgrade from SQL 2008 R2 to SQL 2012. Everything seem to work fine, but the Linked Server linking to SQL Server 2000....

Thanks Guys for the response. I have not been able to fix this problem. I will try to tweak MSDTC today if that doesnt help... planning to instal SQL 2008...

Thanks a lot for the response. Yes I am picking SQLNCLI10 and not SQLNCLI11. I am able to see the tables and views once the connection is established, but I...

Thanks a lot Jeff and Lowell. Jeff I was looking everywhere and did not see any issues with the code, but you just made my day... this is great help....