Corbett:

I'd love a copy of your write up.

Thanks.

Rick Gors
MR/MMIS
Osco

corbettl@... wrote:

> I *finally* got my ASP/ODBC stuff working like it should. And it's
> fast. Don't listen to anyone that says to just buy WebSpeed or
> whatever, becaue that's $15,000 down the toilet. Anyway, anyone
> interested in knowing EXACTLY how to setup Vantage to run via the
> webpage through ODBC, email me. I'll be writting up a WORD doc on the
> procedure. Trust me, it isn't documented ANYWHERE! I tried absolutely
> every combination of software and configurations to get this running.
> And there aren't any weird procedures that you have to do to get it
> running either... but they just have to be EXACT.
>
> Anyway, if you want to email me direct (instead of the webpage) use
> CorbettL(at)ImageNational.com
>
> -Corbett Lashbrook
>
> --- In vantage@y..., corbettl@i... wrote:
> > I tried everything you tried, and it still didn't work. I think I
> > have 2 things going against me. 1 is my webserver doesn't hold a
> copy
> > of the SAM database, so user accounts aren't stored on it, and 2, it
> > doesn't hold the Progress DB either. In everything I've read, it
> seams
> > to me that this is all a rights issue. I'm thinking I might need
> > to set up IIS on my Progress machine, and have my web server do
> > reverse hosting to it. That way, any webpages needing Progress
> access
> > would be local.
> >
> > I'll give this a try and let you know what happens. I REALLY
> > appreciate you responding back. This gave me some new ideas and
> > directions. Anyone else with suggestions, please post them now! =)
> >
> > Thanks again!
> >
> > Corbett Lashbrook
> >
> > --- In vantage@y..., "Gitzlaff, Christopher" <cgitzlaff@m...> wrote:
> > > Corbett,
> > >
> > > I'm actually having considerable success with Active Server
> > Pages... now. I
> > > was pulling the hair out of my skull for two weeks when I finally
> > figured it
> > > out. The "optional feature isn't implemented" fix isn't
> > necessary. I'm
> > > running ASP pages right now and none of them have the "On Error
> > Resume Next"
> > > statement (hmmm... might be a good idea, though).
> > >
> > > I was getting the same "optional feature isn't implemented"
> errors
> > you were.
> > > I'm using a W2K workstation running IIS 5. To fix this and get
> > myself
> > > running, I changed the account for anonymous access to a local
> > account that
> > > has admin privileges (this is on our intranet, so I'm not too
> > worried about
> > > being hacked). This still didn't fix my problem. The only way
> my
> > ODBC
> > > calls would succeed is if that local user was logged onto the
> > machine
> > > serving the web pages. No, I'm not using a User DSN. It is a
> > System DSN.
> > > I'm not sure why this works, but it does. I'm happy - I'd rather
> > write
> > > dynamic web based reports any day.
> > >
> > > I'll insert a sample of my working ASP code. Please, feel free
> to
> > call me -
> > > I can probably clarify my explanation and solution quite a bit.
> > >
> > > This code will return the ProjectID and Description of the first
> > Project
> > > record. DSN=Progress is a system DSN, and the vbCrLf statements
> > are just
> > > there to make the HTML source look pretty.
> > >
> > > <%@ LANGUAGE=VBScript %>
> > >
> > > <%
> > > strConnect = "DSN=Progress;UID=;PWD=;"
> > > Set dbsVantage = Server.CreateObject("ADODB.Connection")
> > > dbsVantage.Open strConnect
> > > Set rstProject = Server.CreateObject("ADODB.Recordset")
> > > strSQL = "SELECT * FROM Project"
> > > rstProject.Open strSQL, dbsVantage
> > >
> > > Response.Write "<HTML>" & vbCrLf
> > > Response.Write "<HEAD><TITLE>Project Test</TITLE></HEAD>" & vbCrLf
> > > Response.Write "<BODY>" & vbCrLf
> > > Response.Write "<H1>Project Test</H1>" & vbCrLf
> > > Response.Write "<P>" & rstProject("ProjectID") & "is called " &
> > > rstProject("Description") & "</P>" & vbCrLf
> > > Response.Write "</BODY></HTML>
> > >
> > > rstProject.Close
> > > dbsVantage.Close
> > > %>
> > >
> > > Chris Gitzlaff
> > > Manager - Information Systems & Technology
> > > Major Industries, Inc.
> > > 715.842.4616
> > > cgitzlaff@m...
> > >
> > >
> > >
> > > -----Original Message-----
> > > From: corbettl@i... [mailto:corbettl@i...]
> > > Sent: Thursday, February 15, 2001 2:41 PM
> > > To: vantage@y...
> > > Subject: [Vantage] Re: Active Server Pages and Progress
> > >
> > >
> > > According to Progress Knowledge base, you need to add an extra
> > > piec of code at the beginning of your ASP that continues running
> > > the script even though Progress reports back to the SQL connector
> > > that the "Optional feature isn't implemented". They actually have
> > > a tech document that says that it will always return that to the
> > > ASP if you don't put this code in. The code is as follows:
> > >
> > > <%@Language=VBScript%>
> > >
> > > <%
> > > on error Resume Next
> > >
> > > etc, etc, etc....
> > >
> > > I only put the Language reference in to show you the placement
> > > of the command. It should be the very first thing you run
> > > when you start your ASP code.
> > >
> > > I've been able to sucessfully pull data from a freeware program
> > > called ODBCTEST. If you run the SQL commands against the database,
> > > it returns the data exactly as it should. Our problem NOW though
> > > is that when we run the EXACT SAME SELECT COMMANDS from ASP, they
> > > come back saying that no such records exist. I'm about 1 step away
> > > from ripping my hair out, but I'll probably call Progress or
> > > Epicor before that! :)
> > >
> > > If anyone can help with the ASP PLEASE post it. I'm about to
> scream!
> > > AAAAAAHHHHHHH! :) Thanks in advance!
> > >
> > > Corbett Lashbrook
> > >
> > > --- In vantage@y..., "Gitzlaff, Christopher" <cgitzlaff@m...>
> wrote:
> > > > Has anybody successfully connected to the Progress Database
> from
> > an
> > > Active
> > > > Server Page? I'm trying to get this working, but I receive the
> > > following
> > > > error:
> > > >
> > > > Error Type:
> > > > Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
> > > > [MERANT][ODBC PROGRESS driver]Optional feature not implemented.
> > > >
> > > > I'm performing this on a W2K machine running IIS 5 and the
> latest
> > > MERANT
> > > > ODBC drivers and patches.
> > > >
> > > > Thanks,
> > > >
> > > > Chris Gitzlaff
> > >
> > >
> > >
> > > To unsubscribe from this group, send an email to:
> > > vantage-unsubscribe@egroups.com
>
>
> To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please go to: http://groups.yahoo.com/group/vantage/files/. Note: You must have already linked your email address to a yahoo id to enable access.
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

