IT SOLUTIONS
Your full service technology partner! 
-Collapse +Expand
KB
   ► KB ► > dsn Posts  Print This     

dsn Posts

"dsn" Knowledge Base Posts

More...
  KB Article    

Douglas.M
1. How to Save Time and Work When Creating a Paradox Report That Is Similar to Another

This is a simple discussion of a technique I use to create new Paradox reports quickly, which are similar to existing ones, yet functionally different in their purpose. Screen shots are included to illustrate the method I utilize.

Posted to KB Topic: Paradox & ObjectPAL
8 years ago, and updated 24 months ago

Article
Nothing New Since Your Last Visit
11323
Hits

Corel Paradox / ObjectPAL Coding

Wes Peterson
2. Connecting to Paradox Databases Via .NET

Recently, one of our message board visitors asked if was possible to connect to - and use - an existing Paradox databases with Visual Studio .NET. The answer is "Yes!"

Posted to KB Topic: Paradox ODBC Drivers
13 years ago, and updated 9 years ago
(1 Comments , last by yaret.r )

Article
Nothing New Since Your Last Visit
12406
Hits

Corel Paradox / ObjectPAL Coding

Fred Stevens
3. Building a DSN-less Connection: Listing available databases for a SQL Server

Using VFP and the Windows API to obtain and list the available databases for a selected server.

Posted to KB Topic: Visual FoxPro (VFP)
14 years ago, and updated 9 years ago
(2 Comments , last by polaze.m )

KB Post
Nothing New Since Your Last Visit
15209
Hits

Visual FoxPro

Mike Prestwood
4. Paradox 9/10/11 Versions (and WPO 2000)

Paradox 9 versions for SP1 through SP4. Plus version info on Paradox 10 and 11.

Posted to KB Topic: Installation, Setup, & BDE
11 years ago, and updated 10 years ago
(6 Comments , last by Cesar.N )

KB Post
Nothing New Since Your Last Visit
22710
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
5. What are aliases? Why use them? Overview of why using BDE aliases are a good idea.
12 years ago, and updated 11 years ago
(6 Comments , last by Randy.M2 )

KB Post
Nothing New Since Your Last Visit
16930
Hits

Corel Paradox / ObjectPAL Coding
More...

"dsn" Message Board Posts

More...

Thread 5 of 5

PS_3060
Connecting to PostgresSQL server
Hi,  I have been dragged back from retirement to fix a small Paradox database we use for design. Previously I used the Paradox ODBC to connect to the DB and all was well. The DB is now a PostgreSQL databse. I have installed the ODBC connection and can connect useing Access.  PostgreSQL35W ODBC System DSN On the paradox form I have a button to connect to the DB useing the following Code dynalias["UserName"] = "aaaaa", dynalias["Password"] = "XXXXXX" if not db.open(":PostgreSQL35W:", dynalias) then   ;Which Is the ODBC System DSN, , msginfo("Caliach Database Not Open", "stop") else message.visible = true ;UPDATE NEW PARTS, message = ("UPDATING PARTS DATA") sqlvar = sql SELECT PTMPTNO, PTMP1CD, PTMSTUM, PTMSEQ,PTMSATX , PTMUSE1, PTMUSE2, FROM altro.PTMFILE altro_ptmfile, WHERE PTMSEQ > ~oldptmseq, endsql executeSql(db, sqlvar, ":caliachData:NewParts"), , endif How do I change this to connect to the Postsgres35 DYN?
Posted to MB Topic: QBE & SQL « Paradox Board
14 years ago
1 Reply:

Steven.G
> ":PostgreSQL35W:" are you certain that the alias itself is correctly defined in the BDE and/or the app? > msginfo("Caliach Database Not Open", "stop") throw in an errorshow(), too.. might answer the question
14 years ago
Nothing New Since Your Last Visit
23
Hits

Thread 4 of 5

Yesid.B
PHP connecting through ODBC for Paradox table(.db)
{Too Long!}
Posted to MB Topic: PHP « PHP Board
14 years ago
1 Reply:

Suleman.K
It is a file-based database system with each table in a separate file or files., , high-performance metal detector
14 years ago
Nothing New Since Your Last Visit
615
Hits

Thread 3 of 5

Laura Lage
Using Paradox forms as front end to MySQL
{Too Long!}
14 years ago
Nothing New Since Your Last Visit
3079
Hits

Thread 2 of 5

Yesid.B
Unable to connect to Paradox table using ODBC
Hi there, I am trying to connect to a Paradox table in PHP using the INTERSOLV ODBC driver provided with Paradox. I am able to connect to the DSN fine but when I try to run a query, I get this error: , Warning: odbc_[e_xec(]) [function.odbc-exec]: SQL error: [INTERSOLV][ODBC Paradox driver][Paradox]Network initialization failed., SQL state S1000 in SQLExecDirect I have checked my lock files and that my BDE has the correct NET DIR location, which is on our server that houses all of our Paradox tables. I have also tried re-installing Paradox several times. I am able to open the tables from this machine using Paradox with no error so I'm confused as to why this could be happening. Any help would be much appreciated. Thanks!
Posted to MB Topic: Paradox Setup, Vista, etc. « Paradox Board
14 years ago
3 replies. Last post:

Yesid.B
Hi Steven, Thanks for the answer. I ended up solving the problem. The issue was that I was using Anonymous Authentication for the site on IIS and the user that was being used was a user that did not have appropriate permissions to access the lock file over the network. Hopefully this can help others who might run into this problem. Thanks!
14 years ago
Nothing New Since Your Last Visit
1093
Hits

Thread 1 of 5

Shawn.R
Trying to read Paradox 7 table in c#
{Too Long!}
Posted to MB Topic: VS.Net General & Other « C# Board
14 years ago
3 replies. Last post:

frumiami
Great info Wes! Thanks for the detailed response :) -Shawn
14 years ago
Nothing New Since Your Last Visit
6530
Hits
More...


Icon Legend:
Since your last logged visit:
- New to you or updated since your last visit (sign in now to activate).
- NOT new to you since your last visit (sign in now to activate).
Go ahead!   Use Us! Call: 916-726-5675  Or visit our new sales site: 
www.prestwood.com


©1995-2020 Prestwood IT Solutions.   [Security & Privacy]