Cannot load the DLL xpweb70.dll

when i make queries it's giving this error Cannot load the DLL xpweb70.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.). pls help me out thanx in advanceWhich version of the SQL Server do you have? Try to install latest SP in a case if it is SQL 2000|||

sql server 2000, but i installed service pack 4 , still the error coming, is there any patch for this

Cannot get "LIKE" to Work in My Query

Excel 2003. SQL Server 2000. I have an Excel module that grabs some data
from an SQL database using an ADODB connection. If I use the following in
the SQL query, it returns no data:
(WHERE INVOICENUMBER LIKE 'MS*')
However, if I use the following, I get all the data I expect:
(WHERE INVOICENUMBER>='MS' AND INVOICENUMBER<='MS9999999999999')
What am I doing wrong? How may I properly use the LIKE phrase? Thanks for
any help.
--
Dr. Doug Pruiett
Good News Jail & Prison Ministry
www.goodnewsjail.orgUse % instead of *.
"Chaplain Doug" <ChaplainDoug@.discussions.microsoft.com> wrote in message
news:2433FFE0-85C8-419F-9EB8-2C3302E5058B@.microsoft.com...
> Excel 2003. SQL Server 2000. I have an Excel module that grabs some data
> from an SQL database using an ADODB connection. If I use the following in
> the SQL query, it returns no data:
> (WHERE INVOICENUMBER LIKE 'MS*')
> However, if I use the following, I get all the data I expect:
> (WHERE INVOICENUMBER>='MS' AND INVOICENUMBER<='MS9999999999999')
> What am I doing wrong? How may I properly use the LIKE phrase? Thanks
for
> any help.
> --
> Dr. Doug Pruiett
> Good News Jail & Prison Ministry
> www.goodnewsjail.org|||in SQL, the wildcard character is % not *. Single character wildcard is _
instead of ?
"Chaplain Doug" <ChaplainDoug@.discussions.microsoft.com> wrote in message
news:2433FFE0-85C8-419F-9EB8-2C3302E5058B@.microsoft.com...
> Excel 2003. SQL Server 2000. I have an Excel module that grabs some data
> from an SQL database using an ADODB connection. If I use the following in
> the SQL query, it returns no data:
> (WHERE INVOICENUMBER LIKE 'MS*')
> However, if I use the following, I get all the data I expect:
> (WHERE INVOICENUMBER>='MS' AND INVOICENUMBER<='MS9999999999999')
> What am I doing wrong? How may I properly use the LIKE phrase? Thanks
> for
> any help.
> --
> Dr. Doug Pruiett
> Good News Jail & Prison Ministry
> www.goodnewsjail.org

Cannot find module in web data administrator

I just downloaded the web data administrator from MSDN and after entering my credential, I get this error:

Specified module cannot be found
at SqlAdmin.SqlServer.Connect()
at SqlWebAdmin.databases.Page_Load(Object sender, EventArgs e)
at System.Web.UI.Control.OnLoad(EventArgs e)
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Page.ProcessRequestMain()

The only page I can see is the Import page, the database and the export get the same error.
It's a fresh install, anyone know something I need to do to get a correct install ?Since I had not yet downloaded and installed the Web Data Administrator, I went just now and installed it from Microsoftlink

I just clicked on Download, chose "Open" and just left whatever defaults there might have been. I went into SQL Server and changed the authentication mode to mixed. Then I went to http://localhost/sqlwebadmin/default.aspx and logged in with my sa login and password. It all worked like a charm.

Not sure what help any of that is...

Terri|||I tried doing another clean install, but I get the same problem.

I can login just fine, but after leaving default.aspx, I get the error in the 2 other pages.

Without better error description I fear I won't be able to find the bug in all this code, more so if it work on other machines.

Here is the code of the Connect Method from where the error seem to be coming:

 dmoServer = (NativeMethods.ISqlServer)new NativeMethods.SqlServer();
 dmoServer.Connect(Name, Username, Password);

I have no idea what's this NativeMethods thing is coming from. I'm using MSDE, could that be the problem ?