VFPODBC.DLL: "ERROR [S1000] [Microsoft][ODBC Visual FoxPro D

sleepyant · Joined: 08 Aug 2007 Posts: 1

Hi. I'm using VB.net to access some FoxPro free data table. There are aabout
10 DBF files which I can make connection and using select command and fill
into a Data Adaptor with no problem. But there is 'one' particulatar DBF
file keep having problem. The file name is "transac.dbf" and whenever it
read the Data Adapter "Fill" method, it will give the message "VFPODBC.DLL:
ERROR [S1000] [Microsoft][ODBC Visual FoxPro Driver]Variable ' ' is not
found.".

The following is my code:

Dim strConn As String = "Driver={Microsoft Visual FoxPro Driver}" & _
";UID=;SourceType=DBF;SourceDB=D:\Data;" & _
";Null=No;Deleted=Yes;Exclusive=No;Connect Timeout=10"

Dim Conn as OdbcConnection = New OdbcConnection(strConn)
Conn.Open

Dim Da As New OdbcDataAdapter
Dim Ds As New DataSet
Dim cmdSelect As New OdbcCommand

cmdSelect = Conn.CreateCommand
cmdSelect.CommandText = "SELECT * FROM transac"

Da.SelectCommand = cmdSelect

Da.Fill(Ds, "transac") ' <----- Error here.

What puzzle me is this only happen with this particlar table (transac.dbf),
and the rest works fine. I've tried to search for this kind of error but
couldn't find any. Please help. Thanks.

Archived from group: microsoft>public>dotnet>framework>odbcnet

sleepyant · Joined: 08 Aug 2007 Posts: 1

Ok, I guess I know what happen. It could be that one of the index key for
"transac.dbf" which require to "use" some other file as an alias. I think I
could solve it if I run several Foxpro Command (e.g. USE a ALIAS b, SELECT
0) before I open this "transac.dbf" table. But how can I run those Foxpro
command in VB.net, using the Odbc driver? Or is there a way I could ignore
the index key all together?

Please advise. Thanks in advance.

"sleepyant" wrote in message
news:%23lSNjl12EHA.3128@TK2MSFTNGP14.phx.gbl...
> Hi. I'm using VB.net to access some FoxPro free data table. There are
aabout
> 10 DBF files which I can make connection and using select command and fill
> into a Data Adaptor with no problem. But there is 'one' particulatar DBF
> file keep having problem. The file name is "transac.dbf" and whenever it
> read the Data Adapter "Fill" method, it will give the message
"VFPODBC.DLL:
> ERROR [S1000] [Microsoft][ODBC Visual FoxPro Driver]Variable ' ' is
not
> found.".
>
> The following is my code:
>
> Dim strConn As String = "Driver={Microsoft Visual FoxPro Driver}" & _
> ";UID=;SourceType=DBF;SourceDB=D:\Data;" & _
> ";Null=No;Deleted=Yes;Exclusive=No;Connect Timeout=10"
>
> Dim Conn as OdbcConnection = New OdbcConnection(strConn)
> Conn.Open
>
> Dim Da As New OdbcDataAdapter
> Dim Ds As New DataSet
> Dim cmdSelect As New OdbcCommand
>
> cmdSelect = Conn.CreateCommand
> cmdSelect.CommandText = "SELECT * FROM transac"
>
> Da.SelectCommand = cmdSelect
>
> Da.Fill(Ds, "transac") ' <----- Error here.
>
> What puzzle me is this only happen with this particlar table
(transac.dbf),
> and the rest works fine. I've tried to search for this kind of error but
> couldn't find any. Please help. Thanks.
>
>

Cindy Winegarden · Joined: 08 Aug 2007 Posts: 4

Hi Sleepyant,

I think what you're running into is a "filtered" index which may rely on a
function call, for example. When you select data from a Fox table the data
engine reads the indexes to see what data it needs (reading an index is
faster than reading a table) and then retrieves only those rows it needs. Of
course, if there is no available index it will retrieve all the data and
then sort it out locally. You've used a "Select *" SQL command, and I'm not
sure whether that's your actual command or an example.

