I have an Intranet-based app at work, and I have it in two places there: a
dev machine and a production box. In both cases, the ASP files and SQL
Server 2000 database are on the same box. I have it running smoothly in both
places at work.
However, I've been trying to set it up at home, and cannot make the SQL
Server connection work for some reason. I've been working on this off and on
for weeks, and I just don't get what I am missing. Code:
i found out that by default, ASP apps can only access files that are on the computerthat the server runs on. how can i change this so the IIS will take the files off the client's computer?
I am trying to do a very simple piece of asp on a w2k3 server on the company intranet where i work (using IIS 6) the code is simply trying to get an xml stream via a ServerHTTPRequest.
The code I have works absolutely fine, I have tested it on a free asp friendly server on the net and it does exactly what i want it to! however when I run the code on the company intranet I get hit with the following problem.... Code:
I've create a custom com object and I use it as follow:
set test = Server.CreateObject(myObject.classID) ' --> all OK the istance of the object is correctly created
retval = test.function1(par1, par2 ...) ' --> as soon as I call every function of my com object the system returns the following error: 0x8000FFFF: catastrophic failure. I do not know why
I use the method below to send emails from an asp page that's part of a web application:
<!--METADATA TYPE="typelib" UUID="CD000000-8B95-11D1-82DB-00C04FB1625D" NAME="CDO for Windows 2000 Library" --> <% On error Resume Next Dim cdoConfig, cdoMessage
Set cdoConfig = Server.CreateObject("CDO.Configuration") With cdoConfig.Fields .Item(cdoSendUsingMethod) = 2 .Item(cdoSMTPServer) = "MailServer.Name.com" .Item(cdoSMTPServerPort) = 25 .Update End With Set cdoMessage = Server.CreateObject("CDO.Message") With cdoMessage Set .Configuration = cdoConfig .From = "Me<mailsender@mymail.com>" .To = "You<mailrecipient@somemail.com>" .Subject = "Surprise!" .TextBody = "Helloooo..." .Send
If err.number Then Response.Write("Houston! We have a problem...") End If End With Set cdoMessage = Nothing Set cdoConfig = Nothing %>
On the production server (Windows 2003 Server) everything works fine and I don't have a problem sending the mails from the application. However, I recently upgraded my development box to Windows XP Pro SP2 and the code fails with with the following error:
CDO.Message.1 (0x80040213) The transport failed to connect to the server.
The from and to email addresses that I'm using are valid and part of my domain (not a Hotmail or other freemail address).
The SMTP service is up and running on the dev box.
I also tried replacing the mail server name with the IP address of the mail server, but again it's failing.
We are running Exchange Server for email and if I change the cdoSendUsingMethod to 3 (for cdoSendUsingExchange) the mail is sent correctly without errors.
Will I not able to use the cdoSendUsingPort method to send the email if I'm on Exchange? Am I forced to use cdoSendUsingExchange?
Anyone got much of a clue how best to send emails to selected people from a database table and to be able to track them, maybe as much as a read receipt, or perhaps just checking that they don't bounce, or end up in the bad mail folder.
Is this best/possible to try and code or is there a free/cheap component that does this simply.
I'm having a bit of trouble with an ASP form that I'm maintaining. Someone else wrote it and I'm new to CDO objects. I have a CDO.Message and a CDO.Configuration.
I set up the configuraton fields for the port and smtp server's ip address to be used. The configuration property of the message is set to be the new configuration object.
Then there's a ton of stuff appending bits and pieces to the text body.
Finally we have the message's Send method being called. That's where it breaks.
It seemed to just stop working one day. When I submit the form, the message returned is simply:
error '8004020f'
I know from the MSDN website that this error code means 'Failure in obtaining user token.' What I don't know is how to fix it!
I wanted to know wheather DSN is ok for the connection to a database or direct conection is better?
when i started my web project on dreamweaver i had to make a DSN connection as i have followed the books, but as now as i have also asked several questions on this site, i have aslo implemented a direct connection as well on some pages, now i am wondering is this going to have any affects when i uplode the complete site on the server.
i have noticed that on my computer when i am testing the site and uploading new records on sections that have DSN connections you can see the new record but on sections that i have implemented direct connection i cannot see it coz it is linked to the local directory database not on the testing server.
i have also never experienced uploading to a IIS server with DB connection so its my first time with dynamic websites. so am i in trouble or its ok the way i have done my site..
I am trying to create a web page that has a drop down menu in which it retrieves data from our SQL server. Maybe this is a bit more simple than I am making it but I am really pulling my hair out trying to get this right. Code:
this is my error: [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.
here is my db connection string:
<%@Language=VBScript%> <!--#include file="adovbs.inc"--> <% dim rs, cn Set cn = Server.CreateObject("ADODB.Connection") 'with cn ' .Provider="Microsoft.jet.oledb.4.0" ' .ConnectionString=Server.MapPath("home/nfiweb.mdb") ' .Open 'end with cn.open "nfijobs" set rs = Server.CreateObject("ADODB.Recordset") %>
When I click submit after updating the information all of my info gets deleted from the db so I'm guessing that the values that are being submitted are not getting picked up in the sql. I've tried changing the form names, etc, but still have the same prob. My code is below: Code:
I am having trouble connecting to an Access db fro mmy asp page. I get the following error: The page cannot be displayed There is a problem with the page you are trying to reach and it cannot be displayed. Code:
' -- Our SQL Statement response.write "Declaring SQL Statement" strSQL = "SELECT * FROM TIMES" ' -- Populate our Recordset with data Set objRS = GetRecordset(strConnection, strSQL)
I have done many searches but all the connection strings I've found seem to be using a DSN to an access DB. Currently I get this error when trying to connect.
Microsoft OLE DB Provider for ODBC Drivers error '80040e4d'
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
I can't seem to find the proper syntax to specify a db login (sa) and password in the connection string.
on 1 page i open a connection to a database and build a recordset to check username and password. there are other fields in the db that i need to access on the next page. how do i reference that connection and run a new sql query without having to reopen the connection? i thought it would be as simple as NOT closing it, but thats not working.
I am having problem in my connection to database when running ASP. It works fine for the first time but if I run it again without a gap of atleast a minute, it gives me the following error message:
And the line it is showing error is where I am opening my database connection using conn.open.If I wait for couple of minutes and run again,it works fine.
I'm trying to maintain a permanent tcp/ip connection between two computers using ASP. I need users accessing the ASP pages to be able to send and receive messages using this connection. I know that I can't use a Winsock control with ASP so I guess I'm looking at a third party control. Even if I can get this working I'm not sure that I can have different users accessing this one permanently open connection. I've looked all over the Net for ideas on how to do this but I've had no luck. Has anyone had to do anything like this?
I am trying to establish an ODBC conection to ORACLE 10g and have tried all the following. Please advise:
We are trying to connect to a 10 g server and nearly gone crazy after doing so. tried everythign, DSN, DSN less .... The bottom line the connection is successful when we try it form the control panel-> data source thing but not from ASP. We tried the following things: Code:
I created a master detail page using the wizard in Dreamweaver, however I need to create a DSN-less connection. How do I do that? I am assuming I need to edit this part of my code:
I am getting 500 Internal Server Error. I have tried disabling the show friendly error in IE and I have tried it on Firefox. It will not give me the reason why it will not work, I only get 500 Internal Server Error.
I have tested the code up to the point of Set objConn and it works but when it gets to the objConn.open dsn that's when I get the error. I wish to find out why it is not allowing it to get pass this point. I have control of the server where this is hosted and if there is anything I need to do, I can do it.
I am trying to create a web page on our company intranet.I am using Frontpage 2000.I need to be able to read from and write to databases in this project.I am starting slow since I am just learning, so for now I am trying to read from an existing SQL database on a network server. The server is running SQL Server 2000 and IIS.
I could create a database connection using the Database Results Wizard in FP. The connection would verify OK and I could select the columns from the table I wanted to display. When I published the page to the server, all I got was column headings, no data.
when I try to create a new db connection, it will verify, but it will not show up as an existing db connection.
need to connect DB2 tables on mainframe, using a ASP front end...But I do not know how to... what all things I should enquire & need in the system before doing the same. connection format to connect a databse on mainframe.
My client have a allready built database. and now need to access that database with asp. How do i connct to a sql database through asp? Would like to use mapPath() in stead of a DSN. Could only find DNS examples on the net.
I just want to import this part of VBscript file to an asp code to help my frined. This part of code is working if I run it as a vbscript on the command line, but we could not get it run in a asb files.
I have no idea of how to connect to my database (access) to my asp pages using DSN (ODBC). I've already upload my database file in the folder called db and I've already added DSN. Can you guys provide me some sample code?
Iam trying to connect to my database using dreamweaver but I am told that I do not need it ! I can't understand how am I supose to use my Database? I refere to DSN, user name and passoword, but I was told no need for it as I can just do some coding, so is there anyway I can code it ?
my host company cannot understand that I need a DSN connection and when I asked about the password they tell me...no need for it.