Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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