[Non-text portions of this message have been removed]

Is there a flowchart or written documentation available on this process of connecting the Progress DB with ASPs?

-----Original Message-----
From: John [SMTP:JYohann@...]
Sent: Wednesday, January 31, 2001 12:25 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Active Server Pages and Progress

Yes. You can connect to the Progress DB with ASP's. I have a consultant
that did this successfully a few months back as a test.
Have you installed the Microsoft Data Access Components - aka MDAC?
That is probably the cause of the error message.

John

-----Original Message-----
From: Gitzlaff, Christopher [mailto:cgitzlaff@...]
Sent: Wednesday, January 31, 2001 11:30 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Active Server Pages and Progress

Has anybody successfully connected to the Progress Database from an Active
Server Page? I'm trying to get this working, but I receive the following
error:

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[MERANT][ODBC PROGRESS driver]Optional feature not implemented.

I'm performing this on a W2K machine running IIS 5 and the latest MERANT
ODBC drivers and patches.

Thanks,

Chris Gitzlaff

To unsubscribe from this group, send an email to:
vantage-unsubscribe@egroups.com

To unsubscribe from this group, send an email to:
vantage-unsubscribe@egroups.com

[Non-text portions of this message have been removed]

According to Progress Knowledge base, you need to add an extra
piec of code at the beginning of your ASP that continues running
the script even though Progress reports back to the SQL connector
that the "Optional feature isn't implemented". They actually have
a tech document that says that it will always return that to the
ASP if you don't put this code in. The code is as follows:

<%@Language=VBScript%>

<%
on error Resume Next

etc, etc, etc....

I only put the Language reference in to show you the placement
of the command. It should be the very first thing you run
when you start your ASP code.

I've been able to sucessfully pull data from a freeware program
called ODBCTEST. If you run the SQL commands against the database,
it returns the data exactly as it should. Our problem NOW though
is that when we run the EXACT SAME SELECT COMMANDS from ASP, they
come back saying that no such records exist. I'm about 1 step away
from ripping my hair out, but I'll probably call Progress or
Epicor before that! :)

If anyone can help with the ASP PLEASE post it. I'm about to scream!
AAAAAAHHHHHHH! :) Thanks in advance!

Corbett Lashbrook

--- In vantage@y..., "Gitzlaff, Christopher" <cgitzlaff@m...> wrote:
> Has anybody successfully connected to the Progress Database from an
Active
> Server Page? I'm trying to get this working, but I receive the
following
> error:
>
> Error Type:
> Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
> [MERANT][ODBC PROGRESS driver]Optional feature not implemented.
>
> I'm performing this on a W2K machine running IIS 5 and the latest
MERANT
> ODBC drivers and patches.
>
> Thanks,
>
> Chris Gitzlaff

Corbett,

I'm actually having considerable success with Active Server Pages... now. I
was pulling the hair out of my skull for two weeks when I finally figured it
out. The "optional feature isn't implemented" fix isn't necessary. I'm
running ASP pages right now and none of them have the "On Error Resume Next"
statement (hmmm... might be a good idea, though).

I was getting the same "optional feature isn't implemented" errors you were.
I'm using a W2K workstation running IIS 5. To fix this and get myself
running, I changed the account for anonymous access to a local account that
has admin privileges (this is on our intranet, so I'm not too worried about
being hacked). This still didn't fix my problem. The only way my ODBC
calls would succeed is if that local user was logged onto the machine
serving the web pages. No, I'm not using a User DSN. It is a System DSN.
I'm not sure why this works, but it does. I'm happy - I'd rather write
dynamic web based reports any day.

I'll insert a sample of my working ASP code. Please, feel free to call me -
I can probably clarify my explanation and solution quite a bit.

This code will return the ProjectID and Description of the first Project
record. DSN=Progress is a system DSN, and the vbCrLf statements are just
there to make the HTML source look pretty.

<%@ LANGUAGE=VBScript %>

<%
strConnect = "DSN=Progress;UID=;PWD=;"
Set dbsVantage = Server.CreateObject("ADODB.Connection")
dbsVantage.Open strConnect
Set rstProject = Server.CreateObject("ADODB.Recordset")
strSQL = "SELECT * FROM Project"
rstProject.Open strSQL, dbsVantage

Response.Write "<HTML>" & vbCrLf
Response.Write "<HEAD><TITLE>Project Test</TITLE></HEAD>" & vbCrLf
Response.Write "<BODY>" & vbCrLf
Response.Write "<H1>Project Test</H1>" & vbCrLf
Response.Write "<P>" & rstProject("ProjectID") & "is called " &
rstProject("Description") & "</P>" & vbCrLf
Response.Write "</BODY></HTML>

rstProject.Close
dbsVantage.Close
%>

Chris Gitzlaff
Manager - Information Systems & Technology
Major Industries, Inc.
715.842.4616
cgitzlaff@...

-----Original Message-----
From: corbettl@... [mailto:corbettl@...]
Sent: Thursday, February 15, 2001 2:41 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Active Server Pages and Progress

According to Progress Knowledge base, you need to add an extra
piec of code at the beginning of your ASP that continues running
the script even though Progress reports back to the SQL connector
that the "Optional feature isn't implemented". They actually have
a tech document that says that it will always return that to the
ASP if you don't put this code in. The code is as follows:

<%@Language=VBScript%>

<%
on error Resume Next

etc, etc, etc....

I only put the Language reference in to show you the placement
of the command. It should be the very first thing you run
when you start your ASP code.