Do you have any access to FoxPro to open the table and see what the indexes
are? Alternatively, you can read the CDX with Notepad and try to find the
index expressions. When I open a CDX in Notepad I see some relatively empty
stuff at the beginning, followed by whitespace which has the index
expression in the middle of it, preceded by three "square" characters.
Following that is a bunch of "Greek" and then another band of whitespace
with the three squares and the index expression. Have a look and see if you
can provide any more useful information that I could use to attempt to
duplicate your situation.

--
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy_winegarden@msn.com www.cindywinegarden.com

"sleepyant" wrote in message $2EHA.2624@TK2MSFTNGP11.phx.gbl...
> Ok, I guess I know what happen. It could be that one of the index key for
> "transac.dbf" which require to "use" some other file as an alias. I think
> I
> could solve it if I run several Foxpro Command (e.g. USE a ALIAS b, SELECT
> 0) before I open this "transac.dbf" table. But how can I run those Foxpro
> command in VB.net, using the Odbc driver? Or is there a way I could ignore
> the index key all together?
>
> Please advise. Thanks in advance.
>
>
> "sleepyant" wrote in message
> news:%23lSNjl12EHA.3128@TK2MSFTNGP14.phx.gbl...
>> Hi. I'm using VB.net to access some FoxPro free data table. There are
> aabout
>> 10 DBF files which I can make connection and using select command and
>> fill
>> into a Data Adaptor with no problem. But there is 'one' particulatar DBF
>> file keep having problem. The file name is "transac.dbf" and whenever it
>> read the Data Adapter "Fill" method, it will give the message
> "VFPODBC.DLL:
>> ERROR [S1000] [Microsoft][ODBC Visual FoxPro Driver]Variable ' ' is
> not
>> found.".
>>
>> The following is my code:
>>
>> Dim strConn As String = "Driver={Microsoft Visual FoxPro Driver}" & _
>> ";UID=;SourceType=DBF;SourceDB=D:\Data;" & _
>> ";Null=No;Deleted=Yes;Exclusive=No;Connect Timeout=10"
>>
>> Dim Conn as OdbcConnection = New OdbcConnection(strConn)
>> Conn.Open
>>
>> Dim Da As New OdbcDataAdapter
>> Dim Ds As New DataSet
>> Dim cmdSelect As New OdbcCommand
>>
>> cmdSelect = Conn.CreateCommand
>> cmdSelect.CommandText = "SELECT * FROM transac"
>>
>> Da.SelectCommand = cmdSelect
>>
>> Da.Fill(Ds, "transac") ' <----- Error here.
>>
>> What puzzle me is this only happen with this particlar table
> (transac.dbf),
>> and the rest works fine. I've tried to search for this kind of error but
>> couldn't find any. Please help. Thanks.
>>
>>
>
>

MichMat · Joined: 23 Dec 2007 Posts: 1

I have the same exact problem, has anyone figgured out the solution?

From http://www.developmentnow.com/g/22_2004_12_0_0_10054/VFPODBC-DLL-ERROR-S1000-MicrosoftODBC-Visual-FoxPro-DriverVariable----is-not-found-.htm

Posted via DevelopmentNow.com Groups
http://www.developmentnow.com

ERROR [07002] [Microsoft][ODBC Microsoft Access Driver]COUNT Goog morning, I'am using an adapter to pass an inserting querry withb parametrers. the code is : DA_ins[i] = new = new * from tmpDS[i] = new DataSet();

ERROR [ HY000 ] [ Microsoft][ODBC Microsoft Access Controlle Hi Could anybody say me because when doing a INSERT, gives the following error: "ERROR [ HY000 ] [ Microsoft Access Controller] the operation must use a updateable consultation" Thanks Code: conexion = new

System.Data.Odbc.OdbcException: ERROR [IM002] [Microsoft][OD Hi, All I have a Problem when I'm working with Informix Dynamic Server DataBase, and VB.NET as tools Developmen, the problem is when a Run my WebAplication have this message. ERROR [IM002] Driver Manager]

ERROR [22001] [Microsoft][ODBC Excel Driver] The field is to Hi, I'm using ODBC DSN less connection to load an EXCEL file into a dataset. It's raising the error "ERROR [22001] Excel Driver] The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data

Reading FoxPro Date field frpm ODBC Ok, what is the trick!!! I am using C# to read a FoxPro DBF file. I do the following: Private DataSet dbfFile) { DataSet ds = new DataSet(); string Sql; int dbfNameStart = string dbfTableName =