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

    Upload File To Database

    In case you haven't found the answer to file uploads... In the JSP, have the following tags set: <form name=&quot;fileupload&quot; method=post action=&quot;yourservletname&quot; enctype=&quot;multipart/form-data&quot;> and <input type=&quot;file&quot; name=&quot;UploadFile&quot;> Next -...
  2. SpeedOLight

    How can i get the table name of colums in resultset?

    ...Table BOOK( BookId int, Name varchar(50), AuthorId int ) Create Table AUTHOR( AuthorId int, Name varchar(30) ) and my select is Select BOOK.*, AUTHOR.* From BOOK Inner Join AUTHOR On BOOK.AUTHORID = AUTHOR.AUTHORID As you can see, the ResultSet from this select will have 2 identically...
  3. SpeedOLight

    linked server with the as/400

    Glad it helped out... Regards...Marc Independent Software Consultant
  4. SpeedOLight

    Call a stored procedure from a SELECT statement?

    Actually, you can build dynamic SQL statements within a stored proc. Build the SQL statement in an nvarchar variable. Then use the Execute sp_executeSQL statement to execute it. Hope this helps...
  5. SpeedOLight

    Recording telephone conversation (repost)

    Although I haven't used TAPI (Telephony API), you should be able to find info about it on the web...A simple search on google brought up the following link: http://www.sunny-beach.net/vbvoicetelephony.htm It also appears that Microsoft has created some ActiveX components that are TAPI 3.0...
  6. SpeedOLight

    Linking SQL server 7 to AS400 using linked feature

    You can use Client Access via TCP/IP as a Linked Server. Do a search in Tek-Tips for &quot;Linked Server with AS/400&quot;, and it should show you all the necessary parameters for setting this up. Sorry I didn't see this earlier, or I could have helped you out. Regards...Marc Independent...
  7. SpeedOLight

    How to use cursor variables, dynamic sql

    This may give you an idea on using cursors...please note: There's no error checking in this code!!! One other thing, I know that dynamic SQL causes a small performance hit since the Stored Proc needs to re-determine which index to use with each select the data. I don't believe this same...
  8. SpeedOLight

    Access AS/400 from SQLServer v7

    Mohit, One thing to consider...the ODBC driver and the DSN need to exist on the server where SQL Server is installed. Regards...Marc Independent Software Consultant
  9. SpeedOLight

    linked server with the as/400

    Ok...I finally ran across this problem myself while building a new SQL box, and was able to resolve it. 1. Make sure you have Client Access connection object(s) for you AS/400(s) on the SQL Server. 2. Make sure that the AS/400 signon information on the Connection tab in Ops Nav and, if...
  10. SpeedOLight

    Need to Convert ASCII Files into AS/400

    Do you have any tools? Client Access ODBC? Can you FTP it? If using Client Acess, can create an ODBC connection and just do inserts of the Foxpro records. If using FTP, will need to export foxpro table(s) into a text file, and then FTP the file. Both ODBC and FTP will resolve the code page...
  11. SpeedOLight

    Inserting into table on AS/400 using VB - SQL Statement

    A couple of questions... Are the date fields signed, packed, or timestamp (I think that's what it's called in DB2). Also, if you are getting an error which states the table is not valid for operation, it needs to be journalled and have a unique key. A few other things you can do (if you're...
  12. SpeedOLight

    Can we pass/retrieve arrays?

    I'm not aware of an array construct within Transact SQL. You may want to look into creating a temporary table instead. Regards...Marc Independent Software Consultant
  13. SpeedOLight

    linked server with the as/400

    A few differences in ODBC settings... Try the following changes with the DSN used for the linked server: Under packages Enable Extended dynamic package support checked On Under Performance Enable lazy close support checked On enable pre-fetch during execute checked On Size: 1 Also, I'm...
  14. SpeedOLight

    linked server with the as/400

    A few final thoughts... 1. You said that some contractors worked on the original setup. Is it possible that it worked initially for them and then at a later time it stopped working? Is the SQL Server a machine that you can reboot? If so, try this and immediately upon it restarting attempt...
  15. SpeedOLight

    linked server with the as/400

    No Problem... If Client Access Express solves the issue, would you be sure to let this forum know? Thanks... Good Luck... Regards...Marc Independent Software Consultant
  16. SpeedOLight

    linked server with the as/400

    Hmmm...that certainly sounds correct. Maybe it has to do with the software versions you are running... We're using Client Access Express for Windows Version 4, Release 4, Modification Level 0, Service Level None Our AS/400 is running V4R3 (and we're pretty current on our PTFs, but I don't...
  17. SpeedOLight

    linked server with the as/400

    I just want to double check something here, since people sometimes get confused with this. Bear with me if you already know this. 1. The Client Access software and the ODBC Data source name are both setup on the SQL Server box, not the client PC. The query to the AS/400 is ACTUALLY EXECUTED...
  18. SpeedOLight

    DTS and AS/400

    ...for joining between two different DBs. I've only used it with Selects, Deletes, Updates on the AS/400. Format of the statement would be: Select * From OpenQuery( AS400LINKEDSERVERNAME, 'Select * from AS400file' ) Delete From OpenQuery ( AS400LINKEDSERVERNAME, 'Select * from AS400File' )...
  19. SpeedOLight

    linked server with the as/400

    Oh...and another thing... You may want to see if you can setup/access the Linked Server outside of code. Set it up via SQL Server's Enterprise Manager rather than through Transact SQL. Good Luck... Regards...Marc Independent Software Consultant
  20. SpeedOLight

    linked server with the as/400

    Hi there... We use Client Access Express, connecting via TCP/IP (NOT SNA) and have successfully setup a linked server. Tom - Stacey isn't using IBM's OLEDB Provider. She's using the Microsoft OLEDB provider for ODBC and then using Client Access for ODBC. I'm assuming you're accessing the...

Part and Inventory Search

Back
Top