Recent content by boolean

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...

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...

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...

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...

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?!

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...

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

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?!

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...

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?!

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...

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...

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...

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...

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...