CODEWITHSUNDEEP
c#.netoledbmultivalue-databasepick
Badmate
Badmate

Reputation:

Connect to Pick Database using Odbc C# .Net

How to Connect to PickBasic database using Ole db driver .. I need it badly help me out

Upvotes: 2

Views: 5047

Answers (6)

PolyglotProgrammer
PolyglotProgrammer

Reputation: 53

There are tools available from www.rainingdata.com. I can't see any freeware options.

Rainingdata is now tiger logic. http://www.tigerlogic.com/tigerlogic/

And I've been to their worldwide conferences, but I don't recall any freeware. Its easy to program if you can stand using a dump terminal or a terminal emulation like Accuterm. Accuterm will allow you to program with GUI interface, but you will still have a lot of fun finding the files and programs you have to use.

Upvotes: 1

Billy Coover
Billy Coover

Reputation: 3837

We communicate with a Pick Basic db using a utility called Redback. I tried to find more information on Redback but I'm not having any luck. This Redback plugin sits on a the same unix server as Pick. Redback has several responders that are listening for request. Using .net, we make tcp requests to redback. The redback responders pick these requests up and process them (Pick takes over from here and I'll a little fuzzy on the details). Redback then sends the response back in xml and we parse that into a dataset.

In Pick, there was a generic subroutine created to handle these redback requests. This subroutine reads the details of the request and calls the proper subroutine based on the parameters sent in from the .net side. This program also handles the xml formatting to make sure that any data sent back from a subroutine is properly encoded and formatted.

I have a few friends on Stack that program and Pick and could probably go into more detail about how redback handles requests from .net. If you want more info, let me know.

Upvotes: 2

Noah
Noah

Reputation: 15340

Create an ODBC DSN Datasource, then use it just like any other ODBC connection

Upvotes: 0

Ravi
Ravi

Reputation: 21

I recently joined this company and i see they are using UniObjects.Net dll for interacting with this Data base Check it out its from IBM not sure about the performance though

Upvotes: 2

NoelProf
NoelProf

Reputation:

You should be able to connect to the D3 Pick database using ODBC. Connecting to Pick Basic doesn't make much sense. Here is a link to the D3 ODBC documentation.

http://www.rainingdata.com/support/documentation/odbc/index.html

Upvotes: 1

CurtTampa
CurtTampa

Reputation: 125

You did not specify which variation of the Pick OS you are running. So here's a generic solution.

I have customers using Liberty ODBC and it works just fine with the Pick OS. My customer is running mvBase. If you have D3, it already has a .net interface built in I believe.

Integration Software 604-682-8293 or fax 604-682-8499; http://www.libertyodbc.com

Upvotes: 1

Related Questions