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...
use this piece of code!
<a href="#" onMouseOut="MM_nbGroup('out');" onMouseOver="MM_nbGroup('over','cartoon2_r7_c12','../subimages/cartoon2_r7_c12_f2.gif','../subimages/cartoon2_r7_c12_f4.gif',1);"...
palmer...
there are a coupla ways you can do this... but it all comes down to one thing... the location of the text file you wanna open up!
if its on the client... you can actually use the File System Object to actually parse thru your text file and display the contents! again... here... you...
Hey Flasher....
You can execute 2 different javascript functions by seperating them with ';'!
You would replace your code with the one below... and replace the GOOGLE link with the one that you want to open in the new window...
<a href="#" onMouseOut="MM_nbGroup('out');"...
Hey peers...
well... the Q... all i need to do is write a parser that would be used to convert data from existing microsoft excel/word files to a SQL database...
this is what i have to do and am just starting off! i thought i'd gather a few inputs from you guys before actually getting into...
Hey sfenx...
Theres this option in IE using which you can apply your CSS on all the pages that are rendered by the browser.
Tools > Internet Options > Accessibility > User Style Sheet and specify the physical CSS that you might have!
Maybe getting into how IE does this might just give you a...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.