RE: ODBC connection via ASP

No, the web server is a different computer. Database: IDS 7.24 on IBM/AIX Web: IIS 4.0 on HP/Intel - NT 4.0 The database is listening on a port as defined in sqlhosts: #Server_name Protocol Host_name Service_name prod_tcp onsoctcp * sqlexec On the database server, /etc/services file: sqlexec 1234/tcp # the actual number is not important, but it must be unique On the web server, c:\\winnt\\system32\\drivers\\etc\\services file: sqlexec 1234/tcp # the number must match database server Web server setnet32 settings: Informix Server prod_tcp Protocolname onsoctcp Service Name sqlexec The connect string requires all of that stuff again: "DSN=SystemDSN;UID=user;PASSWORD=passwd;DB=dbname;HOST=hostname;SERV=sqlexec ;SRVR=server_name;PRO=onsoctcp;UID=user;" -----Original Message----- From: paoching [mailto:paoching@panpi.com.tw] Sent: Tuesday, March 23, 1999 6:48 PM To: informix-list@iiug.org Subject: Re: ODBC connection via ASP dear sir. Is your web server and database server on the same machine? We separate it into difference servers and the SERV entry already in the service file is on the database server. I have tried your suggestion, but I still fail! Any idea or suggestion can give me? Thanks! Schaeflein, Paul '''g''峹 <7d97cn$l1v$1@news.xmission.com>... > >SERV = sqlexec > >The Informix configuration (using setnet32.exe) requires a Service name. >The SERV entry should match the entry in the services file on the web >server. > >The PRO (protocol) entry should work either way, but I have not tried it... > >-----Original Message----- >From: David V'squez Estrada [mailto:vasquezd@ucbcba.edu.bo] >Sent: Tuesday, March 23, 1999 3:30 PM >To: Schaeflein, Paul; informix-list@iiug.org >Subject: Re: ODBC connection via ASP > > > > > >> >> > - make sure that the connection string has *ALL* of the Informix >> settings >> > - Example from my ASP: >> > "DSN=SystemDSN;UID=user;PASSWORD=passwd;DB=dbname; >> > >> > HOST=hostname;SERV=sqlexec;SRVR=server_name;PRO=onsoctcp;UID=user;" >> > >> > The SRVR is the DBSERVERNAME from $ONCONFIG. The UID is necessary >> > twice >> > >> >> What does mean SERV = sqlexec??? >> >> Can the PRO = onsoctcp be PRO = olsoctcp ??? What is the difference >between >> them??? >> >> I trying the same thing (ODBC connection via ASP) and it doesn't >work....I'm >> working with IDS 7.30.TC3 TNT (Windows NT) >> >> Thanks in advance! >> >> David

Thanks Paul, I still fail! I think the version of informix ODBD driver [INTERSOLV 3.11 32-BIT INFORMIX 9] may not work on ASP. Really thanks for your help! Schaeflein, Paul '''g''峹 <7db51c$fq4$1@news.xmission.com>... > >No, the web server is a different computer. > >Database: IDS 7.24 on IBM/AIX >Web: IIS 4.0 on HP/Intel - NT 4.0 > >The database is listening on a port as defined in sqlhosts: > >#Server_name Protocol Host_name Service_name >prod_tcp onsoctcp * sqlexec> >On the database server, /etc/services file: >sqlexec 1234/tcp # the actual number is not important, but it >must be unique > >On the web server, c:\\winnt\\system32\\drivers\\etc\\services file: >sqlexec 1234/tcp # the number must match database server > >Web server setnet32 settings: >Informix Server prod_tcp >Protocolname onsoctcp >Service Name sqlexec > >The connect string requires all of that stuff again: >"DSN=SystemDSN;UID=user;PASSWORD=passwd;DB=dbname;HOST=hostname;SERV=sqlexe c >;SRVR=server_name;PRO=onsoctcp;UID=user;" > > >-----Original Message----- >From: paoching [mailto:paoching@panpi.com.tw] >Sent: Tuesday, March 23, 1999 6:48 PM >To: informix-list@iiug.org >Subject: Re: ODBC connection via ASP > > >dear sir. > >Is your web server and database server on the same machine? >We separate it into difference servers and the SERV entry already in the >service file is on the database server. >I have tried your suggestion, but I still fail! >Any idea or suggestion can give me? > >Thanks! > > >Schaeflein, Paul '''g''峹 <7d97cn$l1v$1@news.xmission.com>... >> >>SERV = sqlexec >> >>The Informix configuration (using setnet32.exe) requires a Service name. >>The SERV entry should match the entry in the services file on the web >>server. >> >>The PRO (protocol) entry should work either way, but I have not tried it... >> >>-----Original Message----- >>From: David V'squez Estrada [mailto:vasquezd@ucbcba.edu.bo] >>Sent: Tuesday, March 23, 1999 3:30 PM >>To: Schaeflein, Paul; informix-list@iiug.org >>Subject: Re: ODBC connection via ASP >> >> >> >> >> >>> >>> > - make sure that the connection string has *ALL* of the Informix >>> settings >>> > - Example from my ASP: >>> > "DSN=SystemDSN;UID=user;PASSWORD=passwd;DB=dbname; >>> > >>> > HOST=hostname;SERV=sqlexec;SRVR=server_name;PRO=onsoctcp;UID=user;" >>> > >>> > The SRVR is the DBSERVERNAME from $ONCONFIG. The UID is necessary >>> > twice >>> > >>> >>> What does mean SERV = sqlexec??? >>> >>> Can the PRO = onsoctcp be PRO = olsoctcp ??? What is the difference >>between >>> them??? >>> >>> I trying the same thing (ODBC connection via ASP) and it doesn't >>work....I'm >>> working with IDS 7.30.TC3 TNT (Windows NT) >>> >>> Thanks in advance! >>> >>> David >