Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Marmalade

    Stored Procedure Problem

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

    Stored Procedure Problem

    ...tinyint = NULL, @Price money = NULL, @CourseID smallint = 00, @TermID tinyint = 00 AS DECLARE @ItemID int DECLARE @CourseTermID smallint /* Create and populate new Item record */ INSERT INTO Items VALUES ( @TypeID, @PublisherID, @Title, @Author, @Edition, @Copyright, @ISBN, @Price ) /*...
  3. Marmalade

    Stored Procedure Problem

    ...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 in the first two steps...
  4. Marmalade

    Server Error: Login Failed

    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.
  5. Marmalade

    Server Error: Login Failed

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

    Server Error: Login Failed

    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
  7. Marmalade

    Server Error: Login Failed

    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...
  8. Marmalade

    Connecting to SQL Server database

    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...
  9. Marmalade

    Connecting to SQL Server 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...
  10. Marmalade

    Connecting to SQL Server database

    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'...
  11. Marmalade

    Pop-Up Window for Database Entry

    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
  12. Marmalade

    Pop-Up Window for Database Entry

    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
  13. Marmalade

    Pop-Up Window for Database Entry

    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...
  14. Marmalade

    Cancel button

    ...to a standard HTML file, and it worked perfectly in my development environment. For some reason, however, the JavaScript embedded in my ASP pages *won't* run on development. Here's an example of a function that I use for form validation on a login page: <script language=javascript...
  15. Marmalade

    Cancel button

    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...
  16. Marmalade

    Cancel button

    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...
  17. Marmalade

    &quot;Characters found after end of SQL statement&quot;

    Thanks - that cleared it up! M
  18. Marmalade

    &quot;Characters found after end of SQL statement&quot;

    ...SQL statement&quot; The code generating the error looks like this: If Request.Form(&quot;course&quot;) <> &quot;&quot; Then SQL = &quot;Select * FROM Items &quot; SQL = SQL & &quot;WHERE Course_Number LIKE '&quot; & Request.Form(&quot;course&quot;) & &quot;'&quot; End If Set objRS =...
  19. Marmalade

    Hi, folks, I recently ran the bu

    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...
  20. Marmalade

    Name trouble

    ...name, &quot;Textbooks,&quot; that was used by an earlier version of the database. Finally, the Debug menu in Access refers to the database by its *original* name, &quot;Books.&quot; Why are these earlier names still in use? Is this dangerous in any way? And is it possible to establish the...

Part and Inventory Search

Back
Top