Solved

DSNless connection to Progress Database using ASP

Posted on 2004-08-06
10
510 Views
Last Modified: 2008-01-09
Has anyone ever done this?  I know very little about the "Progress" database, but I need to access its tables somehow through ASP so my client can view their data through their intranet.

Ultimately I'd like to be able to update/insert data to Progress from my ASP pages as well, but if I can just get a connection that'd be lovely.  

I've also got SQL Server 2000 installed on their server which I use for the majority of the intranet data, but there is some real time data that I'd like to capture and display on their site that comes from Progress.  I guess it uses ODBC, but I don't know what the connection string would look like.

Thanks in advance.
0
Comment
Question by:tekchic
  • 4
  • 4
  • 2
10 Comments
 
LVL 8

Expert Comment

by:dds110
ID: 11737174
is "Progress" a type of database or the Name of the database?  I've checked all of my resources and can honestly say I've never heard of a type of database called "Progress".  Can you provide any more info???
0
 
LVL 39

Assisted Solution

by:appari
appari earned 250 total points
ID: 11737187
check the following link not sure, might help

http://forums.datadirect.com/forums/thread.jspa?threadID=242&tstart=0
0
 
LVL 8

Accepted Solution

by:
dds110 earned 250 total points
ID: 11737201
found this page, it might help

http://www.openlinksw.com/support/conprog.htm
0
 
LVL 39

Expert Comment

by:appari
ID: 11737202
0
 
LVL 8

Expert Comment

by:dds110
ID: 11737214
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
LVL 4

Author Comment

by:tekchic
ID: 11737224
Neither have I until recently.....sad isn't it?  Apparently it's used a little in manufacturing/repair/job shops.  I'm trying desperately to convince them to move their data over to SQL Server 2000 which is happily running on their servers, but to do that I've gotta get all the data outta this Progress thing and send it to SQL Server.

I've been searching EE using words like "Progress Database" et al and finding some decent links.....this db seems so proprietary and out of date.  Gag.

Here's a link that might give you more info, but looks like we're in the same boat, hahaha, only I've gotta do the conversion! ;-)
http://www.peg.com/
0
 
LVL 4

Author Comment

by:tekchic
ID: 11737245
Oh and I think http://www.progress.com/index.ssp which was of absolutely no value at all.

By the way (not directed at you dds) ;-)  I'm a Google expert and I've already done many many searches.  I'd up the points to 500+ for a real world working solution.
0
 
LVL 4

Author Comment

by:tekchic
ID: 11737263
That's a handy link though good job! :) I take it back, you guys found some that I didnt

>> found this page, it might help
>> http://www.openlinksw.com/support/conprog.htm

That one has a great diagram that at leasts explains a bit more :)
0
 
LVL 4

Author Comment

by:tekchic
ID: 11737279
Actually the links you guys sent are FANTASTIC -- and the code looks like it might be plausible (I'll have to get home to the server and try it)

I'll probably up the ante and split points for you both for a fast response.  THANKS!!
0
 
LVL 8

Expert Comment

by:dds110
ID: 11738735
just glad I could help.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
pass url parameter as session 9 48
API Location, separating out information 10 46
ASP Button to clear text 4 44
Using Classic ASP inside HTML pages 2 56
I have helped a lot of people on EE with their coding sources and have enjoyed near about every minute of it. Sometimes it can get a little tedious but it is always a challenge and the one thing that I always say is:  The Exchange of information …
Have you ever needed to get an ASP script to wait for a while? I have, just to let something else happen. Or in my case, to allow other stuff to happen while I was murdering my MySQL database with an update. The Original Issue This was written…
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…
In this video I am going to show you how to back up and restore Office 365 mailboxes using CodeTwo Backup for Office 365. Learn more about the tool used in this video here: http://www.codetwo.com/backup-for-office-365/ (http://www.codetwo.com/ba…

867 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now