June 4, 2012 at 1:54 am
Hi everyone,
I am working to migrate SQL Server 2000 databases to SQL Server 2008 R2. I restored all the databases in new server and after testing the basic functionality, I believed my VB 6 Application was working fine. But later on, I discovered that the application depends on some extended stored procedures of Master databases.
I created those extended stored procedures in new Master database by simply copying the associated dll file to 2008 server. While running the extended stored procedure I encountered the following error.
Msg 17750, Level 16, State 0, Procedure mqsxsp_send, Line 1
Could not load the DLL C:\Program Files (x86)\Microsoft SQL Server\80\Tools\Binn\mqsxsp.dll, or one of the DLLs it references. Reason: 193(%1 is not a valid Win32 application.).
Msg 17750, Level 16, State 0, Procedure mqsxsp_send, Line 1
Could not load the DLL C:\Program Files (x86)\Microsoft SQL Server\80\Tools\Binn\mqsxsp.dll, or one of the DLLs it references. Reason: 193(%1 is not a valid Win32 application.).
After I got this error message what I thought is the registration of dll. I am aware that these dll are 32 bit and I am running 64 system. So I tried to register using 32 bit version of regsvr32 from c:\windows\SysWoW64. The registration was not successful, it returned the error
The module "c:Program..." failed to load.
Make Sure that the binary is stored at the specified path or debug it to check for with the binary or dependent .dll files. The specified module could not be found.
I am stuck in this problem since last week. Any ideas and help will be highly appreciated.
Thanking you in advance.
B Raj Dhakal
June 4, 2012 at 8:52 am
Make sure your command prompt is "running as an administrator". You can right click a command prompt shortcut and select "Run as Administrator". I ran into this issue when first moving to Win7 64bit and this worked for me. 🙂
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
June 4, 2012 at 8:09 pm
Yes, I did. I tried with run as Administrator as well. Thanks any-ways, for your comment.
B Raj Dhakal
June 5, 2012 at 8:01 am
I googled that error message and there are tons and tons of people with different solutions to this issue. It seems there is an answer out there that will help your situation.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
June 6, 2012 at 10:27 pm
Thanks Sean.
The problem was something different but fortunately I nailed it. The extended stored procedure actually tries to communicate with Message Queue Server which has been upgraded to Message queuing in 2008.
I am looking for a producer code to communicate with Message queuing.
B Raj Dhakal
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply