Re: ADP PICK database connect to SQL


drogers wrote:

> Hi. I am looking for information on how to connect to an ADP/PICK
> database with SQL.

ADP - you mean M$'s Access Data Project?

> I am a webdeveloper recently hired by an auto
> dealer. I am quite new to the pick world, and for that matter, almost
> all database programming outside of using PHP with mysql.
>
> All of the dealerships data is stored in a pick database.

A Pick database is much more than simply data. The Pick DBMS has its
own application development tools imbedded within it. Many people
without any background in IT have developed application software using
Pick's PickBasic, Access Query Language, and the various other tools in
the Pick box. If ADP bypasses both Jet and ODBC and allows raw queries
through to the Pick DBMS then it might be possible to extract the data
you're after by passing AQL (Pick) queries through to a listening
process on the Pick server - I don't know. You can also interact with
Pick via ODBC (although ODBC appears to have had its day without
winning many friends within the Pick community), or use OLEDB via VB
(which might be of more interest if you're coming at this from a M$
Access direction).

> I am charged
> with making a website that is able to display that data online.
>
> One possible route has been exporting the pick data to csv files and
> putting them on the linux side and then grabbing them from there and
> importing them into sql. this seems to be overly complicated,
> however. ideally, i could like to connect to the database via sql and
> interact with it directly.

You could export the data from Pick and transform it and load it into a
different database. Probably a lot more trouble than it's worth - imo.
If you want to use SQL (the language) to connect directly to Pick then
you're using ODBC. Possible.

>
> could someone help me get a good start on doing this?

I really think the best place to start is to firmly grasp that the Pick
DBMS is much, much more than just data. Think of the web pages as the
presentation layer (ultra thin client), the web server as a mere
conduit (ultra thin web server), and the Pick DBMS as both application
server and database combined. When you see both the client and web
server as ultra-thin, and if you're prepared to take it as read that
the Pick DBMS is ultra efficient and yet surprisingly simple to use,
you will have the best start I could give you. You can then build on
this framework - smarts on the client/browser, tools on the web-server
and a whole load of smarts on the Pick side - if you like.

> is it even
> possible? i played around with software like pixieware, but it seemed
> like it wasn't up to the task. i tried several different connection
> configuration files, but they all errored out.
>
> any ideas? any help is very much appreciated.

I would concur with others here who have suggested FlashCONNECT - as
one of many options. It comes in two parts - one part you load on the
web server, the other on the Pick application server (which can, in
fact, both be on the same physical box or, alternatively, you can share
many web servers with many Pick application servers). You would have to
write some PickBasic code to deal with requests from the web server.
Ask here for help with that if you need it - or search the archives for
tips.

Cheers
Mike.

.

Relevant Pages

  • Re: MV and SQL
    ... >>> Are you sure that a column in Pick is equivalent to a column in an SQL ... > You can also change the type from varchar to array if your SQL DBMS support ... > for variables that store the data retrieved from the database. ... >>> SQL is not the only language. ...
    (comp.databases.theory)
  • Re: File-System or DBMS? (non-flammable clothing optional)
    ... You are simply distinguishing Pick/MV DBMSs from the rest on the ... DBMS's contain all data formatting and logical testing within the Database ... There is no generally-accepted definition of what a true DBMS is, ... I understand it) to a SQL DBMS, but it is precisely because it is Pick ...
    (comp.databases.pick)
  • Re: SQL conversion
    ... SQL Server can likely provide XML ... wanted to do a direct link from the web server to the SQL-1 machine, ... This database on the SQL is just basically a membership database, ...
    (comp.lang.clipper)
  • Re: Databinding - Best Practice (object-oriented)
    ... >difficult to persuade developers to ditch the database independance this ... IMO DBMS independance is a myth. ... BTW SQL Server is not very faithful to the ISO standards. ... >Server does not support them. ...
    (microsoft.public.dotnet.framework.windowsforms)
  • Re: Data transfer/input from external website
    ... BUT this would mean exposing your SQL server to external ... you could leave it on the web server in an Access or XML ... > database for automated processes you setup. ... > web service to only include the IP of the external web server (and/or ...
    (microsoft.public.windows.server.sbs)