Error Installing MSDE
As i try to install MSDE (Microsoft SQL Server Desktop Engine), i get this error message :
"A strong SA password is required for security reasons.
Please use SAPWD switch to suply the same. Setup will now exit"
As i try to install MSDE (Microsoft SQL Server Desktop Engine), i get this error message :
"A strong SA password is required for security reasons.
Please use SAPWD switch to suply the same. Setup will now exit"
Error while instantiating this component in ASP page.
<%
Dim oDms
oDms = Server.CreateObject("DmsMod.Document3")
Set oDms = Nothing
%>
The dll is registered using regsvr32. I think it is registered correctly because, I can use this dll perfectly in a VB6 application by adding to the references.
IUSR_MyMachineName and IWAM_MyMachineName also have Read & Execute
permission on the System32 folder (System32 folder is housing the dll).
need to go to MySQL.com and download some sort of drivers first, right?
now, besides just clicking "OKAY" is there anything else
I need to do? Also how exactly do I implement a connection and
run a query once I get the drivers installed? etc.
Also, a dumb question but I feel I must ask it... how do I back
up a "Microsoft SQL Server Desktop Engine"?? I want to use MSDE
since its free and works just like MSSQL, however a program I use
for my schoolwork (Well, at least math/history) uses it.
I'd really like to back it up before trying MSDE; on the same note,
how do I actually work with MSDE? To prevent it from overwritting
the one?
How can I do an MD5 in ASP ? I tried doing it through the SQL but it didnt seem to work
Anyone ?
I've been given a website that originally had a database that was running on SQL Server 2000. The database has recently been changed into an MSDE database and put on our new server. However, I am having problems accessing the new MSDE database.
I keep getting the following error:
"Microsoft OLE DB Provider for ODBC Drivers error '80040e4d'
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'WXGMEDIAIUSR_WXGMEDIA'.
/2roost/asp/db.asa, line 89"
Does the connecting string/settings change when trying to access an MSDE database?
I am trying to connect to a MSDE 2000 database located on a server on my network. I can connect to a SQL Server 2000 database; however, I cannot connect to this MSDE database.
This is the error I get: Code:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.
/attach2.asp, line 28
Here is my connection string: Code:
<%
Set conn2 = Server.CreateObject("ADODB.Connection")
conn2.Open "Driver={SQL Server};" & _
"Server=192.168.56.181;" & _
"Database=Attachments721;" & _
"Uid=attach12usr;" & _
"Pwd=***;"
%>
What am I doing wrong? I can't figure it out. The ASP page and the MSDE are on two different servers, if that makes any difference. I can add the MSDE server to Enterprise Manger using the same login information too.
I have iis, .net and MSDE installed on my machine, I have also installed "web data admin" but i cant log into it. The green blinking arrow for the server is in the bottom of my window so it appears that MSDE is ok.I am entering the following info at the w.d.a login screen
usrnm: sa
pwd: mypassword
server: production
etsdk
however i get this message returned:
Invalid username and/or password, or server does not exist.
Also, please ensure that SQL Server Authentication is enabled on the server.I dont know What have i done wrong/ missed.
Using MSDE database & ASP file through IIS, both are in separate systems. Database is not connecting from IIS-ASP file.
Given error as "[DBNETLIB][ConnectionOpen (Connect()).]Specified SQL server not found", Using Provider=SQLOLEDB.1 But VB code is connecting using same provider
I recently downloaded and installed (hopefully correctly) MSDE 2000 Release
A. I previously, and still do, have the version of IIS that comes with XP
Professional installed on my computer. I wanted MSDE 2000 Release A so that
I could do database access using ASP from my websites, which are on my
computer. When I went to my first test website, I recieved the following
error:
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC SQL Server Driver]Neither DSN nor SERVER keyword supplied
/testDB.asp, line 26
The ASP code that I used on my web to connect to the database (which is
currently just an empty text file) is the following: Code:
I've recently developed a niche price comparison site and one of the merchants that I spider wants me to write a script that runs on their server and connects to their database to dump out all active products.
This has the advantage of saving their bandwidth and allowing me to update my site daily instead of every few days.
Trouble is that they use ASP and I use PHP/MySQL. I've done a bit of digging around it looks like XP Pro will allow me to install ASP but I'm not sure about my database options.
If I use Access as my backend here, will the settings be easy to transfer across to SQL server ?
Anyone know of any simple tutorials to install and configure ASP and a suitable database backend ?
I'm having a issue with one box where it will not serve any ASP pages,even when i browse them from the IIS manager directly.Is there something I should look at to 'enable' serving asp pages?
View Replies View RelatedFor some reason I can't make asp scripts work in IIS 6.0. No error returns, scripts are just not being processed. That is, when I create test.htm with the following code:
Code:
<html>
<body>
<%
response.write("Hello!")
%>
</body>
</html>
I see an empty page in internet explorer and the complete code in the source of the page.
I allowed active server pages in the Web Service Extensions and restarted IIS, but still asp won't work.
I am confusing to use IIS and Win OS. I learn that Win 2000 goes with IIS 5, how about Win XP? Also, the ways to configure (i.e., installing IIS, virtual directory, ODBC...) are changed from the previous version to the newer version. Can you please show me how to configure these stuff on Win XP. I have tried those books that are old now and still not able to get it through.
View Replies View RelatedI want to install IIS 5.1 on my WindowsXP machine. I do not have my WinXP CD. Does anyone know where I can download the necessary software to complete this installation?
Also, I would like to update a webpage that is built with either asp or asp.net. (I did not make this webpage, and am new to both asp and .net) Is there a simple way to find out which was used to create this website?
How can I set up an install package to offer the SA to choose the install folder? I am using VS to create a MSI install file.
View Replies View RelatedI have installed apache on my computer to test php scripts. What do I now need to do to also run asp scripts? Do I have to install apache::asp or can I load a module that runs with my current apache?
View Replies View RelatedDoes anybody have an experience of installing and running PHP alongside with ASP on wk2/IIS5 ?
View Replies View RelatedI have been developing in PHP for some time now on Win XP Pro but wish to get into ASP and then onto ASP.NET. Couple of quick questions to ask if thats ok.
1) Should I jump over ASP and straight into ASP.NET or should I learn the middle ground as well for compatibility with scripts out there?
2) How do I installed IIS/ASP on Win XP Pro without it clashing with Apache/PHP/MySQL. I know you use the XP CD and install IIS but I thought that would take control of localhost and block access to apache. Can you disable IIS when your not using it ?
I'm trying to install code written by Lewis Morton to upload files (in particular jpgs) on my web hosting account. Has anyone attempted to do this with Morton's code?
What I have now, I can do an upload, with no error messages, but no file is stored. I'm getting the file name, and Server.Mappath is creating the path, but nothing is being stored.
I am interested in installing Visual Studio .Net in my XP-Pro OS. I tried once before and it hosed my IIS installation and could not even run it until I removed VS.NET and re-installing IIS.
Is there anything I need to install in my OS before trying again. I am pretty sure that it has all the OS updates.
I have used this type of VBSCRIPT code on an ASP page for several years to launch a program on a server from an ASP page:
Dim sh
set sh = Server.CreateObject("WScript.Shell")
sh.Run("any-program.exe", 0 , TRUE)
The code breaks when I installed Internet Explorer 7 (IE7) on a Windows 2003 Server. The error is "permission denied". The error goes away when I uninstall IE7. Have you run into this problem? Do you have a solution that is better than uninstalling IE7?
anyways, after i installed IIS (i'm running XP SP2) everything seemed to go good, until i tested ASP, i get a 500 error / page cannot be displayed.
but this is the real error
-2147467259 (0x80004005)
i have no idea what this means, and i did a bit of a search on google on this, but i didn't find anything helpful - so i ran a search for asp forums and this came up - so here i am.
in case you want to know, my web server is running (i CAN see html files via the localhost url) but asp just won't go (i'm trying to view the default asp file) and i have no idea what's wrong (i DID restart my PC, and all services that might be related to anything internet are turned ON)
I've just installed web data Administrator and did everything instructed from the book, but when I opened the browser and typed http://localhost/SqlWebAdmin I get a web page but no input fields or place to type in the password. I'm running xp pro, IIS is running, MSDE is also running and I have SqlWebAdmin folder in the C:Inetpubwwwroot folder.
View Replies View RelatedI'm trying to install the Devices Update 4.0 but it failes every time with the error
"Application has generated an exception that could not be handled." Does anybody has any idea where I could find what's going wrong, or who I have to contact for support on Devices Update at Microsoft? As Devices Update is a free download.
I have a computer where I installed windows xp professional. However, during installation, I did not choose the IIS server component. Now, I need to install the IIS Server.
At the moment, I am not carrying the windows xp CD. Is there any IIS server download for xp available in the web so that I can get a local web server up and running real quick?
I plan to allow users to upload jpegs using the <input type="file">
I understand one needs to install an ASP componenet on the server to handle the upload.
I have an installation executable from CBUupload that is freeware, which apparently can do the job. Also there are a number of options I can purchase. Has anyone any experience with installing these components on a host site?
I've got a Windows 2000 server SP4 running IIS 5.0 I've just installed Microsoft Terminal Services v5.0 in administrator mode and now IIS won't process ASP pages (terminal services works OK).
When Terminal Servcies are uninstalled ASP pages work fine again. The following are the errors that are occuring when Terminal Servceis is installed. Code:
Microsoft has a service called SUS that allows operating
system files to be updated from a dedicated server
instead of from Windows Update(Microsoft). SUS is a web
app based on .asp. I went ahead and installed SUS on a
Windows 2000 server that already had IIS 5.0 on it.
After the installation of SUS I tried to browse to the
home page,ie: http://localhost/SusAdmin, and got the
error "page not found".
I was able to browse normal html files in the same SUS
virtual directory in IIS and see them with no problem.
Something is wrong with .asp on IIS or with the setup of
SUS.
I got an error saying
Microsoft VBScript runtime error- Error '800a000d'
Type mismatch
/briansforums/default.asp, line 923
also another error called Code:
# Error Type:
Server object, ASP 0177 (0x800401F3)
Invalid ProgID. For additional information specific to this message please visit the Microsoft Online Support site located at: http://www.microsoft.com/contentredirect.asp.
/CoxAxis/adminEditPage.asp, line 6
My code:
<%
dim self, pid, i, c
self = Request.ServerVariables("URL")
pid = Request.Querystring("pid")
set Session("pageContent") = Server.CreateObject("Scripting.Dictionary")
Set custObj = Server.CreateObject("NFIFunctions.ValidateField") Line 6
set psi = Session("pageContent")
set errDict = Server.CreateObject("Scripting.Dictionary")
i = 1
i'm getting
Provider error '80004005' Unspecified error
admin/dbconnection.inc, line 4
what this is, it only started happening after i did a recent upload of my database!, i 've tryed uploading it again but the error still appears.
Let me start by saying I'm fairly new to Asp coding. That said...
My ISP only uses AspSmartMail. I've created an online form that uses fill out, which is then e-mailed to the collector of the information and CC-ed to the person who submitted the information.
The error I'm receiving is this:
aspSmartMail.SendMail : Error 28 error '8004001a'
504 Invalid Username or Password
In my script, I've Dimensioned several items, as you'll see below, passing the authenticating username/password to the smtp server, but it's not working. I tried not passing the information by entering in the actual info without it being passed by the diminsioned items. This didn't work either. I of course verified that the username/password I'm usine is correct.
Can someone plase tell me why I can't authenicate? I would really appreciate any help that might be out there.
Relavant Asp code below:
-----------------------------------------
Dim smtpserver,youremail,yourpassword,yourusername,rem oteemail
'Edit these 3 values accordingly
smtpserver = "mail.smtp_server.org"
youremail = "yourname@smtp_server.org"
yourpassword = "password"
yourusername = "yourusername"
remoteemail = "email_address_to_send_to"
Dim ObjSendMail
Set ObjSendMail = Server.CreateObject("AspSmartMail.SmartMail")
'Config remote SMTP server info.
ObjSendMail.Server = smtpserver
ObjSendMail.ServerTimeOut = 35
ObjSendMail.SenderAddress = youremail
ObjSendMail.Password = yourpassword
ObjSendMail.Username = yourusername
'End remote SMTP server config.
'Config E-mail.
ObjSendMail.Recipients.Add remoteemail
ObjSendMail.CCs.Add Request.Form("Confirm_Email")
ObjSendMail.Subject = "Email Subject"
ObjSendMail.SenderAddress = "Confirmation-NoReply@smtp_server.org"
ObjSendMail.SenderName = "SenderName"
ObjSendMail.ContentType = "text/html"
ObjSendMail.Body = strBody
'Note - strBody is Dimensioned elsewhere in my script to build the HTML message body.
'End Config E-mail.
'ObjSendMail.Send
ObjSendMail.SendMail
if err.number <> 0 then
response.write("Error n° " & err.number - vbobjecterror & " = " & err.description & "<br>")
else
Response.Write "aspSmartMail has sent your message with this file as attachment : <br>"
'Response.Write ObjSendMail.Attachments.Item(1).FilePathName
end if
Set ObjSendMail = Nothing
---------------------------------------
End code
i m getting this following error:
Compiler Error Message: BC30002: Type 'ODBCConnection' is not defined.
Following is my code: ...