Hi,
I created a Application using ASP.net with C# , OLEDB provider which can connect either of the 3 databases (Excel/Access/SQL).
Now i am using Excel as the Database.
Before publishing, In the Local system the data is saved in the Database and Displayed in the grid
after Publishing in the server, the value is not saved in the database , it is not showing any error also.
Can any one help me to resolve this problem.
Thanks in Advance
Vanathi
Loading
Amit ChoudharyPosted Nov 26, 2009, 12:44 AM
It may be possible that the Providers for excel database are present at Sqlserver Host but not at your present host... Do one thing..
just try to register you Host Server with Microsoft.OLEDB.jet.4.0 drivers.. go to following link
http://support.microsoft.com/default.aspx?scid=kb;en-us;239114
To register the HostServer and you application will run smoothly as it run at other server..... and Please mark answer it'll help me get some points.. :)
VanathiPosted Nov 25, 2009, 11:52 PM
If SQL server is installed in the server means the application is working Fine.
Why it is not running in the absence of SQL server.
Amit ChoudharyPosted Nov 25, 2009, 7:27 AM
VanathiPosted Nov 25, 2009, 7:06 AM
But i am using Microsoft Office Excel 97-2003 Worksheet format only.
I am not at all using Excel 2007.
can u pls give suggestion to resolve this problem.
(Note: we are having another server in which SQL server is installed , In that server we are not facing this problem.The same Application is running properly there)
Amit ChoudharyPosted Nov 25, 2009, 6:36 AM
if you are using Microsoft.Ace.12.0 drivers for excel-07 sheet then Confirm that these drivers are available at your hosted server.... i have already face the problem..
so either you have ask to add the drivers at the hosted server or Downgrade the drivers to lower version and save the Data into Excel 97-2003 format....
Please mark the answer if it helps....
:)