Connection string conversion

I have a need to connect to an IP21 server and pull data from it and post it to the web. there is currently a VB progrm that runs and pull some data and the connection string that program uses is as follows:
'Dimension the connection string and odbc command.

Dim StrConn As String = "Driver={AspenTech SQLPlus};HOST=" & HostName & ";PORT=10014"

Dim oCmd As New System.Data.Odbc.OdbcCommand

Dim IntegerIndex As Integer

'Create and open the connection to the server.

oCmd.Connection = New System.Data.Odbc.OdbcConnection(StrConn)

oCmd.Connection.Open()

'Execute the SQL command.

oCmd.CommandText = SqlCommand

Open in new window


what i need to do is figure out how to make this connection string work in an ASP webpage. can someone help me with that?
jlcannonAsked:
Who is Participating?
 
omgangIT ManagerCommented:
Try in your ASP page

<%
Dim conn, rs

Set conn = Server.CreateObject("ADODB.Connection")
conn.ConnectionString = "Driver={AspenTech SQLPlus};HOST=TheHostName;PORT=10014"

conn.open

set rs=conn.Execute(SqlCommand)

%>

Will you still need to pass the host name dynamically?  If so, You'll need to add to the script a method to obtain the host name into a variable and then use the variable in the connection string assignment just like in the VB program.

OM Gang
0
 
jlcannonAuthor Commented:
no need to pass host dynamically since it is a single host and will not change i can just hard code it. Thank you!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.