Help needed with method for SQL

I have been using VB6 for a long time now and had no problems using ADODB.Recordset.

I had a module to which I would send my recordset (byref) and the SQL command (byval) and use the resultant recordset for adding, modifying or deleting records.

How can I do the same with VS2005? This is a major problem as there are dataadapters, grids, datareaders etc.

Does someone have a simple method to get the recordset so that I can modify the record using the code (eg: .Addnew/.Delete/.Update) and Close the connection?

Please note that I do not need to display anything and have to run 40/50 AddModDel for every click of the program.

Any help is greately appreciated. Thanks in Advance.:: Bump ::
Is there a solution?

Help needed on SQLServer , Error 18456

Hi All,

I have tried accessing a remote database in one of by stored procs using linked servers and also using OpenDataSource method.
In both the cases , I am getting login failed error.

Following is the stored proc :

CREATE PROCEDURE TEST AS

SELECT *
FROM OPENDATASOURCE(
'SQLOLEDB',
'Data Source=blrkec3432s;User ID=xyz;Password=xyz').LMC.dbo.STATE
GO

It works fine if the userid is 'sa'

Could anyone please tell me the reason for this.

Thanks,
ShanthiResolution from SQLMAG link (http://www.winnetmag.com/SQLServer/Article/ArticleID/8992/8992.html)

Help me with DB schema comparison method

Hi!
can some one help me guide to knwo as to how do we compare teh database schemas of two databases.. i mean in case i have to compare the schema of 2 ole dbs or 2 sql databases then i can do it using teh XML schema \ and compare but then in case i need to compare a SQL schema and a oledb schema then how do i go about it.. since the long datatype in ms access ( using ole db) is text in SQL and tiny int is int16... there are some other discripancies liek that. So how do i go about checking teh database schemas for such disperate DBs. Can soem one tell me some site or give soem guidance in this regard. Please help me as i need it for my project where i need to compare teh schema and alert when they are not compatible.. Please help...thanks in advance..

regards,
GautamDo you have microsoft visio available to you? It can reverse engineer your database to output a great map for you to review.|||hey crispy!!!
That did not help me in anyway...please suggest somethign good... by the way .. i am sorry i did not use visio tool before.

Thanks anyway
Gautam