Connecting To SQL 2000 Database In Windows 2003 X64
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 Complete Forum Thread with Replies
Related Forum Messages:
ASP.NET On Windows 2000
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 !
PWS On Windows 2000
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 !
Logging Off Windows 2000 From IIS
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 !
IIS Windows 2000 Not Loading
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 !
ASP Error Under Windows 2003
Is html based form for upload files. ASP script are get and save files on web server. Works fine on Windows 2000 Server. Under Windows 2003, if try to upload files more than 100Kb got error: Error number: -2147467259 Error source: Error description: Operation not Allowed in next line: Binary = Request.BinaryRead (Length) Any idea why it happen?
View Replies !
Add IP's Manually To Windows 2003 Web?
How do I add additional IP's manually in Windows 2003 Web Edition? I was told to add them to subnet mask? I am not sure about this as I am new to it. Also, in remote desktop connection perhaps? Where after I login?
View Replies !
ASP On Windows 2003 Server
I made some of the web pages using ASP on windows 2000 server, now i wanto to upgrade my Operating system from windows 2000 server to Windows 2003 Server , Are my web pages will work fine if i do this upgradation or there are any configurations on IIS i have to make to work fine ....
View Replies !
Website On Windows 2003
some of my sites which is working perfectly on Windows 2000 But when i tried the same thing from Windows 2003, it gives me error.. I am using IIS 6.0 By the way i am getting an error 80005000 login error.
View Replies !
Migration To Windows 2003
I recently upgraded my servers to 2003. Since then the error-information shown in the browser has changed.For example, if under Windows 2000 I executed an SQL statement from within an ASP, and the SQL statement was syntactically incorrect, the error thrown by ADO would finally show up in the client browser. If I do the same with an Windows 2003 Server, only a "HTTP 500, internal server error" is sent to to client browser. The IIS LogFiles still show the actual error, but looking there is not that comfortable.Is this some configuration that can be done on the Windows 2003 server?
View Replies !
Windows 2003 Server With II6
I've had a new server installed for me. with Windows 2003 and II6 with ASP.NET. but I want to run a small (but important) application written in ASP(all .ASP files) as it stands the server will not 'understand' .ASP files (only .ASPx)To avoid having to modify the whole application ( :-} ) can I get the server to execute. ASP files?(is it as simple as copying over an existing II4 ASP.DLL and installing that?
View Replies !
Windows 2003 Web Edition
Is there a workaround to allow .log files to be accessed Like: http://127.0.0.1/Test.log The access is just so it can be downloaded. I get 404 errors for Windows 2003 but not for Windows 2000 for this.
View Replies !
Windows 2003 Server
We have several extensive sites and all use a lot of include files. We have the coded as include file and virtual include using ../ since it is a shared server etc. The sites were moved by the hosting company to a new windows 2003 server and now we get invalid path error part of the time, others it works fine. The host says it is our programmers did not follow asp procedures and used ../ I always thought this was ok, it was never an issue before the move...is this new to windows 2003.
View Replies !
Authentication Against AD On Windows 2003
I used to have the following ASP code (below) that runs on windows 2000 and authenticates users against the Active Directory. The code is working fine. However, after upgrading from Win2000 to Win2003 (IIS 6), authentication is failing, although the code is still working if run on win2000. I tried to capture packets during the authentication phase from both win2000 and win2003 and I found out that there is a slight difference between the two although I believe that this is an OS bit not ASP thing. Code:
View Replies !
Windows Server 2000 Question...
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 !
Mac To Windows 2000 File Uploads
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 !
CDONTS And Windows Server 2003 / IIS 6
I just set up an acct. with godaddy for a shared virtual dedicated server using Windows 2003 and IIS 6. None of my ASP scripts work to send emails using CDONTS. Research took me to how to install the cdonts.dll file and after doing so I don't get the error about not being able to create an ojbect but rather that of permissions on the line that has the .send. Other research led to me believe that windows 2003 does not support cdonts at all? I'd prefer to use CDO but I was told by Godaddy that the script below is not supported on a shared server - Code:
View Replies !
Error With CDONTS On Windows 2003
I have a very rare error with one of our Windows 2003 server. We have some componentes COM wich ones use the CDONTS in order to send mails. Well, one of our server get the follow error when we try to send the mail. error '80004005' Method '~' of object '~' failed I know it's possible to have CDONTS over Windows 2003, and this article confirms it: http://www.microsoft.com/resources/documentation/WindowsServ/2003/all/deployguide/en-us/Default.asp?url=/resources/documentation/WindowsServ/2003/all/deployguide/en-us/iisdg_dep_tnoc.asp I have registered the cdonts.dll as the article dictates but I really don't know what can be happening with that server.. and I really appreciate any kind of help because that is one of our QA servers.
View Replies !
CDONTS On WINDOWS 2003 Server
Some one has posted this question on 10th August, as CDONTS is not working on windows 2003 serever. I have the same problem and I copied CDONTS.DLL from Windows 2000 Server and registered on Win 2003 server but it giving the error on line when I calling method send of the object. Error is Microsoft VBScript runtime error '800a0046' Permission denied I tried to register CDONTS as COM+ with Admin user right to execute but it still giving same error.
View Replies !
ASP On IIS6 Windows 2003 Server
At the early testing stages of writing some simple ASP scripts hosted by my Windows 2003 Server but I have hit upon a problem. When I open an asp page, IE just returns the script rather than expected web page. What have I or am I doing wrong?
View Replies !
ASP Problem In Windows 2003 Server
In Windows 2003 Server, when I include a file in upper directory, it will occur error. Active Server Pages Error 'ASP 0131' cannot include file '../filename.inc' with '..' from upper directory However, it doesn't have any problem in windows 2000 server could anybody help me?
View Replies !
Cdosys With Windows 2003 Error
I'm using windows 2003 with asp. However, I'm having problems sending email using the cdosys object. My code is below and I don't believe its the code but on the send command. <% dim sch dim cdoConfig dim cdoMessage sch = "http://schemas.microsoft.com/cdo/configuration/" Set cdoConfig = Server.CreateObject("CDO.Configuration") cdoConfig.Fields.Item(sch & "sendusing") = 2 cdoConfig.Fields.Item(sch & "smtpserver") = "127.0.0.1" cdoConfig.fields.update Set cdoMessage = Server.CreateObject("CDO.Message") Set cdoMessage.Configuration = cdoConfig cdoMessage.From = "test@gmail.com" cdoMessage.To = "test@gmail.com" cdoMessage.Subject = "Sample CDONTS NewMail" cdoMessage.TextBody = "This is a test for CDONTS message" cdoMessage.Send Set cdoMessage = Nothing Set cdoConfig = Nothing %> error '8004020f' /tad/testing.asp, line 30 I'm not sure what's wrong. When I go to my SMTP Virtual Server settings in IIS --> Properties --> Delivery --> Advanced . The FQDN is localhost and the smarthost is blank.
View Replies !
Html Form Under Windows 2003
My company has recently started testing Win 2k3 servers to replace our current 2k versions. The problem I have is that our IT group sent out an email to all web developers stating that HTML forms would no longer be supported in 2k3 and all forms would have to be converted to asp pages.Since the form tag is in the html specs, I find this rather hard to believe.
View Replies !
CDONTS And Windows Server 2003
if I can use CDONTS in W 2003 Server environment to send emails the same way it is used in W2K Server. I have heard that CDONTS is no longer available in W 2003 Server and if so, how can I send emails from ASP page.
View Replies !
ASP 3.0 - Migration To Windows 2003 Question
I have a ASP 3.0 web application that uses IIS 5.0 with W2K (with parent paths enabled). In my research about migration to IIS6 with W2003 it says that you need to change every INCLUDE FILE= to INCLUDE VIRTUAL=. I call an ASP page at the root of the website and that ASP file has an include that also is at the root, and the include is like this: <!-- INCLUDE FILE="copyrightstuff.htm" --> So what I've read say that this has to be changed to VIRTUAL like this: <!-- INCLUDE VIRTUAL="/websitename/copyrightstuff.htm" --> I could do this for one website that has one name listed in IIS. However, my website code was designed to work on many different websites, each with different domain names. It seems like a LOT of work to have to change ALL the includes to accommodate the name given to the site in IIS. Code:
View Replies !
Windows Server 2003 Probs
I have a site thats been up for 2-3 years on an NT4 server using IIS & Ms Access, and I used MAcromedia Ultradev to build it with MX 2004 to maintain it. The hosting company decided to upgrade the server to Windows Server 2003 and now none of the Dtabase connections or include files can be found. Does anyone know what I need to do to re-code this site.
View Replies !
Download Of Files To Windows Mobile 2003
We have a WEB-based application (developed in Visual Studio 2005) running on handheld devices in Internet Explorer on Windows Mobile 2003. The application needs to print tickets on a Bluetooth printer, which is accomplished by preparing a RTF-file on the server and then downloading this file to the handheld device. We use a third-party application (PrintPocketCE from FieldSoftware) for the actual printing of the downloaded file. However, when the file is about to be downloaded we first get a question saying "Download <filename> to the My Documents folder in Main Memory?" with Yes, Change and Cancel buttons. Is there a way to avoid this question and download the file directly? We need the checkbox "Open file after download" to be checked (as it is by default when the question is displayed) to get the file processed by PrintPocketCE after download. To avoid adding file by file to the handheld device we always use the same filename for the downloaded file. This leads to another question on each download, asking whether to overwrite the previously downloaded file. Since the file has no interest after being printed this question is always answered with Yes. Is there a way to avoid this question too, for example by setting some Registry value?
View Replies !
Weird Error Windows 2003 Server
I am recieving a weird error when I try to run asp scripts on my local machine, I can use pages that access a database, but when I try to write to the file system ie upload a file I get the error message below. any ideas?
View Replies !
MSWC.Tools & Windows 2003 Server
Hi people, I currently have a website and the asp pages include the following line: "Set Tools = Server.CreateObject("MSWC.Tools")" My site is hosted on Windows 2000 server. The hosting company has offered me a new deal but on Windows 2003 servers, I took them up on this but found that my asp pages did not function as these servers do not have the Internet Information Server (IIS) Resource Kit installed on them. I found this out by looking at http://support.microsoft.com/kb/q249290/. As I am not the original creator of the asp pages and have no knowledge of asp, can anyone help me fix this problem where my asp pages will function correctly on the Windows 2003 server?
View Replies !
Slow ASP Pages On IIS6 / Windows 2003
User clicks a link that displays a customer card and financial stats (has a lot of database calls). Every 5 times the user clicks the same page/link it takes about 30 seconds (normal response time is <1 second) to display. Code:
View Replies !
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 !
Email Program Won't Send In Windows 2003 - Queue_Manager
I have a client that just switched to Windows 2003 server. Their website has always run fine under Windows 2000, using an email program queue_manager.exe to send order and support emails (sending a receipt to the sender). This seems to work under Windows 2003, but won't send the email. I suspect it's a security configuration issue, but can't seem to pin point it (since I am a novice with 2003 server). The server also has Exchange Server installed.
View Replies !
Windows 2003 'ASP 0178 : 80070005' COM+ Security Problem
I am getting the following error in my asp page Server object error 'ASP 0178 : 80070005' Server.CreateObject Access Error /exctest/test.asp, line 7 The call to Server.CreateObject failed while checking permissions. Access is denied to this object The dll in question has been installed on a windows 2003 server as a COM+ application. This has then been exported as an application proxy to another windows 2003 server. The web app has been set up for Basic Authentication only. If when running I logon as a Domain user, who only has domain user rights the above error occurs, if I add my domain user to the administrators group on the server where the actual com+ application resides everything is fine and works as expected. However, having a domain user a member of the administrators group is not ideal. What am I missing in security configuration so that domain users can create and run with the com+ application.
View Replies !
Running Bat (batch) Files On Windows Server 2003 With Asp
im trying to run a bat file on windows server 2003 and am running into nothing but problems. i have IIS on my XP workstation that accesses the 2003 server. what im about to explain below works properly on the XP IIs. i have two files: somefile.asp and somefile.bat. the asp file creates a wscript.shell and then tries to execute the run method for somefile.bat. however, it isnt working. after an unexaggerated 7 hours of searching google/etc, i have found nothing but frustration and deep, seething anger regarding this problem. Code:
View Replies !
Corrupted Double-byte Characters In Windows 2003 / IIS 6.0
I moved ASP WebPages from Windows 2000 server to Windows 2003 server platform. Those double-byte characters (Japanese) retrieved from SQL server 2000 are corrupted. I am using Macromedia Dreamweaver MX as the development tool, by encoding webpage as "UTF-8" as the following, <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> I also add <% Response.CodePage = "65001" Response.Charset="utf-8" %> into my ASP page. But it does not solve the problem. My ASP pages are working perfectly in Windows 2000 server, but they are not working on Windows 2003 server (Web edition & Enterprise Edition). Is there anyone encountered the similar problems before ? I research the Microsoft website, no any answers on that.
View Replies !
On Windows 2003 IIS (6.0) Failed To Download A File From ASP Page
The ASP application uses the "File" active-x control. On windows 2003 IIS(6.0), the download the file fails with the Error: Request object error 'ASP 0104 : 80004005' The above error is retuned by my asp code: lnBytes = Request.BinaryRead(lnByteCount) I did not see this error on windows 2000 server. Is there any solution/workaround available on Windows 2003 IIS(6.0) for this issue.
View Replies !
Formmail Email Page Won't Work After Windows 2000 Update
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 !
ASP, CDO For Windows 2000 & Embedded / In-line Images Showing As Attachments
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 !
JScript: Can't Programmatically Delete Cookies On Windows 2000 Professional
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 !
APS Pages Not Working Now After Windows 2003 Service Pack 1 Install
Has anyone had any problems with Win2003 Service Pack 1 messing up things in IIS regarding asp pages? I had a small test site working yesterday and last night I ran the Windows critical updates on the server that included Service Pack 1. This morning my asp pages are not working. Also I'm using Dreamweaver MX 2004 and I'm trying to setup another database connection for another page. I connect to the access .mdb file and it tests successfully. However, when I go to look at the tables in Dreamweaver, it shows that there are NO tables. I know that there are tables and it was working yesterday. Nothing has changed between yesterday and today except for the windows critical updates. Any ideas??
View Replies !
SQL Server 2000 Database
I just started learning ASP.NET and i need to learn to use the database for SQL Server 2000 quickly. First, (forgive me for my ignorance) what is a database? Do you guys know any good sites that teach you how to access the database for SQL Server 2000? and have tutorials, and sample code?
View Replies !
Connecting To The Database...
I have moved my database from an sql2000 server to an SQL7 server I am trying to connect to the database using windows authentication (no need for username and password) but I keep getting this error: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified I have already created a DSN driver named "projects" to point at the server This is the code I have used: set con = Server.CreateObject("ADODB.connection") ' Use the object to open the inventory ODBC DSN con.Open ("dsn=projects,"",""") Can you please help me set it up?
View Replies !
Connecting To Database.
I have set my sitein the following directory "C:InetpupwwwrootShevi" In this I have all my html and asp files.I also have a database called "guest.mdb" I use this code to connect to my database and read and write..But it doesn't work..Sometimes it just shows the records in the databse but when I try to submit a new record (through a form) it gives me errors. set Conn = Server.CreateObject("ADODB.Connection") Conn.Open("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & server.MapPath("sheviguest.mdb")) set rs=server.CreateObject("ADODB.Recordset") rs.CursorType = adOpenKeyset rs.open "SELECT * FROM Guestbook", Conn Is the part in blue correct? If not tell me how
View Replies !
Connecting To Database
I've created a MySQL database and i'm trying to connect to it to retrieve data using MyODBC and ASP.. I tested it on IIS 5.0 but it keeps saying that it couldn't connect to the database..
View Replies !
Connecting To Database
I have a webpage on my Local Host Server - IP: 127.0.0.1.I have a Access Database called "database.mdb" hosted on a Second Server in a folder called "db" - IP: 134.67.23.5 The IP Address is only an example So the address of my database would for this example be http://134.67.23.5/db/database.mdb I am use to connect to a database like this: connect = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("dbdatabase.mdb") & "" How do I create the connection from my local host webpage to my database on the second server?I have been battling with this for sum time now?
View Replies !
Connecting To Database
I'm using VB with ASP and need to access a database, was going to use Access or Oracle access more then likely. I don't know how to do this does anyone have a simple example?
View Replies !
Connecting To A Database
I am trying to connect to my database using (the database is stored at D:InetPubmysitesdatabaseMYadmin.mdb): Const dbPath = "databaseMYadmin.mdb" But it returns the error: 'D:Inetpubmysiteswebsite1htdocsdatabaseMYadmin.mdb' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides. Is there a way to define the root folder (say as 'D:Inetpubmysitesdatabase), or will I have to move the website to be outside of the /website1/htdocs/ folder?
View Replies !
Connecting To Database
I have started to recieve the following error after creating a new database and a DSN connection to this database Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data.
View Replies !
|
TRACKER
