I have written a COM component who's purpose is to allow a user to change
his Windows (NT/AD) password via a web page. Now the component works fine
when I run it in VB 6, but not via the web page. The component also returns
an integer value that contains a return code from the Component (and the
appropriate Windows API). The result (using the ASP page) is Zero, which
indicates success. However the password doesn't change. (Zero = success, 100
= Invalid Domain, 101 = Invalid User, 102 = Invalid Password). Code:
I am doing some research into the reporting capabilities provided by ..NET by itself and also integration with other programs such as Crystal Reports or thrid party tools. I don't have much experience with .NET technologies but most of the reports will be requested through the web and produced via VB components with a SQL 2k backend.
I am looking for reports either in xls or pdf format and mostly they will be data intensive i.e. no graphics such as bar or pie charts etc.
I have customers that I designed a site for. I am almost complete with the site, and they are saying that the font is too small. However, on my computer it looks just like the font on devshed and everyother site. Are there any suggestions out there, as to maybe their settings are messed up or my scripting is bad .
How do I find the difference between them in seconds? I take it thats there's 2 ways of doing it: either with ASP or SQL. Anyway of doing it. how would I go about doing this?
I have a field called EndTime in a table called tblSessions. This field is a Date type, with a General Date format (DD/MM/YYYY HH/MM/SS). I want an SQL query which can return entities which are less than 30 minutes old.
I have developed asp application, but never worked with shopping carts. I was wondering, when a user clicks on Add to Cart for a product, is it done visa session variable, where item detail and price is stored, and later on, fetched and added together to show total price?
I normally work with MS Access databases using ASP pages. I have been given the opprotunity to work on some available SQL server space, and wanted to ask a couple of questions. The following is a simple update query that I use. It is an ASP page that connects to an MS Access Db:
<% Set Conn = Server.CreateObject("ADODB.Connection") myDSN = "DRIVER={Microsoft Access Driver (*.mdb)};" myDSN = myDSN & "DBQ=xxxxxxxxxxxxxxxdatabase003.mdb" mySQL="UPDATE SKUList SET SKUList.Department='Furniture' WHERE SKU='123456'" Conn.Open(myDSN) Conn.Execute(mySQL) Conn.Close Set Conn = Nothing %>
I was wondering if someone could tell me (or better yet show me) how this code would look in a SQL server enviroment. I have no information on the server itself as the database will be setup for me, and I will just need to create ASP pages to connect.
when i run the ip of my web site i get the following error:
HTTP 500 - Internal server error the log file shows the following error: The server failed to load application '/LM/W3SVC/1/ROOT'. The error was 'General access denied error '.
Periodically, our entire website will display the following error for all users when requests are made to ASP pages:
DBMSSOCN General Network Error
HTML pages will load just fine, and I *believe* that ASP pages that don't access SQL Server will also load. Someone suggested this problem has to do with named pipes, but I don't have any clue when it comes to networking and our network admin just resigned. This happens very sporadically (maybe once a day) and never seemed to occur when he had DSN based connections. We also have migrated our SQL Server to another machine (used to reside on the same machine as our webserver).
What does a website need in order to send text messaging to cell phones? Is this something the hosting company will offer or does the website need servers from Micrsoft? Can you refer me to where I can get more information on this?
can anyone tell me what i have to do with this error ...
Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0xeb0 Thread 0x7a0 DBC 0x1110064 Jet'.
everything was ok until i Compact and Repaire the DataBase i checked google everyone says it is security problem. i am admin on my computer but still i give all users Full Control Permission for both Temp and server folder "C:Inetpubwwwrootcareer" and i Add Everyone with Full Control but there is no use
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x18c8 Thread 0x1478 DBC 0x2f56fa4 Jet'.
I am urgently finding a set of codes to write data into a form and the data will go to my database. However i have tried a lot of form but couldn't successfully process. Below is one of my problem...
Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x9a8 Thread 0xa08 DBC 0x3041e1c Jet'.
I am trying to construct an SQL statement that can grab all of the entries out of a table, where the Date field consists of today's date. The Date field is called 'DateTime' - and it is in a General Date format (DD/MM/YYYY HH:MM:SS). I obviusly want to use an SQL statement like this:
SELECT * FROM tblExample WHERE (DateTime = Date());
However, that wont work because Date() will only return a short date (DD/MM/YYYY).
