Re: [Emerald] Web Page

Jeff Woods ( jwoods@delta.com )
Sat, 05 Dec 1998 23:16:05 -0500

Does the WEB SERVER running it has ODBC installed and a DSN pointing to
Emerald? Did you modify the login.htm file properly (it has a hardcoded
path, and if you didn't install to that path, it won't work)?

Here's my LOGIN.IDC file, with password blanked:

Datasource: EMERALD
Username: Jeff
Password: MYOB
Template: login.htx
RequiredParameters: pass,id
SQLStatement:
+select subaccounts.login, subaccounts.password, subaccounts.customerid,
masteraccounts.customerid, masteraccounts.maexpiredate expire
+from subaccounts,masteraccounts where subaccounts.login='%id%' and
subaccounts.password='%pass%' and
subaccounts.customerid=masteraccounts.customerid

I have ODBC installed on the IIS machine, with the DSN set as per the IDC
file.

Then you have to modify LOGIN.HTM to properly point to the scripts:

User Account Information Login

User Account Information Login

......Then you make the call to LOGIN.HTM, not to LOGIN.IDC. The .HTM file doesthe work, calls the IDC file, gets the password and login ID, and thencalls the other appropriate scripts.At 12:19 PM 12/5/98 +0000, you wrote:>I downloaded that same one...>I alreay modified login.idc and added my username and password, but I get>the following errror:>>Error Performing Query>> [State=IM002][Error=0][Microsoft][ODBC Driver Manager] Data source>name not found and no default driver specified >>Any ideas what this might be?>>Thanks!>Humberto G>>>At 08:40 AM 12/2/98 -0500, you wrote:>>WHICH ones did you download? I just got the ones in ACCTINFO.ZIP working>>after a bit of difficulty. Tell me exactly what you are doing, and I'll>>try to help....>>>>At 07:33 PM 12/1/98 +0000, you wrote:>>>Hello,>>>>>>I am still using the old version of Emerald... I am trying to let my>>>clients see the Time Left for their accounts through a Web Page... I>>>downloaded the ones in the ftp site, but I get the following error:>>>>>>Error Performing Query>>>>>> [State=IM002][Error=0][Microsoft][ODBC Driver Manager] Data source>>>name not found and no default driver specified >>>>>>Any ideas?>>>>>>Thanks!>>>Humberto Guzman>>>>>>>>>>>>For more information about this list, including removal,>>>please see http://www.iea-software.com/maillist.html>>>>>>>For more information about this list, including removal,>>please see http://www.iea-software.com/maillist.html>> >>For more information about this list, including removal,>please see http://www.iea-software.com/maillist.html>