December 22, 2009 at 2:00 pm
Hello,
I'm trying to get an application that works fine against sql 2000 and sql 2005 using SQL-DMO on SQL 2008.
Now from searching the web, i'm aware of the MS SQL Server 2008 Feature Pack that includes "Microsoft SQL Server 2005 Backward Compatibility Components".
As is, I installed the Backwards Compatibility pack to the sql server 2008 machine, and tried running the app. The app Fails when i attempt to use the objects.
So i figured, maybe i need to recompile my application with the new references of DMO that the pack installs. We'll i've done that... tried running the app, but it still fails.
Can anyone confirm that the Pack installs the needed dmo dll to the 80 directory? i was a bit confused as to where the newly laid files would go... only reference on my machine, was to the original sqldmo.dll location that was under a sql 2000 directory i had on my machine. Maybe it's not the right reference? but i can't find anywhere else that file, sqldmo.dll resides.
The error i get back is, "-2147165949 To connect to this server you must use SQL Server management Studio or SQL Server Management Objects (SMO)" no kidding ... but i thought pack above allowed the DMO connection.
Anyone know what else there is to do to get this working? I should expect this to work right?
Thanks for any help provided,
Thierry
December 22, 2009 at 2:10 pm
Sometimes you will need to manually register sqldmo.dll in C:\Program Files\Microsoft SQL Server\80\Tools\Binn\sqldmo.dll using regsvr32. For example, if you get the Server.CreateObject Failed message, you will need to register that dll manually. In asp web page application, you will get the message below:
Server object error ‘ASP 0177 : 8002801d’
Server.CreateObject Failed
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 22, 2009 at 2:11 pm
As a side-note, it is recommended to upgrade to SMO. Though the Backward compatibility pack exists, it is not guaranteed to be included as an option with future releases of SQL Server.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 22, 2009 at 2:26 pm
thanks.. aware of SMO but just not getting into that now...
the create object isn't the error i'm getting .. but i'll try this anyway.
But i presume you are confirming that the sqldmo.dll file does get placed... the 80 path... what if i didn't have 2000 in the first place... would it still get created there? just wondering...
December 22, 2009 at 2:38 pm
tbrun (12/22/2009)
thanks.. aware of SMO but just not getting into that now...the create object isn't the error i'm getting .. but i'll try this anyway.
But i presume you are confirming that the sqldmo.dll file does get placed... the 80 path... what if i didn't have 2000 in the first place... would it still get created there? just wondering...
Not sure if 2000 tools are not installed. If you can find the sqldmo.dll somewhere else on the system, you may be able to register it from that location.
I figured the two were different issues - but similar in nature so this may be worth the shot.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 22, 2009 at 4:02 pm
ya... looks like it will always place it into the 80 path.
December 22, 2009 at 4:06 pm
Good - thanks for the follow-up
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy