Corbett:
I'd love a copy of your write up.
Thanks.
Rick Gors
MR/MMIS
Osco
corbettl@... wrote:
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[Non-text portions of this message have been removed]
> 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/