ADO -> FoxPro and SQLBase
Lars Martinsen
SQLBase with ADO connection strings?
..Lars
Robert Baker
Yes, I have connected to Visual FoxPro using both RDS and ADO with success.
I however have yet to be successful with insertions to tables containing
BLOB columns. Memo columns were initially also a problem but I have
resolved this issue. Somehow, VFP wants all columns to be NOT NULL during
insertion. If someone has resolved this I would be most appreciative to
hear how to allow null values to be inserted. Personally, I am unaware of a
product called SQLBase.
Robert Baker
"Lars Martinsen" <la...@stripeset.com> wrote in message
news:cUUW5.528$K6.4...@juliett.dax.net...
Tom Gilmer
cn.Open "DSN=SQLbase;uid=syssql;pwd=syssql"
- Tom
Lars Martinsen
Thank you for answering. Can you provide me with the line of code that does
this? Like the connection string or something...
...Lars
"Robert Baker" <zxy...@home.net> wrote in message
news:eD2BLMtXAHA.278@cppssbbsa05...
> Lars,
>
> Yes, I have connected to Visual FoxPro using both RDS and ADO with
success.
> I however have yet to be successful with insertions to tables containing
> BLOB columns. Memo columns were initially also a problem but I have
> resolved this issue. Somehow, VFP wants all columns to be NOT NULL during
> insertion. If someone has resolved this I would be most appreciative to
> hear how to allow null values to be inserted. Personally, I am unaware of
a
> product called SQLBase.
>
> Robert Baker
>
Lars Martinsen
Aren't you connecting via ODBC when you do this. I'd like to know if it's
possible to connect directly to the SQLBase data using only an ADO
connection string.
...Lars
"Tom Gilmer" <tgi...@RemoveThis.bbvpc.com> wrote in message
news:elOpBUvXAHA.204@cppssbbsa03...
> I've opened SQLBase using a DSN, something like:
>
> cn.Open "DSN=SQLbase;uid=syssql;pwd=syssql"
>
> - Tom
>
Robert Baker
Create a System DSN [MyDSNEntry] selecting the VFP Driver and point to the
VFP DBC. I actually did the VFP data access using a Delphi ActiveForm
(which runs as an OCX inside IE5x). Delphi has an RDS component that wraps
the ADO type library. In the RDS component I filled in the property
"ComputerName" with http://myservername/. I then added a dataset with the
ConnectionString set to DSN=MyDSNEntry;UID=sa;PWD=;. I then filled in my
SQL command, the usual other stuff (Marshalling, Locking Timeout, etc.) and
BINGO, there was my VFP data in a grid that pointed to the dataset. Over
38,000 rows (but only 3 columns of approximately 50 char per row) in about
five seconds. This ADO cursor functions as a lookup table and the
respective much wider complete row is queried as the user navigates up and
down the lookup grid. A wide row query (a separate dataset that fetches the
single respective row) returns over a 1000 char (plus memo and
general[image] columns) almost instantly. In my first application, which
was similar, I wrote it using DHTML (IE 5.x level) with a mix of VB and
Script. That application accessed only MS SQL7 data. If I can get to the
VFP data using RDS/ADO with Delphi, I'm sure it can be done using xScript
inside IE 5.x. After all they both products ultimately just wrap the MS
API's. It has been an interesting experiment to use the two technologies,
DHTML and ActiveForms, back to back. I think the ActiveForms look much
better and have a richer interface. Once downloaded, the OCX's load
extremely fast on subsequent uses, I believe faster than all the Script and
HTML gets downloaded, and the data up and downs obviously are about the
same. The ActiveForm interface is also more responsive as an EXE is running
vs. Script code. Also, more importantly, my code is protected from
nefarious viewers. All this stuff is obviously Intranet/Extranet only. I
have also delivered pure EXE's (installed from the web) that bypass the
browser and just use the IP connection as an RDS transport medium. I have
not yet done much with the middle tier(s) except to use stored procedures.
I am experimenting with middle tier components but my current applications
are, by time constraint, quick and dirties; and also are pretty much one of
a kind apps.
Good Luck,
Robert Baker
"Lars Martinsen" <la...@stripeset.com> wrote in message
news:C_dX5.901$K6.9...@juliett.dax.net...
> Hello Robert...
>
> Thank you for answering. Can you provide me with the line of code that
does
> this? Like the connection string or something...
>
> ...Lars
>
> "Robert Baker" <zxy...@home.net> wrote in message
> news:eD2BLMtXAHA.278@cppssbbsa05...
> > Lars,
> >
> > Yes, I have connected to Visual FoxPro using both RDS and ADO with
> success.
> > I however have yet to be successful with insertions to tables containing
> > BLOB columns. Memo columns were initially also a problem but I have
> > resolved this issue. Somehow, VFP wants all columns to be NOT NULL
during
> > insertion. If someone has resolved this I would be most appreciative to
> > hear how to allow null values to be inserted. Personally, I am unaware
of
> a
> > product called SQLBase.
> >
> > Robert Baker
> >
Tom Gilmer
You can download an OLEDB provider from the Centura site. I tried it but it
didn't work out of the box and I didn't have time to troubleshoot. If you
are not under time constraints, you could give a go. There is also
documentation available from the Centura site.
- Tom
Lars Martinsen <la...@stripeset.com> wrote in message
news:T0eX5.903$K6.9...@juliett.dax.net...
> Hi Tom..
>
> Aren't you connecting via ODBC when you do this. I'd like to know if it's
> possible to connect directly to the SQLBase data using only an ADO
> connection string.
>
> ...Lars
>
> "Tom Gilmer" <tgi...@RemoveThis.bbvpc.com> wrote in message
> news:elOpBUvXAHA.204@cppssbbsa03...
> > I've opened SQLBase using a DSN, something like:
> >
> > cn.Open "DSN=SQLbase;uid=syssql;pwd=syssql"
> >
> > - Tom
> >
Robert Baker
Good Luck,
Robert Baker
"Lars Martinsen" <la...@stripeset.com> wrote in message
news:C_dX5.901$K6.9...@juliett.dax.net...
> Hello Robert...
>
> Thank you for answering. Can you provide me with the line of code that
does
> this? Like the connection string or something...
>
> ...Lars
>
> "Robert Baker" <zxy...@home.net> wrote in message
> news:eD2BLMtXAHA.278@cppssbbsa05...
> > Lars,
> >
> > Yes, I have connected to Visual FoxPro using both RDS and ADO with
> success.
> > I however have yet to be successful with insertions to tables containing
> > BLOB columns. Memo columns were initially also a problem but I have
> > resolved this issue. Somehow, VFP wants all columns to be NOT NULL
during
> > insertion. If someone has resolved this I would be most appreciative to
> > hear how to allow null values to be inserted. Personally, I am unaware
of
> a
> > product called SQLBase.
> >
> > Robert Baker
> >
> > "Lars Martinsen" <la...@stripeset.com> wrote in message
> > news:cUUW5.528$K6.4...@juliett.dax.net...
> > > Does anyone know if there's possible to connect directly to FoxPro and
> > > SQLBase with ADO connection strings?
> > >
> > > ..Lars
> > >
> > >
> >
> >
>
>
"Lars Martinsen" <la...@stripeset.com> wrote in message
news:C_dX5.901$K6.9...@juliett.dax.net...
> Hello Robert...
>
> Thank you for answering. Can you provide me with the line of code that
does
> this? Like the connection string or something...
>
> ...Lars
>
> "Robert Baker" <zxy...@home.net> wrote in message
> news:eD2BLMtXAHA.278@cppssbbsa05...
> > Lars,
> >
> > Yes, I have connected to Visual FoxPro using both RDS and ADO with
> success.
> > I however have yet to be successful with insertions to tables containing
> > BLOB columns. Memo columns were initially also a problem but I have
> > resolved this issue. Somehow, VFP wants all columns to be NOT NULL
during
> > insertion. If someone has resolved this I would be most appreciative to
> > hear how to allow null values to be inserted. Personally, I am unaware
of
> a
> > product called SQLBase.
> >
> > Robert Baker
> >
Tom Gilmer
You can download an OLEDB provider from the Centura site. I tried it but it
didn't work out of the box and I didn't have time to troubleshoot. If you
are not under time constraints, you could give a go. There is also
documentation available from the Centura site.
- Tom
Lars Martinsen <la...@stripeset.com> wrote in message
news:T0eX5.903$K6.9...@juliett.dax.net...
> Hi Tom..
>
> Aren't you connecting via ODBC when you do this. I'd like to know if it's
> possible to connect directly to the SQLBase data using only an ADO
> connection string.
>
> ...Lars
>
> "Tom Gilmer" <tgi...@RemoveThis.bbvpc.com> wrote in message
> news:elOpBUvXAHA.204@cppssbbsa03...
> > I've opened SQLBase using a DSN, something like:
> >
> > cn.Open "DSN=SQLbase;uid=syssql;pwd=syssql"
> >
> > - Tom
> >
Bernie Yaeger
Sorry if this is redundant and you already have your answer, but the answer to
the null issue is pretty simple: it's an advanced setting in the dsn that
allows you to turn off the null default.
Regards,
Bernie
Robert Baker wrote:
> Lars,
>
> Yes, I have connected to Visual FoxPro using both RDS and ADO with success.
> I however have yet to be successful with insertions to tables containing
> BLOB columns. Memo columns were initially also a problem but I have
> resolved this issue. Somehow, VFP wants all columns to be NOT NULL during
> insertion. If someone has resolved this I would be most appreciative to
> hear how to allow null values to be inserted. Personally, I am unaware of a
> product called SQLBase.
>
> Robert Baker
>