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 Chriss Miller 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

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

    Stored Procedure Problem

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

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

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

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

Part and Inventory Search

Back
Top