Setting Up MSDE 2000 Release A On Windows XP Professional
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:
View Replies
ADVERTISEMENT
I persist the login info using cookies so that a user doesn't have to login every time they come to our website, unless they previously logged out. Everything works OK on W98 SE, and Windows XP Pro machines.
On a W2K machine, IE6.0.2800.1106 SP1, the following function won't delete cookies, or deletes them but they're mysterioulsy re-created when the web page is subsequently referenced. Therefore, a web user can't logout.
// ============================================
// remove login cookies
// ============================================
function KillLoginCookies ( )
{
Response.Cookies ( sCookieCustomerID ) = '';
Response.Cookies ( sCookieCustomerID ).Expires = '01/01/1980';
Response.Cookies ( sCookiePassword ) = '';
Response.Cookies ( sCookiePassword ).Expires = '01/01/1980';
}
What am I missing here?
View Replies
View Related
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.
View Replies
View Related
I have a simple .asp page with a text field and submit
button. When it runs on a Win 2000 Professional + IE6
client machine, and the .asp page is set "anonymous
access" only on IIS, the contents I entered to the text
field did not get submitted when I click the submit
button. If the setting is "Integrated Windows
Authentication" everything is fine. Has anyone had
experienced this problem?
View Replies
View Related
I recently had to reinstall windows 2000 professional due to a harddrive
crash, I downloaded all the newest updates, now I find that session
variables are not being kept from page to page as it had with older
software.
If any else had this problem with IIs 5.0, frontpage 2002 server
extentions I would appreciate a tip. What I have found out so far is that
the session variables used with asp 3.0 are going away in favor of dot.net
asp...
This is a repost from another group, the server appears to be
configured correctly, and the application still works fine on the server it
is published on, the problem appears to be only on my development machine
after installing the sp4 update for windows 2000 Professional.
View Replies
View Related
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?
View Replies
View Related
Our current websites are hosted on Win2K Servers using classic ASP and IIS
5.0. We will be acquiring a 3rd party website that is written in ASP.NET.
Hate to sound stupid, but is it possible to run ASP.NET on Win2K or does it
need to be run under Win2003?
View Replies
View Related
Overnight my work PC has been upgraded - I'm re-installing all my software, and PWS does not work
It may be that it's a permissions thing (I need to get this sorted, as it is stopping me from installing a few things) However, I also suspect that PWS for NT is no longer any good for W2K Is there a new version for W2K?
View Replies
View Related
I will be traveling and I will need to show someone a
secure folder in an IIS website and I will be on a public
computer. When we are done, I will need to be able to log
off so no one else using that computer will find
their way into that part of the website. The security is
Windows authentitication using Clear Text.
Can ASP log me off. If so I will need to code this before
I leave. Can anyone point me to where I can get some
examples of code to do this ?
View Replies
View Related
I've searched several articles about this and cannot get any suggestions to work. My IIS on Windows 2000 Server won't run ASP pages like default.asp. I've tried reinstalling IIS, syncing the passwords for IUSR....etc.
View Replies
View Related
Will CDO work under Windows Server 2000? I'm guessing it will. The problem is that I wrote a nice little ASP app under Windows Server 2003 which works REALLY well. Sends out the email with NO problem. 'Course, it uses an external SMTP server, but I'm assuming this shouldn't matter, right?.
Because when I port it over to Windows Server 2000, it blows right past it. Is there a particular setup procedure that needs to be done for Windows Server 2000 to enable CDO to work properly?
View Replies
View Related
I installed SP4 for Windows 2000.
Prior to the upgrade my system was at SP3 and I was able to run ASP
scripts from my browser just fine. For exmaple: Code:
View Replies
View Related
I've recently installed an asp component called smartupload, it works very well. The problems start when a mac user uploads a jpg or gif, windows will not open the file.it works fine with a windows user.
View Replies
View Related
I'm trying to connect to a SQL 2000 database on my Windows 2003 x64 Enterprise edition server, and so far I've got the error:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager] Data source name not
found and no default driver specified
My ASP code is straight forward: Code:
View Replies
View Related
how to set up ASP development environment in windows XP (or i have to have windows 2000/2003)? Any good tutorial out there? By the way, I already have Visual Studio .net installed in my computer.
I am a PHP developer and want to learn ASP for my new project. How long u think it will take for me to catch up?
View Replies
View Related
I'm using formmail.asp which is an emailing utility. Basically, the user
fills out a request page, clicks "Submit" and the page posts to formmail.asp
which emails the user information.
I'm running IIS5 on a Win2k server box and recently ran the Windows Updates
(the last time I do that). Anyway, that emailing form doesn't work now on
any of the sites I host. Any ideas?
View Replies
View Related
I have been using the CDONTS.Newmail object for a number of years to send
nicely formatted HTML Emails with inline images.
I am now trying to switch over to using CDO and I cannot reproduce this
functionality. I am using the AddAttachment method instead of the old
AttachURL method but the attached images just show as separately attached
files rather than in line in the HTML.
According to MSDN:
"If you populate the HTMLBody property before calling the AddAttachment
method, any inline images are displayed as part of the message."
Well, I am doing that but it is not working. The images show up as if I had
attached them using the old AttachFile method.
Code follows....
View Replies
View Related
I use vb create a DLL compoment(SessionManger.dll) which is used in ASP page.
in ASP page(test.asp) code:
<%@ Language=VBScript %>
<%response.buffer = true%>
<%
dim Session
set Session = server.CreateObject("SessionMgr.Session2")
Session("UserName")="gc"
......
Set Session=Nothing
%>
In IE, when launch test.asp ,and after a while close it, I founld SessionManger.dll file is still being in the memory, and have to restart IIS.
View Replies
View Related
am just wondering is there a easier way to release all the memory after the program is done?or do I need to set all my variable = nothing one by one at the end of my code?
View Replies
View Related
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?
View Replies
View Related
How can I do an MD5 in ASP ? I tried doing it through the SQL but it didnt seem to work
Anyone ?
View Replies
View Related
I am planning to design a database (destined for the web) that will have
between 20000 and 45000 records in it and will receive a lot of reads but
very very few writes (just from me).
Now the question is should I use:
1) The combination of Access 2000 (accessible through ASP or ASP.NET) using
OLEDB Jet
or
2) SQL Server 2000 ?
Of course I know that the SQL Server option is a better one, especially
since it's said that an Access DB can have about 9 users or so accessing it
at the same time. But is that a general rule or is it about many people
writing to the DB? In other words, if an Access DB has hardly any writes
and 99.9% reads can it be used as efficiently as it would be used on SQL
Server 2000?
View Replies
View Related
How can I made time released ASP code? I want to make section of code viewable after a certain date. Something to this effect, but this does not work right:
if now() >= "6/24/2005" then
Response.Write ( "here is my new html" )
else
Response.Write ( "for now just show the current information" )
end if
View Replies
View Related
i am facing the following error when i am going to access the msaccess97 database through ASP in XP.
The Microsoft Jet database engine cannot open the file 'c:exams.mdb'. It is already opened exclusively by another user, or you need permission to view its data.
but there is no readonly attribute is unset in the database file. what can i do?
View Replies
View Related
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?
View Replies
View Related
I am pretty new to asp.net, and have recently taken over a project. I have
gotten to the point where I am about to release my changes, but for some
reason when i build the project in release mode and launch in in IE I always
get a "The Page cannot be displayed" page instead of my login form.
Anyone have any ideas? The applciation works fine in debug mode, its just in
release mode that this happens.
View Replies
View Related
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.
View Replies
View Related
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"
View Replies
View Related
I'm developing a web site with email capabilities: I have tried the free version of Jmail, now I need Jmail Professional but still don't want to buy it before having the chance to try it....
View Replies
View Related
Where can I find information about "most valuable professional"?
How do you get the MVP title??
I've heard that it's a pretty lucerative title ;)
View Replies
View Related
We have an webservice application that has a memory leak when the application
is compiled release mode. However, when the application is compiled in debug
mode it does not exhibit a memory leak.
We are running .net 1.1 compiled with VS 2003.
The application does reference an unmanaged dll that provides security
functionality. This dll is instantiated once and referenced on every web
service call.
View Replies
View Related
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
View Replies
View Related
I have one 3 tier architecture application running on Windows 2000 Server.
I have created replica of same machine on another machine where OS is
Windows 2000 Advance Server.
But when I port same running application on new machine i.e. Machine with OS
as Windows 2000 Advance Server, my middle tier (Active-X Dll, COM+
application) fails.
It throws common error
Invalid Procedure Call or argument
What could be the problem? Do I need to change any settings for running
application on Windows 2000 advance Server.
View Replies
View Related
