NEONGAS 
Author Message
 NEONGAS

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:

<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



Wed, 19 Nov 2003 05:00:31 GMT  
 NEONGAS
I know sniffing neongas makes your head hurt, but other then that...


Quote:
> 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:

> <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



Thu, 20 Nov 2003 05:32:43 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. NEONGAS

2. NEONGAS

 

 
Powered by phpBB® Forum Software