I've been able to sucessfully pull data from a freeware program
called ODBCTEST. If you run the SQL commands against the database,
it returns the data exactly as it should. Our problem NOW though
is that when we run the EXACT SAME SELECT COMMANDS from ASP, they
come back saying that no such records exist. I'm about 1 step away
from ripping my hair out, but I'll probably call Progress or
Epicor before that! :)

If anyone can help with the ASP PLEASE post it. I'm about to scream!
AAAAAAHHHHHHH! :) Thanks in advance!

Corbett Lashbrook

--- In vantage@y..., "Gitzlaff, Christopher" <cgitzlaff@m...> wrote:
> Has anybody successfully connected to the Progress Database from an
Active
> Server Page? I'm trying to get this working, but I receive the
following
> error:
>
> Error Type:
> Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
> [MERANT][ODBC PROGRESS driver]Optional feature not implemented.
>
> I'm performing this on a W2K machine running IIS 5 and the latest
MERANT
> ODBC drivers and patches.
>
> Thanks,
>
> Chris Gitzlaff

To unsubscribe from this group, send an email to:
vantage-unsubscribe@egroups.com

I tried everything you tried, and it still didn't work. I think I
have 2 things going against me. 1 is my webserver doesn't hold a copy
of the SAM database, so user accounts aren't stored on it, and 2, it
doesn't hold the Progress DB either. In everything I've read, it seams
to me that this is all a rights issue. I'm thinking I might need
to set up IIS on my Progress machine, and have my web server do
reverse hosting to it. That way, any webpages needing Progress access
would be local.

I'll give this a try and let you know what happens. I REALLY
appreciate you responding back. This gave me some new ideas and
directions. Anyone else with suggestions, please post them now! =)

Thanks again!

Corbett Lashbrook

--- In vantage@y..., "Gitzlaff, Christopher" <cgitzlaff@m...> wrote:
> Corbett,
>
> I'm actually having considerable success with Active Server
Pages... now. I
> was pulling the hair out of my skull for two weeks when I finally
figured it
> out. The "optional feature isn't implemented" fix isn't
necessary. I'm
> running ASP pages right now and none of them have the "On Error
Resume Next"
> statement (hmmm... might be a good idea, though).
>
> I was getting the same "optional feature isn't implemented" errors
you were.
> I'm using a W2K workstation running IIS 5. To fix this and get
myself
> running, I changed the account for anonymous access to a local
account that
> has admin privileges (this is on our intranet, so I'm not too
worried about
> being hacked). This still didn't fix my problem. The only way my
ODBC
> calls would succeed is if that local user was logged onto the
machine
> serving the web pages. No, I'm not using a User DSN. It is a
System DSN.
> I'm not sure why this works, but it does. I'm happy - I'd rather
write
> dynamic web based reports any day.
>
> I'll insert a sample of my working ASP code. Please, feel free to
call me -
> I can probably clarify my explanation and solution quite a bit.
>
> This code will return the ProjectID and Description of the first
Project
> record. DSN=Progress is a system DSN, and the vbCrLf statements
are just
> there to make the HTML source look pretty.
>
> <%@ LANGUAGE=VBScript %>
>
> <%
> strConnect = "DSN=Progress;UID=;PWD=;"
> Set dbsVantage = Server.CreateObject("ADODB.Connection")
> dbsVantage.Open strConnect
> Set rstProject = Server.CreateObject("ADODB.Recordset")
> strSQL = "SELECT * FROM Project"
> rstProject.Open strSQL, dbsVantage
>
> Response.Write "<HTML>" & vbCrLf
> Response.Write "<HEAD><TITLE>Project Test</TITLE></HEAD>" & vbCrLf
> Response.Write "<BODY>" & vbCrLf
> Response.Write "<H1>Project Test</H1>" & vbCrLf
> Response.Write "<P>" & rstProject("ProjectID") & "is called " &
> rstProject("Description") & "</P>" & vbCrLf
> Response.Write "</BODY></HTML>
>
> rstProject.Close
> dbsVantage.Close
> %>
>
> Chris Gitzlaff
> Manager - Information Systems & Technology
> Major Industries, Inc.
> 715.842.4616
> cgitzlaff@m...
>
>
>
> -----Original Message-----
> From: corbettl@i... [mailto:corbettl@i...]
> Sent: Thursday, February 15, 2001 2:41 PM
> To: vantage@y...
> Subject: [Vantage] Re: Active Server Pages and Progress
>
>
> According to Progress Knowledge base, you need to add an extra
> piec of code at the beginning of your ASP that continues running
> the script even though Progress reports back to the SQL connector
> that the "Optional feature isn't implemented". They actually have
> a tech document that says that it will always return that to the
> ASP if you don't put this code in. The code is as follows:
>
> <%@Language=VBScript%>
>
> <%
> on error Resume Next
>
> etc, etc, etc....
>
> I only put the Language reference in to show you the placement
> of the command. It should be the very first thing you run
> when you start your ASP code.
>
> I've been able to sucessfully pull data from a freeware program
> called ODBCTEST. If you run the SQL commands against the database,
> it returns the data exactly as it should. Our problem NOW though
> is that when we run the EXACT SAME SELECT COMMANDS from ASP, they
> come back saying that no such records exist. I'm about 1 step away
> from ripping my hair out, but I'll probably call Progress or
> Epicor before that! :)
>
> If anyone can help with the ASP PLEASE post it. I'm about to scream!
> AAAAAAHHHHHHH! :) Thanks in advance!
>
> Corbett Lashbrook
>
> --- In vantage@y..., "Gitzlaff, Christopher" <cgitzlaff@m...> wrote:
> > Has anybody successfully connected to the Progress Database from
an
> Active
> > Server Page? I'm trying to get this working, but I receive the
> following
> > error:
> >
> > Error Type:
> > Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
> > [MERANT][ODBC PROGRESS driver]Optional feature not implemented.
> >
> > I'm performing this on a W2K machine running IIS 5 and the latest
> MERANT
> > ODBC drivers and patches.
> >
> > Thanks,
> >
> > Chris Gitzlaff
>
>
>
> To unsubscribe from this group, send an email to:
> vantage-unsubscribe@egroups.com

