Use the following script to change the port number of the MSDE databank:
First you will need a .reg file with the following entries:
###
Windows Registry Editor Version 5.00
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\SuperSocketNetLib\Tcp]
"DefaultPort"=dword:00000599
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\SuperSocketNetLib\VIA]
"DefaultServerPort"="0:1434"
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\SuperSocketNetLib\Tcp]
"TcpPort"="1434" | |
###
Once you have carried out the .reg file set up a VBScript.
In order to state the port (e.g. 1234) explicitly, you can attach “,1234” to the hostname.
A DSN in VBScript would then look something like this:
dsn = "Provider=SQLOLEDB;Initial Catalog=Nordwind;Data Source=127.0.0.1,1234;User Id=sa;Password=secret;"
|