Open a file wiht "(" in the filename?

  • Thread starter Thread starter Al G
  • Start date Start date
A

Al G

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()
 
Al G said:
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()
Click to expand...

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
 
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 said:
Al G said:
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()
Click to expand...

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
Click to expand...
 
Al G said:
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()
Click to expand...

Doesn't look like my post went through last week :( Basically, don't
provide the full path to the file for the Data Source parameter of the
connection string. Instead, provide the folder name (C:\convert) as that
parameter. When you do a select, use the file name as the qualified table
name (select * from [Test(3).dbf]).

HTH,
Mythran
 
Back
Top