NEON connection problem
Date: Sat, 21 Jul 2001 23:29:08 GMT
Message-ID: <2OYR6.633$ZL3.235321_at_nnrp3.sbc.net>
I can't get VBscript asp to connect to NEONGAS. I've gone to neon's home page (www.neonsys.com) and found an example script:
Problem Description:
Example of VBScript HTML page using Shadow Direct ODBC driver.
Resolution:
<%_at_ LANGUAGE = VBScript %>
<HTML>
<TITLE>Using ADO in a Visual Basic Script Web Page</TITLE>
</HEAD>
<LANGUAGE="VBS">
<!--#include file="E:\Program Files\Common Files\System\ADO\adovbs.inc"-->
<CENTER>
<H1><font size=4>Using ADO in a Visual Basic Script Web
Page</H1></font><br><br>
<%set myConnection = CreateObject("ADODB.Connection")
myConnection.Open "DSN=P392;"
SQLQuery = "select name from q.staff"
set RSTitleList = myConnection.Execute(SQLQuery)%>
<TABLE align=center COLSPAN=8 CELLPADDING=5 BORDER=0 WIDTH=200>
<!-- BEGIN column header row -->
<TR>
<TD VALIGN=TOP BGCOLOR="#800000">
<FONT STYLE="ARIAL NARROW" COLOR="#ffffff" SIZE=1>
Name</FONT>
</TD>
</TR>
<!-- Get Data -->
<% do while not RStitleList.EOF %>
<TR>
<TD BGcolor ="f7efde" align=center><font style ="arial narrow" size=1>
<%=RStitleList("Name")%></font>
</TD>
</TR>
<% RSTitleList.MoveNext%>
<%loop %>
<!-- Next Row -->
</TABLE>
</center>
</BODY>
</HTML>
I've tried the following scripts:
Set conn = Server.CreateObject("ADODB.Connection") conn.ConnectionString = "DSN=NEONGASDB2P;UID=myid;PWD=mypassword;" conn.Open
and:
Set conn = Server.CreateObject("ADODB.Connection") conn.Open "NEONGASDB2P","myid", "mypassword"
and I've tried variations on DSNless:
conn.ConnectionString = "Driver={NEON Client 32-bit};Host
Name=10.155.6.255;Port Number=1200;Uid=myid;Pwd=" & PsWd
conn.ConnectionTimeout = 30
conn.Open
My webserver locks up and I have to reset IIS, no events in event log. I
use these type connections with the Sybase Directconnect Driver. Does
anyone have any ideas I could try?
Thanks.
Glen Received on Sun Jul 22 2001 - 01:29:08 CEST