Wrox Programmer Forums
ASP.NET 2.0 Professional If you are an experienced ASP.NET programmer, this is the forum for your 2.0 questions. Please also see the Visual Web Developer 2005 forum.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the ASP.NET 2.0 Professional section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old July 31st, 2008, 01:14 AM
Authorized User
Join Date: Feb 2007
Posts: 32
Thanks: 0
Thanked 0 Times in 0 Posts
Default OleDbConnection Error

Hi All,

I have an aspx page that is used to upload an excel and read it to dataset. Everything is working fine on my local machine. But when i uplaod the page to Test Server, It throw an Unspecified Error when code tries to fill the dataset.
Code is as follow
                strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
                "Data Source=" & strFile & ";Extended Properties=""Excel 8.0;HDR=NO"""
                myConnection = New System.Data.OleDb.OleDbConnection(strConn)
                myAdapter = New System.Data.OleDb.OleDbDataAdapter("select * from [Sheet1$]", myConnection)

When code reaches to last line, It throw the error.

Kindly Help

Thanks in Advance

Old July 31st, 2008, 09:45 AM
Friend of Wrox
Join Date: Nov 2007
Posts: 207
Thanks: 2
Thanked 15 Times in 15 Posts

did you give read/write permissions for the iusr and aspnet accounts to that directory

Jason Hall
Old July 31st, 2008, 11:38 PM
Authorized User
Join Date: Feb 2007
Posts: 32
Thanks: 0
Thanked 0 Times in 0 Posts

I had given full permission to everyone.

Similar Threads
Thread Thread Starter Forum Replies Last Post
OLEDBConnection string for sql server2000 amit_mande@yahoo.com ADO.NET 0 September 21st, 2007 01:02 AM
BC30002: Type 'OLEDBConnection' is not defined. athanatos ASP.NET 1.0 and 1.1 Basics 1 July 5th, 2006 09:03 PM
Error in OleDBConnection : Object reference not se pvsunil Classic ASP Databases 0 April 9th, 2005 02:45 AM
How to create OledbConnection Global.asax EleaCarm ASP.NET 1.0 and 1.1 Professional 2 May 31st, 2004 08:22 PM
Return OleDb.OleDbConnection from the WEB method? Dmitriy Pro VB 6 2 May 4th, 2004 07:10 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.