Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-08-31 : 07:15:20
|
| magads writes "What are Temporary stored procedures?I wanted to know why some times Connection.BeginTransaction does not work in VB6.0 when connected to SQL Server 2000." |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2005-08-31 : 12:03:48
|
| I've never heard of "Temporary stored procedures". It seems to me that if they're temporary, then they're not really stored. Is that some new term that has been coined to refer to parameterized queries? Doesn't make any sense to me.We would need more background on your code and examples of when Connection.BeginTransaction does and does not work. But I'd encourage you to consider using SQL Server's native transaction handling instead of doing that from your Connection object.---------------------------EmeraldCityDomains.com |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-09-01 : 01:13:43
|
| >>I wanted to know why some times Connection.BeginTransaction does not work in VB6.0 when connected to SQL Server 2000."What error you got?Make sure you opened the connection properlyMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
SQL Server 2000