We recently mapped an internal intranet website to our database, and
thus far here are some of the issues (and the solutions we implemented)
for them:
***SQL-92 sessions not ending on server***
Installed a progress patch.
Loaded the DB connection at the "global.asa" level
and refreshed it when a bad/dead connection was detected.
***DB Connection times were too long per page load***
Loaded the DB connection at the "global.asa" level
and refreshed it when a bad/dead connection was detected.
***Unsecure db connection strings/Identities in webpage***
Built VB6 or VB.Net COM component and compiled to DLL level
to obscure/hide DB activities from page user. Please Note:
building a VB.Net COM object will require backward compatability
to be built into it to support Classic ASP (not ASP.Net) coding.
Also, a .Net component will require the installation of the .Net
Framework.
Used DSN-less connection string to prevent ODBC DSN configuration issues
(DLL controls connection).
***Webserver wouldn't connect to database, no ODBC provider***
Installed netsetup from Progress/Vantage server.
***Field size precision does not match actual data size***
Search the group for this subject "CommentText has value exceeding its
max length (ODBC)".
There was a reply to it that contains the Epicor solution.
Other than that, just be sure that your DSN connection is read-only and
that your recordsets are readonly snapshots with a forward only cursor.
In fact, in one version of the DLL I built, I created a CLONE recordset
and ditched the db connection (which returned it to the connection pool)
so the connection was available to other users as soon as possible.
Also, I don't recall exactly where it is, but there is a setting on the
DB server where you set the number of SQL sessions vs. the number of
user sessions. AFAIK, you have only a set number of DB connections
total!
Andrew Reed
Crestview Aerospace Corp.
________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Dianna Musgrave
Sent: Monday, May 15, 2006 4:23 PM
To: vantage@yahoogroups.com
Subject: [Vantage] internet retail site ODBC
Has anyone tried to retrieve real-time inventory through ODBC to a
production Progress database for a retail internet site? If so, what
does
it take, what are the performance problems, and is it a really bad idea?
Thanks,
Dianna Musgrave
Stone County Ironworks
870-269-8108 ext. 2099
[Non-text portions of this message have been removed]
thus far here are some of the issues (and the solutions we implemented)
for them:
***SQL-92 sessions not ending on server***
Installed a progress patch.
Loaded the DB connection at the "global.asa" level
and refreshed it when a bad/dead connection was detected.
***DB Connection times were too long per page load***
Loaded the DB connection at the "global.asa" level
and refreshed it when a bad/dead connection was detected.
***Unsecure db connection strings/Identities in webpage***
Built VB6 or VB.Net COM component and compiled to DLL level
to obscure/hide DB activities from page user. Please Note:
building a VB.Net COM object will require backward compatability
to be built into it to support Classic ASP (not ASP.Net) coding.
Also, a .Net component will require the installation of the .Net
Framework.
Used DSN-less connection string to prevent ODBC DSN configuration issues
(DLL controls connection).
***Webserver wouldn't connect to database, no ODBC provider***
Installed netsetup from Progress/Vantage server.
***Field size precision does not match actual data size***
Search the group for this subject "CommentText has value exceeding its
max length (ODBC)".
There was a reply to it that contains the Epicor solution.
Other than that, just be sure that your DSN connection is read-only and
that your recordsets are readonly snapshots with a forward only cursor.
In fact, in one version of the DLL I built, I created a CLONE recordset
and ditched the db connection (which returned it to the connection pool)
so the connection was available to other users as soon as possible.
Also, I don't recall exactly where it is, but there is a setting on the
DB server where you set the number of SQL sessions vs. the number of
user sessions. AFAIK, you have only a set number of DB connections
total!
Andrew Reed
Crestview Aerospace Corp.
________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Dianna Musgrave
Sent: Monday, May 15, 2006 4:23 PM
To: vantage@yahoogroups.com
Subject: [Vantage] internet retail site ODBC
Has anyone tried to retrieve real-time inventory through ODBC to a
production Progress database for a retail internet site? If so, what
does
it take, what are the performance problems, and is it a really bad idea?
Thanks,
Dianna Musgrave
Stone County Ironworks
870-269-8108 ext. 2099
[Non-text portions of this message have been removed]