Error Type: Server object, ASP 0177 (0×800401F3) Invalid class string
October 22nd, 2008Error Type:
Server object, ASP 0177 (0×800401F3)
Invalid class string
Error Type:
Server object, ASP 0177 (0×800401F3)
Invalid class string
Dim cmd
SET cmd = Server.CreateObject(”ADODB.command”)
WITH cmd
.CommandType = adCmdStoredProc
.CommandText = “”
.ActiveConnection = “”
.Parameters.Append .CreateParameter(”@bbID”,adSingle,adParamInput,3,)
.Parameters.Append .CreateParameter(”@raCode”,adVarChar,adParamOutput,,”")
.Execute, , adBinary
‘adOpenStatic,adLockBatchOptimistic
‘adOpenForwardOnly,adLockReadOnly
‘adOpenStatic,adLockReadOnly
‘adOpenDynamic,adLockOptimistic
END WITH
Set cmd = nothing
‘—- DataTypeEnum Values —-
Const adEmpty = 0
Const adTinyInt = 16
Const adSmallInt = 2
Const adInteger = 3
Const adBigInt = 20
Const adUnsignedTinyInt = 17
Const adUnsignedSmallInt = 18
Const adUnsignedInt = 19
Const adUnsignedBigInt = 21
Const adSingle = 4
Const adDouble = 5
Const adCurrency = 6
Const adDecimal = 14
Const adNumeric = 131
Const adBoolean = 11
Const adError = 10
Const adUserDefined = 132
Const adVariant = 12
Const adIDispatch = 9
Const adIUnknown = 13
Const adGUID = 72
Const adDate = 7
Const adDBDate = 133
Const adDBTime = 134
Const adDBTimeStamp = 135
Const adBSTR = 8
Const adChar = 129
Const adVarChar = 200
Const adLongVarChar = 201
Const adWChar = 130
Const adVarWChar = 202
Const adLongVarWChar = 203
Const adBinary = 128
Const adVarBinary = 204
Const adLongVarBinary = 205
Const adChapter = 136
Const adFileTime = 64
Const adPropVariant = 138
Const adVarNumeric = 139
Const adArray = &H2000
Add these line of codes to the page.
(http://www.aspkey.net/aspkey/_articles/asp/showarticle.asp)
<%@ LANGUAGE="VBSCRIPT" %>
<!--#Include virtual = "adovbs.inc"-->
<%
Response.Buffer=true
Response.AddHeader "cache-control", "private"
Response.AddHeader "pragma", "no-cache"
Response.ExpiresAbsolute = #January 1, 1990 00:00:01#
Response.Expires=Now()-1
Response.AddHeader "Cache-Control", "must-revalidate"
Response.AddHeader "Cache-Control", "no-cache"
%>
I was working on a (rather neglected, outdated) site I had previously done and decided it needed some (rather, a lot of) improvements. I was looking for a way to get rid of to clean up the URLs without having to remap my files. .htaccess to the rescue!
.htaccess files are a wonderful thing, and incredibly powerful, ignoring the bad experience I had with them on my current web host (fortunately, this project is hosted by another web host, and everything runs perfectly with them :)), and Apache’s mod_rewrite module does exactly what we need.
There are a bunch of reasons you’d want to do this, mainly:
In this case, we’re using PHP files, but you can change it to whatever type of file you’re using, be it .html, .asp, .cfm, or anything else, as long as they’re all the same type. (If you want to do this for multiple file types, just copy lines 2–4 and apply the same technique accordingly.)
Open your text editor and create a file called “.htaccess” with the following code in it, and upload it to your site’s root directory (Note: On Unix and unix-like operating systems, files that start with a dot are hidden files, so you may not be able to see the file after you save it. To get around this, omit the preceding dot when naming the file, and then rename the file back to “.htaccess” after you have uploaded it to your webserver):
RewriteEngine on
RewriteCond %{REQUEST_FILENAME} !-d
RewriteCond %{REQUEST_FILENAME}\.php -f
RewriteRule ^(.*)$ $1.php
(adapted from the Apache mailing list)
Using this code, instead of having to type in http://mysite.com/contact.php, you only need to enter http://mysite.com/contact to access that page. And the best part is, you can still access the page with .php on the end of it, so no old incoming links or bookmarks become orphaned as a result of this, and everyone is happy.
You might have taken these ‘worst job-seeking advices’. Read the rest of this entry »
Here are six common job search “rules” and when it might be acceptable to break them. Read the rest of this entry »
If your résumé isn’t winning interviews for your dream job, it might be time for a rewrite. Read the rest of this entry »
“I like what I do. I just don’t like where I work.” Sound familiar?
From unbearable co-workers to depressing work environments, there things that can make even the best job a living hell. Here are some signs it’s time to look for a new job. Read the rest of this entry »
Interviews are nothing if not opportunities to drive yourself crazy. Just remind yourself to look good, appear confident, say all the right things and don’t say any of the wrong ones. It shouldn’t be so hard to follow these guidelines except you’ll be on the receiving end of an endless line of questions. Factor in your nerves and you’ll be lucky to remember your own name. Don’t fret. If you walk into the interview prepared, you can make sure you know what right things to say, and you can stop yourself from saying the following wrong things. Read the rest of this entry »