Anthony1312002
Last Activity: Mar 6 '08, 03:50 PM
Joined: Sep 4 '06
Location:
-
Thank you for the response. I'm unfamiliar with this kind of connection. When you say that the code needs to be optimized what do you suggest. I'm somewhat new at coding. -
By the way, my database was created using Access 2003 and I've recently upgraded to Office 2007. This worked on my XP Pro setup but not having the same success in Vista.Leave a comment:
-
Could it be the type of connection I'm using. Here is my connection script:
dbpath = "D:\accessdb\te st\billing"
CommStrStart = "Provider=Micro soft.jet.oledb. 4.0;data source="
If Session("SName" ) = "Charlotte" Then
DataConn = DBPath & "\CharlotteBill ingData.mdb"
End If
Set Conn = Server.CreateOb ject("ADODB.Con nection")...Leave a comment:
-
Windows Vista Ultimate - Connecting to an Access DB in IIS 7
Hello everyone. I just recently moved to Windows Vista Ultimate from XP Pro on my desktop machine which of course means I'm running IIS 7. I'm able to view asp pages that don't connect to an access database by way of an include file I have in the wwwroot directory. But when I try to access any page that has this include file I get the error number #500 this page cannot be displayed. I took a look at whether or not the IUSR user has Adminstrative... -
jhardman, thanks for responding. This really helps. I'm really just getting my mind around codeing concepts. I see you mentioned creating a variable and using this to ignore or skip certain lines in the file. I hope it's not asking to much but could you give me a visual of what this would look like using my current code?Leave a comment:
-
Skipping lines in a text file
Hello. I have a scipt the reads and imports a text file into a database table. Below is an example of the text file I'm importing and the script I'm using to accomplish the import. You'll notice at the beginning of 3 of the lines in the file you see the number 84. What I need to be able to do is skip the first two lines where 84 appears and import the last line containing 84 and then continue to load the rest of the file. How can this be done? ... -
Importing a comma delimited textfile
I have a working script that imports a space or tab delimited textfile using the vbTab attribute. But because of an upgrade the file has now become comma delimited. what would I need to change to make this script work with the new file format?
strTextLine=obj Text.Readline
data=Split(strT extLine,vbTab)
RLog.AddNew
RLog("fldUnknow n")=data(0) 'Site ID
RLog("fldAccoun tName")=data(1)... -
Hey guys, I'm also trying to use ASPEmail to send an email when the form is submitted. The script tells me that the email was successsfully sent but I'm not seeing any emails. I enabled my SMTP server so that it allows me to transfer emails. I'm also running IIS on an XP machine locally. What could be the problem?
<%
' change to address of your own SMTP server
strHost = "MySite.GG. net"
If...Leave a comment:
-
Thanks for the response susen. I'm able to create the objMail object just fine. But I'm getting the error "(0x8007000 3) /EmailBlast.asp, line 25". Line 25 is where I try to send the email. Using objMail.Send. How can I fix this?
set objMail = Server.CreateOb ject("CDONTS.Ne wMail")
do Until RSEmails.eof
objMail.Send FromAddress,RSE mails("EmpEmail Address"), _...Leave a comment:
-
Sending an email using ASP
I hope someone can help me. I'm trying to setup an ASP page that will automatically send and email once the submit button is clicked. But my problem is that Lotus Notes is the email client and the script below is setup for Outlook to be the client. I've tried looking on the web but I can't seem to find anything that helps. Can anyone help me alter the code below so that it will work with Lotus Notes?
<%
if not IsEmpty(Request .Form("Send"))... -
Renaming a file in ASP
Hope someone can help me. I'm using ASP and VBScript to import a text file. The original format of the file is this: yyyymmddflatnc3 .txt. During the import can I automatically rename the file so that it is in this format mmddyy? And if yes, how do you do it? Any help would be appreciated. -
Hey r_o, I just joined this forum and saw your post. I'm using the method you mentioned in my web application. Here is how I'm going about it.
Start your loop and assign the unique ID (auto number in Access table) to a variable. In this case I've assigned CustomerID to the variable t_id
<%
'queue up to the top record of the recordset
If Not rs_users.EOF Then rs_users.MoveFi rst
...Leave a comment:
No activity results to display
Leave a comment: