TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Andile Choko
NA
53
54.2k
Microsoft Jet Database error
Oct 16 2011 4:53 PM
Hi...
I have a code that works well on my computer and some pc's but on other pc's it gives me the following exception:
Microsoft Jet Database engine could not find the object 'yahoo.csv' make sure the object exists and that you spell its name and path correctly.
Source Code:
FileInfo
file =
new
System.IO.
FileInfo
(filename);
string
ConnectionString =
"Provider=Microsoft.Jet.OLEDB.4.0;"
+
"Data Source=\""
+ file.DirectoryName +
"\";Extended Properties='text;HDR=Yes;FMT=Delimited(,)';"
;
OleDbConnection
conn =
new
System.Data.OleDb.
OleDbConnection
(ConnectionString);
OleDbCommand
cmd =
new
System.Data.OleDb.
OleDbCommand
(
string
.Format(
"SELECT * FROM ["
+ file.Name +
"]"
, file.Name), conn);
conn.Open();
//some other code goes here and has no effect on the exception.
conn.Close();
I traced the code and i think the problem could be on the line i highlited above.
Updated Question
I think i have found something concerning the error;
when i trace my code, this is what i get from the line that contains "file.DirectoryName" it says file.Directory= "C:\\Program Files\\Common Files\\Microsoft Shared\\DevServer\\10.0"
i discoverd that i only get this from computers that have been partioned, whereas computers that haven't been partioned it gives me the correct file.DirectoryName.
How do i then solve this error/Exception?
Reply
Answers (
1
)
Error, when i load site in visual studio
Sections must only appear once per config file