RE: ODBC connection via ASP

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

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