-
Port numbers
Thanks to the latest virus our ISA server decided to kick it and needed a rebuild. They lost the config of the server so they are doing it from scratch. What I need is for them to open up a port so I can hit an external MS sql server. I can open this external sql server through Query Analyzer but can not reach it through either a link server or through ADO code in ASP using an OLE connection. Anyone know what I would need open to connect to the external server through the ASP code?
Thanks
-
for remote sql server, the port # is 1433. The following is the Tornado aspx code to do that ->
<script language='vb' runat='server'>
Sub Page_Load(Source as Object, E as EventArgs)
Dim T As New Tornado.Z()
T.dbSkin=1
T.dbDBType="SQL"
'...ServerName or IP,Port; DBName; UID; Password; User_Specified
T.dbDSN="www.fkw.us,1433;pubs;id;pass;Network Library=DBMSSOCN;Connect timeout=15"
T.dbSQL="SELECT * FROM authors"
T.ASPdbNet
'...This is the way to connect to an MS-SQL WAN server via IP. URL will be converted to IP.
End Sub
</script>
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|