-
as seen on Stack Overflow
- Search for 'Stack Overflow'
I am using VFPOLEDB driver to read DBF files and I keep getting this error and I am not sure why and how to fix the problem:
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…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
I have huge problem:
I have lots of .dbf files(~50000) and I need to import them into Oracle database.
I open conncection like this:
OleDbConnection oConn = new OleDbConnection();
OleDbCommand oCmd = new OleDbCommand();
oConn.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source="…
>>> More
-
as seen on Geeks with Blogs
- Search for 'Geeks with Blogs'
I thought my days of dealing with DBFs as a "production data" source were over, but HA (no such luck).
I recently had to retrieve, modify and replace some data that needed to be delivered in a DBF file.
Everything was fine until I realized / remembered the DBF driver does not ACTUALLY delete records…
>>> More
-
as seen on Geeks with Blogs
- Search for 'Geeks with Blogs'
I thought my days of dealing with DBFs as a "production data" source were over, but HA (no such luck).
I recently had to retrieve, modify and replace some data that needed to be delivered in a DBF file.
Everything was fine until I realized / remembered the DBF driver does not ACTUALLY delete records…
>>> More
-
as seen on SQL Blog
- Search for 'SQL Blog'
There is much more to query tuning than reducing logical reads and adding covering nonclustered indexes. Query tuning is not complete as soon as the query returns results quickly in the development or test environments. In production, your query will compete for memory, CPU, locks, I/O…
>>> More