Problem accessing fox pro database on a network

[Sean]

Using VB.net with .Net Framework 1.1 and using Fox Pro OLEDB to connect to a
fox pro database.

When I try to load a dataset from a foxpro database on the network running
this line of code for path (\\servername\share\data\abc.dbc)
dbAdapter.Fill(dbDs)

I get:

"The provider could not determine the Decimal value. For example, the row
was just created, the default for the Decimal column was not available, and
the consumer had not yet set a new Decimal value."

This code works perfectly on the local copy of the FoxPro Database (example
c:\data\abc.dbc)

any idea why?

 

[Beth Massi [Architect MVP]]

Weird. I know that fox has had problems with UNC names before. You may have
better luck at an answer if you post to the
microsoft.public.fox.programmer.exchange newsgroup. They're a good group of
foxies in there.

 

[Sean]

This is a ADO.Net problem in VB.Net why would the FoxPro people know
anything about it?

 

[Kevin Yu [MSFT]]

Hi Sean,

This is really weird. I searched through web and saw some other people
having same problem as yours but none of the got a resolution. The only
walkaround I can see is to use OleDbDataReader instead of OleDbDataAdapter
to get data. When an InvalidOperationException is thrown, return
DBNull.Value.

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."

 

[Beth Massi [Architect MVP]]

You mentioned you were having problems with the Fox OLDEDB Provider.
Therefore, I figured a fox person would know. The VFP PSS folks watch the
group and may be able to help you with any provider issues.

 

[Beth Massi [Architect MVP]]

You might try mapping a drive letter to the UNC path instead and see if that
works. I recall that being an older problem.