In many cases, the user that SQL server is started as does not have privilege to access the network, or may not have access to read the particular file that it is trying to read.
Look in the services applet and see which user SQL Server is running as, then log on as that user and see if you can read the file. Maybe try looking in the event logs for an error message as well. On Mar 10, 2:33 am, Gourav <[email protected]> wrote: > Hi All, > > I got some Error... > ________________________________________________________________ > The OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server > "(null)" reported an error. The provider did not give any information > about the error. Cannot initialize the data source object of OLE DB > provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)". > _________________________________________________________________ > > I have done so much goggling but didn't get the solution. > Actually i am upload a Excel sheet through Open row set into SQL > Server 2008. > It is working fine when i operate this on single PC Sql.But when i am > operate same program into networks sql server it prompt Error.So > please anybody have idea about this then pls tell me .I'll wait for > reply..... -- You received this message because you are subscribed to the Google Groups "DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML Web Services,.NET Remoting" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/dotnetdevelopment?hl=en?hl=en or visit the group website at http://megasolutions.net
