Re: Open a file wiht "(" in the filename?
- From: "Al G" <agerhart2@xxxxxxxxxxxxxxxxxx>
- Date: Fri, 29 Dec 2006 13:02:04 -0800
Thanks Mythran,
That works perfectly. Thank you also for the link.
The working code looks like:
Dim TktQuery As String = "SELECT * FROM [" & TicketFile & "]"
Al G
"Mythran" <kip_potter@xxxxxxxxxxx> wrote in message
news:OQ1to53KHHA.4376@xxxxxxxxxxxxxxxxxxxxxxx
"Al G" <agerhart2@xxxxxxxxxxxxxxxxxx> wrote in message
news:S%clh.82$Q4.43@xxxxxxxxxxxxxxx
Hi,
VS2005team(w/ sp1), VB, XP(w/ sp2)
I am attempting to open a file that has parenthesis in the filename.
The following code works OK without the "( )", but not with them. The
error is: "Command contains unrecognized phrase/keyword."
Does anyone know a way to work around this?
TicketFile = "C:\convert\Test(3).dbf"
connectionstring = "Provider=VFPOLEDB.1;Data Source=" & ticketfile &
";Collating Sequence=MACHINE"
Dim queryString As String = "SELECT * FROM " & TicketFile
Using connection As New OleDbConnection(connectionstring)
Dim command As New OleDbCommand(queryString, connection)
connection.Open()
Dim reader As OleDbDataReader = Command.ExecuteReader()
The 'Data Source' parameter for the connection string should not be the
filename, but the path to the file instead without the file name appended.
When you perform select/update/insert/delete operations against the
connection, you specify the filename ... for example:
connString = "Provider=VFPOLEDB.1;Data Source=C:\convert\;..."
Dim queryString As String = "select * from [Test(3).dbf]"
Give that a shot and let us know how it works out for ya ;) Btw, I did
not fully test this on my end using a DBF / FoxPro file. I did, however,
test this using a comma-delimited file and it works like a charm :) I got
the information for my tests from google as well as
www.connectionstrings.com.
HTH,
Mythran
.
- References:
- Open a file wiht "(" in the filename?
- From: Al G
- Re: Open a file wiht "(" in the filename?
- From: Mythran
- Open a file wiht "(" in the filename?
- Prev by Date: Not a dumb question - A Good One
- Next by Date: Re: System Restore
- Previous by thread: Re: Open a file wiht "(" in the filename?
- Next by thread: Dumb question
- Index(es):
Relevant Pages
|
