I am unable to establish a connection to SQL Server 7 systems using the following line:
my $SQLSession = Win32::OLE->new("SQLDMO.SQLServer"
Does anybody know why this won't work on SQL Server 7? I can get to our SQL 6.5 servers without any problems using
my $SQLSession = Win32::OLE->new("SQLOLE.SQLServer"
The documentation I have from Microsoft maintains that the
"SQLDMO.SQLServer" connection has to be used for SQL Server 7. When I use the "SQLOLE.SQLServer" with SQL Server 7, it will connect, but after that, doesn't seem to be able to return the objects that the program needs. I think I simply need to get the connection to engage. One thing that I did do was successfully register the sqldmo.dll file on the server, but I still couldn't connect with "SQLDMO.SQLServer".
Please help!!!
my $SQLSession = Win32::OLE->new("SQLDMO.SQLServer"
Does anybody know why this won't work on SQL Server 7? I can get to our SQL 6.5 servers without any problems using
my $SQLSession = Win32::OLE->new("SQLOLE.SQLServer"
The documentation I have from Microsoft maintains that the
"SQLDMO.SQLServer" connection has to be used for SQL Server 7. When I use the "SQLOLE.SQLServer" with SQL Server 7, it will connect, but after that, doesn't seem to be able to return the objects that the program needs. I think I simply need to get the connection to engage. One thing that I did do was successfully register the sqldmo.dll file on the server, but I still couldn't connect with "SQLDMO.SQLServer".
Please help!!!