Problem with importing a CSV into database

Hi,

Presenlty Iam facing problem while trying to import a .csv file into the database.
Issue is that... I am able to achieve my functionality when i import a file from D:\
But when i run the same program... and try to import from C:\ its throwing an exception.

I am coding in VB (Visual Studio 2005 ) and database is Microsoft SQL SERVER 2005.
My project is currently running on local machine in C:\Inetpub\wwwroot

Im using the following code to query the database...

SELECT employeeid, IDCubeID, ClockTime, ClockType, CreatedDate, Status, EntryType, ' ' as Remark,YardID,YardName,' ' as UserModify,' ' as UserCreate,DateModify,JobNo FROM & File1.PostedFile.FileName.ToString

where File1.PostedFile.FileName.ToString = D:\RawData_ClockTime.csv

when i import from C drive .. (File1.PostedFile.FileName.ToString = C:\RawData_ClockTime.csv)
it is throwing an exception as follows...

The Microsoft Jet database engine could not find the object 'RawData_ClockTime.csv'. Make sure the object exists and that you spell its name and the path name correctly.Always remember that C: drive on your local machine and on your server is not the same.

Use \\machine_name\.... instead.

Good Luck.

problem with drilldown (ReportServer)

hi,

i have a problem with the drilldown functionality of my report:

in the preview pane in VS2005 everything works fine but when I try to execute the report on reportserver the only thing I see is the top level and I'm not able to drilldown into lower levels ...

anyone has an idea?
Idid not implement the drilldown in mdx statement but used grouping & toggle item in VS2005. could that be the reason?

thanks,
rhpasy

Check the supported versions for different web browsers. Static reports is the version supported in older browsers.

Also add the reportserver/manager to the local intranet zone or trusted site(if you use Internet Explorer).

Regards

Thomas Ivarsson