Search results for query: *

Use Data Transformation Services that is included with the SQL Server bundle. This is the ETL utility that ships with it. You can create a package and map each table field to field while performing other tasks such as populating default values for the additional fields that don't exist in the...

Dennis, heh, I use a SB Triple Espresso IV Drip. John Pasko "No matter where you go, there you are." -- Buckaroo Bonzai

************* Start of code EXEC('SELECT * FROM tblqaCorrespdence WHERE iIndex IN (' + @tmpIndex + ')') ************* End of code These are the values that need to pass - Execute spTest(1,2,4,6,7) Shouldn't the SELECT be a DELETE? John Pasko "No matter where you go, there you are." --...

The Web is a stateless environment which means it has no memory regarding variables, etc. Each time you fire an event such as you button click it will make a round trip to the server (A postback) and render an entirely new version of the page unless you utilize server controls that have...

You can have the asp page in the .NET solution, but it should be its own project. John Pasko jpasko@telemetrysoft.com

passs, Try this: Add the User Control (<file>.ascx) as an existing object to the project you want to instantiate in. Make sure that you change the Namespace to the Namespace of your current project. Then declare the user control: protected UserControl <usercontrolname>; then add it to the...

Kris, The Assembly is going to be running on 2 servers (QA and PROD) so I will get the server names (Local Machine) as the UNC. John John Pasko john@rts-sd.com &quot;No matter where you go, there you are.&quot;

Kris, Thanks for the reply. I was just entering that I found the solution. I am using the Environment.MachineName property and this seems to have worked. Again, thanks for the response. John John Pasko john@rts-sd.com &quot;No matter where you go, there you are.&quot;

I need to capture the UNC for the Server I am running my app on to determine if it is a QA or PROD Environment. When I use the following code, I only get the drive path, not the actual server path. // Get the current directory. string path = Directory.GetCurrentDirectory(); I...

Thanks for your responses and the reading list. Take Care, John Pasko john@rts-sd.com &quot;No matter where you go, there you are.&quot;

Hi, If someone where to pursue and OO Language, would you recommend Java or C++ as a start? Thanks John Pasko john@rts-sd.com &quot;No matter where you go, there you are.&quot;

I have an Active Server Page that passes parameters used by a stored proc in a CR. The Main report has an On-demand Sub that uses the same stored proc but provides a parameter that was able to be null in the main. I am able to View the Main Report using the ActiveX Smart Viewer, but when I...

Try ZDNET in downloads. Do a search that is &quot;Access to VB convert&quot; -- Leave the quotes off. Good Luck John Pasko john@rts-sd.com &quot;No matter where you go, there you are.&quot;

CCLINT, It looks like the Client is already in place (Using VB) with an access mdb as the backend. Malicka has to upsize to SQL Server. Why rewrite it as an mdb when the Client code, forms etc is already in VB? This is what I gathered from the limited scope of info provided. :-) John Pasko...

Malicka, You don't necessarily have to convert over to ADO. MS SQL Server is backward compatible with DAO. It is recommended that you eventually migrate to ADO, but you can perform this in stages. The big issue will if you want to leverage SQL Server's full power and convert some of your...

Could be your driver. MS Access 97 is MS Jet 3.x, you're using JET 4.x. Good Luck, John Pasko john@rts-sd.com &quot;No matter where you go, there you are.&quot;

Is an error raised? If so what is it? Thanks John Pasko john@rts-sd.com &quot;No matter where you go, there you are.&quot;

What error is raised when you execute? Just off the top...is your Connection Object global? I see Conn.Open &quot;Provider...&quot; But I don't see Dim Conn As ADODB.Connection, etc John John Pasko john@rts-sd.com &quot;No matter where you go, there you are.&quot;

The &quot;Unleashed&quot; Series Sams is excellent. I use both the SQL Server and VB versions. John Pasko john@rts-sd.com &quot;No matter where you go, there you are.&quot;

Mean Green: Yes it does. Thanks for the feedback. John Pasko john@rts-sd.com &quot;No matter where you go, there you are.&quot;