tekchic
asked on
DSNless connection to Progress Database using ASP
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.
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.
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???
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
here's another one that might help
http://media.datadirect.com/download/docs/odbc/odbcref/progress10.html
http://media.datadirect.com/download/docs/odbc/odbcref/progress10.html
ASKER
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/
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/
ASKER
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.
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.
ASKER
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 :)
>> 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 :)
ASKER
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!!
I'll probably up the ante and split points for you both for a fast response. THANKS!!
just glad I could help.