Recent content by SpeedOLight

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

Has anyone found an answer for this? I have a similar issue using the following tables: Create 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...

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