External table is not in the expected format

Sameers (theAngrycodeR) via .NET 247

I think I will get MAD very soon. Its very weired problem I amfacing here. Let me explain.

I have two DBF files from which I want to export data in CSVformat. I created a desktop application and used followingconnec tionstrings.

Provider=Micros oft.Jet.OLEDB.4 .0; DataSource=D:\M JGross\DataBase s;Extended Properties=dBas e III;
And
Provider=vfpole db.1;Data Source=D:\MJGro ss\DataBases;Ex tendedPropertie s=dBASE IV;Exclusive=fa lse;Nulls=false

Both worked fine and I simply finished that application.

Now customer required me to create a web service which mayautomate this export. I used the same code to put in a thread ina WindowsService and tried over to my system. I usedMicrosoft.J ET.OLEDB..... connection string on my system tocreate the service and it worked very nice to me. But when Isent that over to client, I found that though Connection wasopened, but when It tries to Fill data in DataTable, it throwserror:
External table is not in the expected format

I was weired, I thought its may be some problem due to connectionstrin g and I changed that to vfpoledb.1..... ... and I stunt thatit was not working on my system and even on the client system. Iagain checked on Simple desktop application and found that bothconnection string + same DBF file was working very correctly butwhen comes to Service, it throws error. Using vfpoledbconnect ion string, it denies to connect and usingMicrosoft. JET.OLEDB, it though connects but throws error saying"External table is not in the expected format".

I am too much frustrated by this behaviour. I am using VB .NET(VS .NET 2003).

Any help or idea will be highly appreciated.

Thanks,
--------------------------------
From: Sameers (theAngrycodeR)
http://www.theangrycoder.com

-----------------------
Posted by a user from .NET 247 (http://www.dotnet247.com/)

<Id>f8lV0fOTjEK 4iGQJCP67Tg==</Id>

Nov 16 '05 #1

Subscribe Reply

11181

Similar topics

2009

cross tab or derived table

by: mirth | last post by:

Hi all, I have a table in this format colname1 colname2 colname3 col1data1 col2data1 col3data1 col1data2 col2data2 col3data2 col1data3 col2data3 col3data3 col1data4 col2data4 col3data4

Microsoft SQL Server

3245

Error : External table is not in the expected format..????

by: Meer | last post by:

Hi, I'm having problem to read *.DBF (DBase File) using ASP.NET. Below is my code, taken from one of forumer here.... Dim connection As OleDbConnection Dim command As OleDbCommand Dim reader As OleDbDataReader connection = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;"&_ "Data Source=C:\;Extended Properties=dBase IV") connection.Open()

ASP.NET

6582

How to deal with "External table is not in the expected format" error ?

by: Learner | last post by:

Gurus, I have a C# .NET Web application that downloads a datagrid to an Excel sheet. But when I upload the same excel sheet to server again, if gives me this wiered message "External table is not in the expected format". I have some idea why this is happening..Because my downloaded file is getting saved as an HTML file eventhough it will get opened in Excel and looks like an Excel file. If I open the downloaded file and do a

C# / C Sharp

3176

External table is not in the expected format. OWC11

by: Ujval Shah | last post by:

Hi, I am facing a peculiar problem. My Client Requirement is to Export and Import Excel from and To DataSet for web Application using OWC. Now Problem is When i Export file using OWC .. File's Extension is .xls but it's XML Spreadsheet .. so when i am trying to import Extended Property=EXCEL 8.0 is not supported. and it gives error "External table is not in the expected format."

ASP.NET

3686

Help me to fix External . js problem in asp.net

by: althafexcel | last post by:

hi everyone Im trying to include an external js in my aspx page under the head tag, it doesn't load or it displays an object expected error whenver the function from the .js is called. Actually for repeated html im using the external js, i mean the TOP, BOTTOM they are repeated in every page, so i include them as functions in the external js and call them. Why it doesn't work?

ASP.NET

4410

using php to move rows from text file into mysql table

by: mantrid | last post by:

Hello Can anyone point me in the right direction for the way to read a text file a line at a time and separate the fields on that line and use them as data in an INSERT to add a record to a mysql table. Then read the second line in text file and repeat. Thanks for your time Ian

PHP

2415

Catching external program exceptions

by: Marty | last post by:

I need to catch exceptions thrown by programs started by the os.system function, as indicated by a non-zero return code (e.g. the mount utility). For example, if I get the following results in a bash shell: $mount test mount: can't find /home/marty/test in /etc/fstab or /etc/mtab then I want to catch the same exception from the corresponding os.system() call, i.e. "os.system('mount test')", but it doesn't work as expected:

Python

8842

USING EXTERNAL TABLE

by: debasisdas | last post by:

This thread contains some useful tips for using External tables. USING EXTERNAL TABLE ======================= 1.THE TABLE POINTS TO EXTERNAL FILE. IF DATA IS ALTERED IN THE EXTERNAL FILE,DATA IN THE TABLE WILL ALSO CHANGE. 2.EXTERNAL TABLES CAN BE QUERIED IN THE SAME WAY AS STANDARD TABLES IN JOINS,VIEWS.....AND CAN USE ALL TYPES OF FUNCTION ON THE EXTERNAL TABLE. 3.TO GET INFO REGARDING EXTERNAL TABLES QUERY THE "USER_EXTERNAL_TABLES"...

Oracle Database

5724

External table is not in the expected format

by: smadadi | last post by:

When i am exporting the result of a query to an excel file it is comming up with the message "external table isn't in the expected format" It is happening occasionnally not everytime. I am using TransferSpreadsheet action. Can anyone help?

Microsoft Access / VBA

8392

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

8305

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

8823

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

7321

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

6163

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

5632

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

4151

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

4301

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

2726

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp