I'm trying to test the code on an XP machine, ultimately the script will be running on NT/2000 boxes.
SQLDMO appears to be installed on my box (loads of entries in the registry) but I can't find some of the 'required' DLL/RLL files as specified in How to distribute and how to install SQL-DMO for SQL Server 2000
Does anyone know where to find these files or can provide me with an SQLDMO distribution package?
Platform: XP (eventually NT/2000)
SQL-DMO: Installed (entries in registry)
x-post: Forums: VBScript, Visual Basic, SQL Server, MS SQL
OK, I've changed this a bit, but still not connecting:
tConnection = "\\" & REMOTE_IP & "\" & REMOTE_GROUP
oServer.AutoReConnect = False ' allow event to be trapped
oServer.LoginSecure = False ' use provided username and password
oServer.LoginTimeout = 100
oServer.Connect tConnection, REMOTE_USERNAME, REMOTE_PASSWORD
Err.Description: [SQL-DMO]This server object is not connected.
The code looks OK.
As a test, try commenting out the first line & hard code the tConnection string. You may have an unexpected character or space on REMOTE_IP or REMOTE_GROUP.
Also, give it a try without the leading "\\"
Last edited by loquin; 03-09-06 at 10:21.
"Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
"I have my standards. They may be low, but I have them!" - Bette Middler
"It's a book about a Spanish guy named Manual. You should read it." - Dilbert