I *finally* got my ASP/ODBC stuff working like it should. And it's
fast. Don't listen to anyone that says to just buy WebSpeed or
whatever, becaue that's $15,000 down the toilet. Anyway, anyone
interested in knowing EXACTLY how to setup Vantage to run via the
webpage through ODBC, email me. I'll be writting up a WORD doc on the
procedure. Trust me, it isn't documented ANYWHERE! I tried absolutely
every combination of software and configurations to get this running.
And there aren't any weird procedures that you have to do to get it
running either... but they just have to be EXACT.

Anyway, if you want to email me direct (instead of the webpage) use
CorbettL(at)ImageNational.com

-Corbett Lashbrook

--- In vantage@y..., corbettl@i... wrote:
> I tried everything you tried, and it still didn't work. I think I
> have 2 things going against me. 1 is my webserver doesn't hold a
copy
> of the SAM database, so user accounts aren't stored on it, and 2, it
> doesn't hold the Progress DB either. In everything I've read, it
seams
> to me that this is all a rights issue. I'm thinking I might need
> to set up IIS on my Progress machine, and have my web server do
> reverse hosting to it. That way, any webpages needing Progress
access
> would be local.
>
> I'll give this a try and let you know what happens. I REALLY
> appreciate you responding back. This gave me some new ideas and
> directions. Anyone else with suggestions, please post them now! =)
>
> Thanks again!
>
> Corbett Lashbrook
>
> --- In vantage@y..., "Gitzlaff, Christopher" <cgitzlaff@m...> wrote:
> > Corbett,
> >
> > I'm actually having considerable success with Active Server
> Pages... now. I
> > was pulling the hair out of my skull for two weeks when I finally
> figured it
> > out. The "optional feature isn't implemented" fix isn't
> necessary. I'm
> > running ASP pages right now and none of them have the "On Error
> Resume Next"
> > statement (hmmm... might be a good idea, though).
> >
> > I was getting the same "optional feature isn't implemented"
errors
> you were.
> > I'm using a W2K workstation running IIS 5. To fix this and get
> myself
> > running, I changed the account for anonymous access to a local
> account that
> > has admin privileges (this is on our intranet, so I'm not too
> worried about
> > being hacked). This still didn't fix my problem. The only way
my
> ODBC
> > calls would succeed is if that local user was logged onto the
> machine
> > serving the web pages. No, I'm not using a User DSN. It is a
> System DSN.
> > I'm not sure why this works, but it does. I'm happy - I'd rather
> write
> > dynamic web based reports any day.
> >
> > I'll insert a sample of my working ASP code. Please, feel free
to
> call me -
> > I can probably clarify my explanation and solution quite a bit.
> >
> > This code will return the ProjectID and Description of the first
> Project
> > record. DSN=Progress is a system DSN, and the vbCrLf statements
> are just
> > there to make the HTML source look pretty.
> >
> > <%@ LANGUAGE=VBScript %>
> >
> > <%
> > strConnect = "DSN=Progress;UID=;PWD=;"
> > Set dbsVantage = Server.CreateObject("ADODB.Connection")
> > dbsVantage.Open strConnect
> > Set rstProject = Server.CreateObject("ADODB.Recordset")
> > strSQL = "SELECT * FROM Project"
> > rstProject.Open strSQL, dbsVantage
> >
> > Response.Write "<HTML>" & vbCrLf
> > Response.Write "<HEAD><TITLE>Project Test</TITLE></HEAD>" & vbCrLf
> > Response.Write "<BODY>" & vbCrLf
> > Response.Write "<H1>Project Test</H1>" & vbCrLf
> > Response.Write "<P>" & rstProject("ProjectID") & "is called " &
> > rstProject("Description") & "</P>" & vbCrLf
> > Response.Write "</BODY></HTML>
> >
> > rstProject.Close
> > dbsVantage.Close
> > %>
> >
> > Chris Gitzlaff
> > Manager - Information Systems & Technology
> > Major Industries, Inc.
> > 715.842.4616
> > cgitzlaff@m...
> >
> >
> >
> > -----Original Message-----
> > From: corbettl@i... [mailto:corbettl@i...]
> > Sent: Thursday, February 15, 2001 2:41 PM
> > To: vantage@y...
> > Subject: [Vantage] Re: Active Server Pages and Progress
> >
> >
> > According to Progress Knowledge base, you need to add an extra
> > piec of code at the beginning of your ASP that continues running
> > the script even though Progress reports back to the SQL connector
> > that the "Optional feature isn't implemented". They actually have
> > a tech document that says that it will always return that to the
> > ASP if you don't put this code in. The code is as follows:
> >
> > <%@Language=VBScript%>
> >
> > <%
> > on error Resume Next
> >
> > etc, etc, etc....
> >
> > I only put the Language reference in to show you the placement
> > of the command. It should be the very first thing you run
> > when you start your ASP code.
> >
> > I've been able to sucessfully pull data from a freeware program
> > called ODBCTEST. If you run the SQL commands against the database,
> > it returns the data exactly as it should. Our problem NOW though
> > is that when we run the EXACT SAME SELECT COMMANDS from ASP, they
> > come back saying that no such records exist. I'm about 1 step away
> > from ripping my hair out, but I'll probably call Progress or
> > Epicor before that! :)
> >
> > If anyone can help with the ASP PLEASE post it. I'm about to
scream!
> > AAAAAAHHHHHHH! :) Thanks in advance!
> >
> > Corbett Lashbrook
> >
> > --- In vantage@y..., "Gitzlaff, Christopher" <cgitzlaff@m...>
wrote:
> > > Has anybody successfully connected to the Progress Database
from
> an
> > Active
> > > Server Page? I'm trying to get this working, but I receive the
> > following
> > > error:
> > >
> > > Error Type:
> > > Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
> > > [MERANT][ODBC PROGRESS driver]Optional feature not implemented.
> > >
> > > I'm performing this on a W2K machine running IIS 5 and the
latest
> > MERANT
> > > ODBC drivers and patches.
> > >
> > > Thanks,
> > >
> > > Chris Gitzlaff
> >
> >
> >
> > To unsubscribe from this group, send an email to:
> > vantage-unsubscribe@egroups.com