Search results for query: *

Oh, man! I can't believe how stupid I was... Thank you!

Thanks, guys. I've done as you recommend, but I keep running into the same problem - TableB keeps raising an "invalid object" error. I've included the actual code below, using the real table and variable names (TableA = Items; TableB = CourseTerms; TableC = CourseTermItems); am I still...

Hi, I'm writing a stored procedure to (1) Create a new record in one table (A) and store its identity value; (2) then create a new record in a second table (B) and store *its* identity value; (3) then create a new record in a third table (C) and populate it using the identity values generated...

Thanks! I was able to get integratee security working by following your instructions, and that article gave me a much better understanding of what's going on.

Thanks, Zarcom. What are the advantages or benefits of using Windows integrated security, anyhow?

I went in to copy it, and realized that my password was missing! Now it works perfectly, of course. Windows NT Integrated Security still doesn't work - could that be because Basic Authentication isn't automatically enabled for the application under IIS? Thanks, M

Hi, I'm trying to connect to a SQL Server 2000 database using a Data Reader in a Web Form page, and I can't manage to log into the database. This is true whether I opt to use Windows NT Integrated Security or a specific username and password when setting the Connection String in the Data Link...

Thanks, everyone, for being so helpful. I'll make sure that SQL Server is installed on my server, then try the connection strings you recommend. Denoxis, I'm curious - what do you mean when you write that I have nothing to do with my physical file? Is that why I'll have to export the database...

Thanks, guys. I'm still a bit confused, though. Should I remove the Initial File Name parameter completely and add either "Data Source=xxx.xxx.xxx.xxx" or "Server=xxx.xxx.xxx.xxx," where xxx.xxx.xxx.xxx is the IP of the server where I've placed the database? I should add...

Hi, I've uploaded a SQL Server database that I developed on my own workstation (using SQL Server Eval edition) to a server, and am trying to access it via an ASP page on the same server. However, I keep getting the following error: Microsoft OLE DB Provider for SQL Server error '80004005'...

Wow! Thanks - hopefully, I can figure this out. Even if I don't, I'm sure I'll learn something just by trying. Thanks again, M

That sounds great; unfortunately, the page is in development on my workstation, so I can't send a link (but I could send a screenshot, if that would be helpful). How were you able to do all of that on one page? M

Hi everybody, I've built an ASP form that uses database-driven list boxes. I wanted to give users the opportunity to add items to the table that provides the list box options, so I coded a JavaScript pop-up that refers to an ASP page for data entry. Problem is, once you've added an item to the...

Thanks, Jeff; I should have realized that my webserver wouldn't have anything to do with JavaScript execution! I saved the alert(hello) snippet to a standard HTML file, and it worked perfectly in my development environment. For some reason, however, the JavaScript embedded in my ASP pages...

Thanks, everyone - the button works beautifully now! I have noticed something strange, though; my JavaScript routines never execute in my development environment (I run my test pages on a PC workstation running IIS). They work just fine in my production environment, however. Anyone know why that...

I've included a &quot;Cancel&quot; button on a form that posts to an ASP page for processing, and which uses JavaScript for form validation. The &quot;Cancel&quot; button uses the following code: <input type = button onclick='javascript: history.back(1)' value=&quot;cancel&quot;> When I click...

Thanks - that cleared it up! M

Hey, folks, I'm trying to run a SQL query against an Access database via an ASP page that uses information entered into a form, and keep getting the following error message: &quot;Characters found after end of SQL statement&quot; The code generating the error looks like this: If...

Thanks, j; I ran the statement, and the Debug menu now displays the current name. The &quot;Title&quot; field on the Summary tab of Database Properties still shows an older name, however; and when I try changing it, a dialog box pops up informing me that Access &quot;is unable to save the...

Hello, folks, I'm working on a database that has gone through several different versions and name changes, and have come across a confusing problem. Any insight would be much appreciated. The current name of the database, &quot;Item Tracker,&quot; appears both on the .mdb file icon in Windows...