Brad...
A lot of what has already been said should resolve both issues. ASP operates off the kernal on NT servers. If a page doesn't clear objects out of memory they are retained there as long as the service is active. As well as checking for proper closing of your database make sure you...
When using fields in a recordset the correct syntax is "RS("Field Name"). In your second example rs(id_number) should read rs("id_number").
I see your trying to use a DSNless connection. First of all SQLServers use the computer name to indentify itself. Here's a connect string that works.
ConnectString = "Provider=S Q L O L E D B; DATA SOURCE=(Computer name where SQLServer exists);UID=sa;PWD=;DATABASE=(Database name) "...
I'm building an application that requires the initial page to be filled with default values in the text boxes. What I'm looking for is a routine that will clear the boxes of the initial values when I press reset.
I never use the global.asa for database connections. Instead I create a configuration include with seperate database logins. This way I can close the connections right after I pull my data and never have a problem. If your using and access or SQL database this will work. By creating a...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.