Open a file wiht "(" in the filename?

[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()

 

[Mythran]

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

 

[Al G]

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

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

 

[Mythran]

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()

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