Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by boolean

  1. boolean

    ASP.Net worker debug process attachment nightmare!!!

    Guys... this is frustrating... you got to help to get through this situation here... i am into the support of an existing ASP.Net (with VB.Net) application here, and whenever there are issues, I want to step through the code to figure the whole flow out... but when I try attaching the ASP.Net...
  2. boolean

    Consolidating MS SQL Database: Things to remember?

    Thanks SQLsister, I had thought about most of the things you have laid out. The problem is just that most of the developers are not around! well... thats no big deal... as you said, it would just be all the more tedious and time-consuming... will keep you posted... but people... please do keep...
  3. boolean

    Consolidating MS SQL Database: Things to remember?

    Hi, My current assignment involves the Consolidation of 2 MS SQL 2000 database Servers into one. Most of the work that hsa been done here have been by temporary programers, who seem to have developed a lot of spread-out applications. There is a lot of redundancy and things have to be sorted out...
  4. boolean

    Consolidating MS SQL Database: Things to remember?

    Hi, My current assignment involves the Consolidation of 2 MS SQL 2000 database Servers into one. Most of the work that hsa been done here have been by temporary programers, who seem to have developed a lot of spread-out applications. There is a lot of redundancy and things have to be sorted out...
  5. boolean

    INSERT with SELECT in mySQL

    thanks boogie... well... i have not really worked on Mysql as much as the other drivers... why dont you tell me how to go about it? and FYI the apps using inline queries... can the 2 steps done together in 1 query?? Sham aka boolean... be practical/be straight... true/false?!
  6. boolean

    INSERT with SELECT in mySQL

    Hey pals... Why wouldn't this query work in MySQL?: INSERT INTO PAGE ( PAGE_ID, PAGE_NAME, PAGE_LOCATION ) SELECT 2, PAGE_NAME, PAGE_LOCATION FROM PAGE WHERE PAGE_ID=1; I just want to replicate the records for PAGE_ID=1... If this wouldn;t work, can anyone gimme a work around...
  7. boolean

    MTS compatibility with ORACLE database

    and yeah.... do remember that your dataAccessComponent must use the Oracle Data Provider for .Net! Sham aka boolean... be practical/be straight... true/false?!
  8. boolean

    MTS compatibility with ORACLE database

    Sujay... you'd maybe care to look at my post in this same thread on Mar 2, 2003?? guess that would help... dont you swear if it didnt... Sham aka boolean... be practical/be straight... true/false?!
  9. boolean

    MTS compatibility with ORACLE database

    Hey... The problem is indeed with the OraMTS... The Oracle Services for MTS allow customers to use Oracle databases as resource managers in MTS-coordinated transactions, providing strong integration between Oracle solutions and MTS. The Oracle Services for MTS act as a proxy for the Oracle...
  10. boolean

    MTS compatibility with ORACLE database

    guys... i' like to reopen this issue here! how do i get distributed transactions to work in my application with ASP.Net/VB.Net/ORACLE??Thanks!! Sham aka boolean... be practical/be straight... true/false?!
  11. boolean

    ADO.Net & MySQL: OleDbCommand object with partameters fails to execute

    hey paul... thanks for the time... but then... i cant really use named parameters! Essentially, we are into an application that is being customized to work on 3 engines - MSSQL, ORACLE and MySQL. We have crafted a middle-layer between the business logic and data access that would make the...
  12. boolean

    ADO.Net & MySQL: OleDbCommand object with partameters fails to execute

    the query when run directly in mysqlfront would throw an error... no doubt about that... but how do you pass parameters to the SQL statement in MySQL? say... in my screen... i have to pick up the details of a particular user from the db... normally in MSSQL or ORACLE, i would either write a SP...
  13. boolean

    ADO.Net & MySQL: OleDbCommand object with partameters fails to execute

    Guys... I had even tried downloading the native MySql Data provider from CoreLab! same problem... But this time around I get a [ An unhandled exception of type 'CoreLab.MySql.MySqlException' occurred in corelab.mysql.dll Additional information: You have an error in your SQL syntax near '?' at...
  14. boolean

    ADO.Net & MySQL: OleDbCommand object with partameters fails to execute

    Yeah... have been trying to use ADO.NEt with MySQL and i havent really been very successful! Heres what i do... ' Dimension them all.... Dim OleDbCmd As New OleDb.OleDbCommand() Dim OleDbCnn As New OleDb.OleDbConnection() Dim _SqlText, _ConnectionString As String Dim objDatadrd As IDataReader...
  15. boolean

    ADO.Net & MySQL: OleDbCommand object with partameters fails to execute

    Yeah... have been trying to use ADO.NEt with MySQL and i havent really been very successful! Heres what i do... ' Dimension them all.... Dim OleDbCmd As New OleDb.OleDbCommand() Dim OleDbCnn As New OleDb.OleDbConnection() Dim _SqlText, _ConnectionString As String Dim objDatadrd As IDataReader...
See more

Part and Inventory Search

Back
Top