SQL Server does not exist or access denied. +ConnectionOpen (Connect()).
-
While Reading 1005 records from Excel2000 through asp.net,c# application. inside the application two sp are called for 1005 times. I get the following errors "SQL Server does not exist or access denied ,ConnectionOpen (Connect()).". While reading 850 records from excel 2000 it's working fine and two sp are called 850 times. Thanks in Advance Senthilkumar.T
-
While Reading 1005 records from Excel2000 through asp.net,c# application. inside the application two sp are called for 1005 times. I get the following errors "SQL Server does not exist or access denied ,ConnectionOpen (Connect()).". While reading 850 records from excel 2000 it's working fine and two sp are called 850 times. Thanks in Advance Senthilkumar.T
Are you trying to open new connection every time you read a row in excel. if yes try opening single connection at first and use the connection everywhere.
Venky