Hello again everyone. I am using the OleDb Database Provider and I am reading in csv and dBase database files. I noticed that when the datasource is something like C:\DB\, it works fine and I can read in the data, however if the datasource has a space in it like C:\D B\, it is not able to read in the data from the file. I was wondering if anyone knew if there was a way to fix that or not.
Thanks,
The Major Rager
Double quotes?
dwk
Seek and ye shall find. quaere et invenies.
"Simplicity does not precede complexity, but follows it." -- Alan Perlis
"Testing can only prove the presence of bugs, not their absence." -- Edsger Dijkstra
"The only real mistake is the one from which we learn nothing." -- John Powell
Other boards: DaniWeb, TPS
Unofficial Wiki FAQ: cpwiki.sf.net
My website: http://dwks.theprogrammingsite.com/
Projects: codeform, xuni, atlantis, nort, etc.
Hi, thanks for replying, I was wondering if you could give me an example of where to put the double quotes.
Thanks,
The Major Rager.
I have no idea - I've never used C# - but in DOS:
Code:C:\>cd Program Files Too many arguments C:\>cd "Program Files" C:\Program Files>
dwk
Seek and ye shall find. quaere et invenies.
"Simplicity does not precede complexity, but follows it." -- Alan Perlis
"Testing can only prove the presence of bugs, not their absence." -- Edsger Dijkstra
"The only real mistake is the one from which we learn nothing." -- John Powell
Other boards: DaniWeb, TPS
Unofficial Wiki FAQ: cpwiki.sf.net
My website: http://dwks.theprogrammingsite.com/
Projects: codeform, xuni, atlantis, nort, etc.
Well I went into the debugger, it does connect to the correct datasouce, it does show the datasource as C:\D B\, but when it hits the dataReader, it seems to throw an exception. When I manually go into the directory and change the directory to C:\DB, it works.
Okay, so let's see the code. If it's something like this:
then just change it toCode:get_something("C:\D B", &what);
Code:get_something("\"C:\D B\"", &what);
dwk
Seek and ye shall find. quaere et invenies.
"Simplicity does not precede complexity, but follows it." -- Alan Perlis
"Testing can only prove the presence of bugs, not their absence." -- Edsger Dijkstra
"The only real mistake is the one from which we learn nothing." -- John Powell
Other boards: DaniWeb, TPS
Unofficial Wiki FAQ: cpwiki.sf.net
My website: http://dwks.theprogrammingsite.com/
Projects: codeform, xuni, atlantis, nort, etc.
Hi Thanks again for taking the time to reply.
The connection string looks like this.
my program is dynamic, so when I go in and just change the directory name to C:\DBCode:"C:\D B\"
my code looks like this
and it is able to read it in fine.Code:"C:\DB\"
Change it to
and see what happens.Code:"\"C:\D B\""
dwk
Seek and ye shall find. quaere et invenies.
"Simplicity does not precede complexity, but follows it." -- Alan Perlis
"Testing can only prove the presence of bugs, not their absence." -- Edsger Dijkstra
"The only real mistake is the one from which we learn nothing." -- John Powell
Other boards: DaniWeb, TPS
Unofficial Wiki FAQ: cpwiki.sf.net
My website: http://dwks.theprogrammingsite.com/
Projects: codeform, xuni, atlantis, nort, etc.
the connection string looked like this in the debugger
and it wasn't even able to connect. When I tried to open the connectionCode:"\C:\D B\"
it failed.
It actually connects with the original as
however, when it gets to the dataReader, it fails for some odd reason.Code:C:\D B\
Hey, thanks a lot, I got it to work now. My Select statement was the problem, i just needed to reference the entire file name instead of the datasource with the file name. So I got it, thanks a lot though!
Sincerely,
The Major Rager
