Re: Feature is not available?
- From: B. Chernick <BChernick@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Fri, 9 May 2008 13:07:00 -0700
A massive apology. I found the immediate problem. I left out the phrase
'Data Source='. Now the Open works.
Still can't quite get the pack command to work. More later.
"Paul Pedersen" wrote:
Typically that message will appear if you try to do something that's not.
allowed in the runtime version (i.e., FoxPro is not installed on the
machine). Older Foxpro's like 6 were more picky about that than 9.
Is it possibly due to some code in the database? I forget what all the
forbidden features are/were, but some are: DEBUG, COMPILE, SET STEP ON,
things like that. If there are such commands in the db procedures that
automatically run on open, you might get that message.
"B. Chernick" <BChernick@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:D563964D-7253-4834-B6BC-0022A3DB154D@xxxxxxxxxxxxxxxx
On dc.open. Here's the actual code. sConnStr is the connection string
described earlier.
Dim dc As New OleDb.OleDbConnection(sConnStr)
Try
dc.Open()
Catch ex As Exception
MsgBox("Open Fails, error = " + ex.Message)
Exit Sub
End Try
"Paul Pedersen" wrote:
What is the line that's causing the error?
"B. Chernick" <BChernick@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:14E43ECC-8BEB-4B8D-8AA4-21C23A550614@xxxxxxxxxxxxxxxx
I'm trying to write a quickie Winforms utility (VB, 2.0) that will pack
some
FoxPro 6 dbf tables. Unfortunately the same connection strings that
worked
with my web app don't seem to work in Winforms. It's crashing on open
with a
'Feature is not available' message. (And yes I've already checked
ConnectionStrings.com)
I've tried a connection string of both:
"Provider=VFPOLEDB.1;" + <file path> + ";Collating Sequence=General"
(This is what I've been using in my web apps.)
and
"Provider=VFPOLEDB.1;DRIVER={Microsoft Visual FoxPro
Driver};SourceType=DBF;" + <file path> +
";Exclusive=NO;BackGroundFetch=NO;NULL=NO;Collate=MACHINE"
(got that one from ConnectionStrings.com)
What am I missing?
(Is there some reference I'm forgetting? Something extra needed in
Winforms
but not web apps???)
- Follow-Ups:
- Re: Feature is not available?
- From: Fred Taylor
- Re: Feature is not available?
- References:
- Feature is not available?
- From: B. Chernick
- Re: Feature is not available?
- From: Paul Pedersen
- Re: Feature is not available?
- From: B. Chernick
- Re: Feature is not available?
- From: Paul Pedersen
- Feature is not available?
- Prev by Date: Re: Feature is not available?
- Next by Date: Re: Feature is not available?
- Previous by thread: Re: Feature is not available?
- Next by thread: Re: Feature is not available?
- Index(es):
Relevant Pages
|
