I.T. Discussion Community!
Yesid B -Collapse +Expand
-Collapse +Expand
Yesid.B
-Collapse +Expand Profile◄╣
Member Info
Member Narration

POSTS:
MB Posts (4)

Search Yesid.B:

Advanced
Business Account . . .
Yesid.B
-- --




Represented here by . . . 
Real Name:  Yesid B
Primary Role:  ---
Joined: Aug 2016 (37 months ago)
Visits: 17

Message Boards Activity

4 posts.
More...

Thread 4 of 4
Thread Starter or a Reply (but not last)  Group

Yesid.B
PHP connecting through ODBC for Paradox table(.db)
{Too Long!}
Posted to MB Topic: PHP « PHP Board
7 months ago
Nothing New Since Your Last Visit
234
Hits

PHP & Delphi for PHP

Thread 3 of 4
Thread Starter or a Reply (but not last)  Group

Yesid.B
ODBC Join tables
I am attempting to join two tables through an 'INDEX' field like so: SELECT w.LOCATION, w.BOLIN, w.DATEIN, w.LOT, w.QTY, w.UNITMEAS, w.CUSTCODE, w.WEIGHT, w.PRODUCTCODE, , w."INDEX", w.QUAR FROM wrhse AS w, items AS s , WHERE w.DATEOUT IS NULL AND s.poCode ='"+txtpoCode+"' AND w."INDEX" = s."INDEX" However I am not getting a result. Initially I was using the following: sql = 'SELECT * FROM subitemsTEST.DB WHERE poCode = '"+txtpoCode+"' order by index desc' to get the indexes and from there I would get the data from 'wrhse' having the indexes. But when I get more than 192 rows for some reason the system does not display the complete result set. Why can this be? How can I join two tables? Thank you in advance.
16 months ago

saifullah.s
{Too Long!}
12 months ago
Nothing New Since Your Last Visit
672
Hits

ASP Classic Coding

Thread 2 of 4
Thread Starter or a Reply (but not last)  Group

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
29 months ago

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!
29 months ago
Nothing New Since Your Last Visit
921
Hits

Corel Paradox / ObjectPAL Coding

Thread 1 of 4
Thread Starter or a Reply (but not last)  Group

Yesid.B
RE: Unable to connect to Paradox t
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!
Posted to MB Topic: Paradox Setup, Vista, etc. « Paradox Board
29 months ago
Nothing New Since Your Last Visit
Corel Paradox / ObjectPAL Coding
More...

Follow PrestwoodBoards on: 


©1995-2019 PrestwoodBoards  [Security & Privacy]
Professional IT Services: Coding | Websites | Computer Tech