jlcannon
asked on
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:
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?
'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
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER