January 18, 2011 at 5:57 am
Error:-
OLE DB provider "SQLNCLI10" for linked server "XLTEST_SP" returned message "Login timeout expired".
OLE DB provider "SQLNCLI10" for linked server "XLTEST_SP" returned message "A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.".
Msg 53, Level 16, State 1, Line 0
Named Pipes Provider: Could not open a connection to SQL Server [53].
please help me i have opreting system windows server2003 sp 2
please help me Asap
Thanks & Regards
M Shamim Khan
January 18, 2011 at 5:58 am
Script:-
DECLARE @rc int
DECLARE @server nvarchar(128)
DECLARE @srvproduct nvarchar(128)
DECLARE @provider nvarchar(128)
DECLARE @location nvarchar(4000)
DECLARE @provstr nvarchar(4000)
DECLARE @catalog nvarchar(128)
-- Set parameter values
EXEC sp_dropserver 'XLTEST_SP'
SET @server = 'XLTEST_SP'
SET @srvproduct = 'Excel'
SET @provider = 'Microsoft.Jet.OLEDB.4.0'
SET @provstr = 'Excel 8.0'
EXEC @rc = [master].[dbo].[sp_addlinkedserver] @server, @srvproduct, @provider,
@V_Mailattachments, @location, @provstr, @catalog
INSERT INTO OPENQUERY(XLTEST_SP, 'SELECT * FROM [Sheet1$]')
SELECT AttendanceDate,EmployeeLoginname As EmpCode,ShiftName,Session1IndateTime as InTime,Session2OutdateTime as OutTime, UploadSuccess,Error,ModifiedDate FROM [Attendance_DataUploadHistory] where UploadSuccess=0
January 18, 2011 at 6:18 am
Windows 32 or 64 bit?
Sql 32 or 64 bit?
Are you able to do a simple select in the same excel file?
January 18, 2011 at 6:23 am
Windows server 2003 its 32 bit
and sql standards edition 32
Thanks & Regards
M Shamim
January 18, 2011 at 6:57 am
Are you able to do a simple select in the same excel file?
January 18, 2011 at 9:34 pm
plz send me script
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply