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!

  • Congratulations strongm 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. obryant32

    Connecting to remote server

    OK, Here's a fun one for you. I have the following scenario that is not working. On our network, let's call it Network1, we have a Sonicwall 2040 set up as our firewall. We also do work with a remote company that has a Microsoft ISA server 2000 acting as their firewall on what we'll call...
  2. obryant32

    failed to open rowset - When grouping

    I have a report that I created in Crystal X. I wrote a stored procedure in Microsoft SQL server 2000 that returns the data set. The wierd thing is that the Stored Procedure and the report work fine until I try to use one of the fields to do some grouping. At that point I get an error that says...
  3. obryant32

    Trigger - Insert into table With AutoGen ID

    Also, I don't have a value to enter for the leadid. I want the leads table, the table which the trigger is inserting into, to assign the leadid. How do I accomplish that? Anyone? Matt
  4. obryant32

    Trigger - Insert into table With AutoGen ID

    Jim, That's what I tried doing but it doesn't end up in the LEADS table. Also, I don't get any errors. Is there a way I can check for errors? Thanks Matt
  5. obryant32

    Trigger - Insert into table With AutoGen ID

    OK, I have a trigger that doesn't seem to work. I'm assuming it's because the table I'm trying to insert into a table called LEADS that has a Field called "LeadID" which has a datatype of "bigint". The thing is that I'm not sure how to insert the rest of the data and have the LEADS table...
  6. obryant32

    Parameterized Query

    Hi...I'm begging for help. What I'm trying to do is create a website template that gets populated based on a unique parameter ID in the URL. http://www.application.com?ID=1 Using that value "1" that I get from the request.querystring I want to then be able to connect to a database and pull out...
  7. obryant32

    Exchange 2003 Enterprise Internal error

    Thanks for the response guys! I'll check it out and see what I can do Matt
  8. obryant32

    how can I change the size of the partition a Windows 2000 server

    How can I change the size of the partition a Windows 2000 server with Raid 5? What software do you recommend?
  9. obryant32

    Exchange 2003 Enterprise Internal error

    Server: Windows 2003 Server Standard Exchange: Exchange 2003 Server Enterprise Legato Module: 4.0.2.372 Hi, we recently upgraded our exchange server from standard to enterprise edition and now we're getting errors when we try to backup our database store. We get the following error in the...
  10. obryant32

    Which Ports Need to be Open?

    I'm running Crystal Enterprise 10.0 Report Application Server. I'm trying to make it acessible to some of my users outside of the office. However, I need to know what ports I need to open up on my firewall to allow users to get through it. Please help Thanks! Matt
  11. obryant32

    Insert Text into column

    OK, so I'm not sure how to go about this. I have a column in one of my tables that stores the URL to a file that is saved on the hard drive. We then use that value to display a link to the file within our application. We recently copied all the files that have been uploaded into our system to a...
  12. obryant32

    Appending characters to data

    Thank you so much! I'll try that out
  13. obryant32

    Appending characters to data

    OK, I'm extremely new to this so here's what I'd like to do and I'm not sure how. Currently we store usernames and passwords in a table for a particular function. What I'd like to do, is go into that table and add the number "1" to the end of every password based on certain criteria. This will...
  14. obryant32

    [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected

    Well, technically it's Owner_Name. So, I changed both and I still get the error. Besides, I didn't think that was case sensative but good idea. Still getting same error.
  15. obryant32

    [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected

    Positive. Ther response.write is showing this: Select Owner_name from Branch where Branch.id = 2 That's also a field in the table. I don't understand it. Thanks
  16. obryant32

    [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected

    Well, the above query works now but I have another query that's oh so simple and it doesn't work. I'm opnly trying to pull one bit of data. I've checked the spelling but it's still getting the one parameter expected.... Sub writeBranchManName() Dim objConnInfo, objRS, Query1 Set objConnInfo...
  17. obryant32

    [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected

    Pardon my ignorance...wher ewould I put the response.write? I've tried it a number of ways and I'm not getting anything.
  18. obryant32

    [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected

    I know that I changed that line, I renamed the query so that's not the issue but here's a copy of the error I'm getting: Microsoft OLE DB Provider for ODBC Drivers error '80040e10' [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1. /lendia/aspFunc/aspFunc.asp, line 598...
  19. obryant32

    [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected

    This is the line that's giving me th error objRS.Open QueryBranch, objConnInfo Not sure why Thanks
  20. obryant32

    [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected

    Well, I've tried really simplifying everything. I'm just trying to pull one value. I'm still getting that error it just says one parameter expected. Here's what I've got Sub writeBranchInfo() Dim objConnInfo, objRS, Query Set objConnInfo = Server.CreateObject("ADODB.Connection") Set...

Part and Inventory Search

Back
Top