I figured it out. There's a flaw in the example provided by Microsoft which is addressed in an MSDN problem Article. The msgwaitformultipleobjects() line needs to be adjusted to look like this (note the final parameter):
ret = MsgWaitForMultipleObjects(1&, Proc.hProcess, 0&, INFINITE...
I am using the VB6 Setup Toolkit to write an install procedure to install MSDE and attach a database. I've got the MSDE launching, but then it hangs and after I've waited long enough to be convinced it's really stuck (I know MSDEx86 takes a good long while to install), the Task Manager shows...
Okay, you weren't so far off after all. It turns out that SQL Server logs in as the System Account by default, which typically does not have any printers assigned to it. In one case I assigned printers to the system account and in the other I changed SQL Server to log in to my user ID. Both...
Answered my own question. It seems SQL Server, by default, logs in to the System account which, by default, has no printers assigned to it. Two options for repair - reset the SQL server service to log into some other account OR adjust the registry to assign the necessary printers to the System...
Unfortunately these do not seem to be the issue as I can switch directly from the SQL trigger call to a VB executable that does nothing but call this .dll and it will function properly.
Furthermore, if I am running the .dll from Visual studio and call it from SQL Server it will function...
I've also posted this question in the SQL Server forum.
I have a vb .dll that prints a label based on properties set by the calling program. I can call the .dll succesfully from a VB Executable, but when I call it from SQL Server (msde 1.0) I get a '482 Printer Error'. This happens whether I...
This may be a VB question, but it only happens when called from sqlServer(MSDE) , so I'll post it in both places.
Using the sp_aocreate and sp_oamethod objects I am succesfully calling an ActiveX .dll written in VB. Whenever I call it from sqlServer, though, I get an error returned ('482...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.