redbaron082997
asked on
SQL-DMO,SQLOLE Ex. needed
I need an example of how to use SQL-DMO in a VB5 project. I have not been able to use either one properly. Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I think the problem is that I do not have the proper DLL's or something with the setup of it. I have the following files
C:\mssql\binn\sqlole65.dll ;c:\mssql\ binn\sqlol e65.tlb
The reference points to the *.tlb file. When I step throught the following commands
Dim oSQLServer As New SQLOLE.SQLServer
oSQLServer.Disconnect
I get the error, ACTiveX can't create object
C:\mssql\binn\sqlole65.dll
The reference points to the *.tlb file. When I step throught the following commands
Dim oSQLServer As New SQLOLE.SQLServer
oSQLServer.Disconnect
I get the error, ACTiveX can't create object
A straight forward problem.
1. Ensure Reference to the SQLOLE65.tlb is checked in the referneces list in VB.
2. Check SQLOLE object appears using object browser!
All should then be OK
1. Ensure Reference to the SQLOLE65.tlb is checked in the referneces list in VB.
2. Check SQLOLE object appears using object browser!
All should then be OK
ASKER
AndyJ: -> Thanks.
ASKER
redbaron@flash.net
Thanks
Ronnie