Hi..
Could you please send me the sample code on how to pass sqltransaction to sql helper class..
bcoz as i know i need to declare sqltransaction in aspx form & then i need to pass which is not a good approach in 3-tier..
so please suggest me, if u have some sample code..please send me...
Thanks in Advanced
Abdul Javed Khan
Hi I am building 3 tier application using ASP.NET and i am using sqlhelper class in Data Access Layer..now my question is "How to make use of sqltransaction using sqlhelper class.."means i want to make use of sqltransaction object for concurrency control...but since i m new to sql helper. that's why i am not able to do this... Please solve my problem by giving some sample code..so that i can understand the code & implement in my application.... Thanks in Advance...Abdul Javed Khan
View 9 Replies View RelatedLet's face it - setting up SQL 2005 merge pull replication using HTTPS between numerous SQL Server 2005 Express clients and one or more Publishers is an overly complicated exercise.
It should be easy. Why is it so hard?
In a nutshell: The connection chain and security chain is long and when there's a problem the error messages just don't point you to the answer - You have to search for it;re-read the doco; talk to gurus; use logging tools;re-read the error message 100 times; etc. etc.
It should be possible to create a 'Replication Configuration Helper' that steps -step by step - through both the connection chain (App - to SQL Express - to local network components - to the TCP/IP network - to the web server - to the publishers/distributers) and through the security chain (App - to SQL Express authentication - local agents including certificate errors - to ISS server authentication - to Distributer authentication -to Publisher authentication to Article authentication).
Let's face it - the steps occur in sequence and each step can be tested and the appropriate error message raised - TOGETHER WITH INSTRUCTIONS ON HOW TO RESOLVE! (I mean - what's use is an error message when you have to cut and past the error message into a browser and search for ages before you get the instructions on how to resolve the problem?)
So c'mon - someone volenteer to write a 'Replication Configuration Helper'
Hi,
I am trying to retrieve a value from a SQL Server table based on the results of a datareader.This is the string i am trying to create
Me.ViewState("Make") = SqlHelper.ExecuteScalar(MyConnectionString, "usp_GetMake", (dr("MakeID")).To String)
Im not sure of the syntax as I know that it is basically using two different ways of reading a database.Is there an equivalent for the datreader which can be used with SQL Helper?
Thank you for your help
Julie
Hi,
Couple questions regarding SQL Server Active Directory Helper service:
a)What is its purpose?
b)Where can I get more detailed information about this service and
SQL Server 2005 services in general?
c)How can the following error during start up phase of this service
be avoided?
Error Message:
'0' is an invalid number of start up parameters. This service takes two start up parameters.
FYI: SQL Server 2005 is run on Windows XP professional.
Thanks,
Mike
I just installed a copy of sql2005 express, and need to use windows authentication. the ad helper service bombs on startup, any helpfull suggestions would be appreciated.
thanks
On a fairly new install of SQL 2005 64-bit, upon bootup the Active Directory Helper Serivice is aborting with the error 3221225572 (0XC0000064). When an attempt is made to start the service manually the following error appears: "Windows could not start teh SQL Server Active Directory Helper on Local Computer. For more infromation, review the System Event Log. If this is a non-Microsoft service, contact the service vendor, and refer to the service-specific error code - 1073741724."
The service is strating up under the network services account, which I am suspicous may be a problem. Currently the SQL server is running under SQL 2005 SP2 with no post service pack hotfixes. Do you have any advice on how to get the service to launch without errors?