ASTrace Utility on x64 server

Hi,

I’m testing the new ASTrace service and when I’m running it on my own personal notebook it runs just

fine.

The problem starts when I try to run the service in a x64 environment. The service installs properly,

but when I try to start it, it fails.

Looking at the log file the service writes to, I noticed that the service looks for files on the path:

C:\Program Files\Microsoft SQL Server\90\Tools\Binn\

However, being an x64 server, all those files are located on:

C:\Program Files(x64)\Microsoft SQL Server\90\Tools\Binn\

Is there any way I can point the service to look for the files in the x64 folder?

Thanks,

Yaniv

I would report this issue here as they seem to be pretty responsive:

http://www.codeplex.com/MSFTASProdSamples/WorkItem/List.aspx

Note that Codeplex is having some downtime currently, but I'm sure it will be back up in the next few days.

|||

Which file(s) is it looking for?

If it is only the Microsoft.SqlServer.ConnectionInfo.dll file, then you could try copying this file from the (x64) folder into the same folder where you installed ASTrace. I'm not sure if this works for a service, but it often does for a win forms app (it depends a bit on how the reference has been made)

I would still ask on the connect site, but this might get you up and runinng in the short term.

|||

Thanks Darren,

The file is PFCLNT90.dll, which I have tried to copy, but it still complained about this file and “other dependency” files missing.

I figured I don’t want to start copying the entire directory...

Appreciate your help!

ASP.NET Wizard + Stored Procedure

HI,

I have created a wizard control to collect user informations.

First step : Personal informations

Step Two : Educational informations

After user completed and click finish button I want to add Personal informations to 'Personal' table in my sql server database.

And also Educational information in to 'Educational' table.

Using Stored Procedure (here it is)

CREATE PROCEDURE dbo.StoredProcedure1

@.Fname varchar(10),

@.Lname varchar(10),

@.Email varchar(50),

@.Tel varchar(20)

AS

INSERT INTO Personal (Fname, Lname, Email, Tel)

VALUES (@.Fname, @.Lname, @.Email, @.Tel)

RETURN

So Now I want to add another stored procedure for Educational table.

How do I do this.Should I modify this.

But Educational info should goes to 'Educational' table not to 'Personal'

How do I chieve this.

Thanks

I do not know how much information you have from another step, but you can do everything in one stored procedure call. Just add parameters from your next wizard step and do insert into 2 tables at one shot in one stored procedure with two insert statement. This way you can link this records if you have any relations between your tables.

Thanks