We are using SQL 7.0 on one server and IIS 3.0 on another server
using ODBC to connect to the Emerald SQL database. This ASP script
file works from here http://www.apex2000.net/radius/database/mytest.asp
(you will be prompted for an NT user ID and password) but the same
script executes but does not connect to the database from here:
http://www.apex2000.net/scripts/mytest.asp
I never had to deal with the global.asa to access our many Access
databases via ODBC. Any global.asa examples would be appreciated.
Thanks!
_____________________________________________________________________
Bob Dozier rwdozier@apex2000.net
Apex 2000 Internet Services Corporation Phone: (915) 570-1676
-----Original Message-----
From: emerald-digest-request@iea-software.com
<emerald-digest-request@iea-software.com>
To: emerald-digest@iea-software.com <emerald-digest@iea-software.com>
Date: Wednesday, June 02, 1999 2:05 AM
Subject: Emerald Digest
>Message 1: RE: [Emerald] SQL Server 7.0 Internet Connector and Emerald
> from ronnie@itexas.net (Ronnie D. Franklin)
>
>Message 2: Re: [Emerald] SQL Server 7.0 Internet Connector and Emerald
> from "Dan Tang" <dan@dmn.com.au>
>
>
>.------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
>| Message 1 |
>'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
>Subject: RE: [Emerald] SQL Server 7.0 Internet Connector and Emerald
>From: ronnie@itexas.net (Ronnie D. Franklin)
>Date: Wed, 2 Jun 1999 00:26:08 -0500
>
>You do not have to have SQL 7.. it works fine with 6.5
>
>You apparently do not have the ODBC setup properly.
>
>> -----Original Message-----
>> From: emerald-request@iea-software.com
>> [mailto:emerald-request@iea-software.com]On Behalf Of Bob Dozier
>> Sent: Wednesday, June 02, 1999 12:06 AM
>> To: emerald@iea-software.com
>> Subject: [Emerald] SQL Server 7.0 Internet Connector and Emerald
>>
>>
>> Could someone please confirm that in order to allow customers
>> to access their Emerald account data (billing information, connect
>> history, password changes, etc.) you'll need SQL Server 7.0 Internet
>> Connector? We have written some ASP to allow password changes and
>> discovered only our staff via our intranet can use them. Place
>> the ASP in the scripts or cgi-bin directories for customers
>> to use and it fails to connect with this error:
>>
>> [Microsoft][ODBC SQL Server Driver]Client unable to establish connection
>>
>> ASP with a connection to Access database via ODBC work fine.
>>
>> Pricing info is here:
>> http://www.microsoft.com/SQL/70/gen/pricing.htm#FullProduct
>>
>> Are there any options? Thanks.
>> _________________________________________________________________
>> Bob Dozier rwdozier@apex2000.net
>> Apex 2000 Internet Services Corporation Phone: (915) 570-1676
>>
>>
>
>
>.------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
>| Message 2 |
>'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
>Subject: Re: [Emerald] SQL Server 7.0 Internet Connector and Emerald
>From: "Dan Tang" <dan@dmn.com.au>
>Date: Wed, 2 Jun 1999 01:36:16 +0800
>
>You do not have a global.asa file under your NT web server root directory,
>or the ODBC setting on the web server does not match with the global.asa.
>
>
>Regards,
>
>Dan Tang
>Network Operation
>Domain Internet Access
>---------------------------------------------------
>Sign Up a Dial up account at http://isp.dmn.com.au and get connect right
>now.
>Free web hosting for commercial customers.
>---------------------------------------------------
>Join the Emerald ASP Addon Product mailing list
>by sending email to emerald-request@dmn.com.au with message body SUBSCRIBE
>only
>
>
>-----Original Message-----
>From: Bob Dozier <rwdozier@apex2000.net>
>To: emerald@iea-software.com <emerald@iea-software.com>
>Date: Wednesday, June 02, 1999 1:00 PM
>Subject: [Emerald] SQL Server 7.0 Internet Connector and Emerald
>
>
>>Could someone please confirm that in order to allow customers
>>to access their Emerald account data (billing information, connect
>>history, password changes, etc.) you'll need SQL Server 7.0 Internet
>>Connector? We have written some ASP to allow password changes and
>>discovered only our staff via our intranet can use them. Place
>>the ASP in the scripts or cgi-bin directories for customers
>>to use and it fails to connect with this error:
>>
>>[Microsoft][ODBC SQL Server Driver]Client unable to establish connection
>>
>>ASP with a connection to Access database via ODBC work fine.
>>
>>Pricing info is here:
>>http://www.microsoft.com/SQL/70/gen/pricing.htm#FullProduct
>>
>>Are there any options? Thanks.
>>_________________________________________________________________
>>Bob Dozier rwdozier@apex2000.net
>>Apex 2000 Internet Services Corporation Phone: (915) 570-1676
>>
>>
>
>
>
>