Solved

RemoteData Example

Posted on 1998-08-20
13
185 Views
Last Modified: 2010-04-30
I'm new to RemoteData.
I want to write an application connecting using an ODBC-connection. The thing I want is only to see the result of a given SQL-Statement in a table, edit the data in table and delete and insert new rows and write them to the DataBase.
Can I also work with rollback and commit??
Perhaps you can send me a short example!!!

thanx
witty
0
Comment
Question by:witty
  • 7
  • 6
13 Comments
 
LVL 4

Expert Comment

by:mcix
ID: 1430052
What kind of database is this?
0
 
LVL 1

Author Comment

by:witty
ID: 1430053
it should run on mssql and centura!
wiity
0
 
LVL 1

Author Comment

by:witty
ID: 1430054
it should run on mssql and centura!
witty
0
 
LVL 4

Expert Comment

by:mcix
ID: 1430055
Check into:

http://backoffice.microsoft.com/downtrial/moreinfo/sqldrk.asp

Download the ADO and SQL Server Developer’s Guide

There is a sample project in the Zip

0
 
LVL 1

Author Comment

by:witty
ID: 1430056
OK - but what's the different between DATA and MSRDC - object?
0
 
LVL 4

Expert Comment

by:mcix
ID: 1430057
1. Basically, the Data object uses the JET engine to access a database.  While it is possible to connect to other data sources, such as Excel, FoxPro, dBase, etc... It is usually used to manipulate an Access database.  This is commonly referred to as DAO or Data Access Objects.

2. The Remote Data Control encapsulates RDO or Remote Data Objects.  At one time, this was the method used to access ODBC data sources (for bound controls).  With VB5 and now 6, MS has introduced ADO, Active Data Objects and more recently OLEDB and UDA, universal data access.

It seems that the future will be in ADO using an OLEDB provider will be the future (for now anyway).

These are the general guidelines we use:

1. If you know you only need to go at Access use DAO/JET.  
2. If you are considering porting or combining Access and SQL Server, use RDO.  
3. If you only need SQL Server or some other ODBC/OLEDB data source, use ADO.
4. If you don't know, start with DAO and work your way up.

After writing several apps, using all of the above mentioned, it really depends on what your target database is.  In our shop, we use the one that fits the task at hand.

By the way, did the article help you?
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
LVL 1

Author Comment

by:witty
ID: 1430058
Can I use DATA - object for access to CENTURA Databases via ODBC?

witty
0
 
LVL 4

Expert Comment

by:mcix
ID: 1430059
Do you mean SQLBase?
0
 
LVL 4

Expert Comment

by:mcix
ID: 1430060
According to Centura, the answer is yes!

Look @

http://www.centurasoft.com/products/sqlbase/white/sqlconn.html
0
 
LVL 1

Author Comment

by:witty
ID: 1430061
thanks
one last question:
VB 5.0: what can be wrong when i get a connection to a mssql database (I see the data in the grid-table), but i can't edit the data and add new rows!
it looks like the database is readonly - but it isn't. I think there must be a simple reason for this!!

thanks witty
0
 
LVL 4

Expert Comment

by:mcix
ID: 1430062
A couple of things here, possibly...

Starting with the obvious properties of the DBGrid and MSRDC Controls (You are using the controls?):

1. Right Click on the Grid and Select Properties.
2. By Deafult, AllowAddNew and AllowDelete are not checked in the general tab.
3. Read-Only Property of the MSRDC is set to true.

These were just off the top of my head and I'm sure you've found them by now...

0
 
LVL 1

Author Comment

by:witty
ID: 1430063
hey you helped me!

if you wanna points write a "answer" - or should I delete the question ;-) ?
0
 
LVL 4

Accepted Solution

by:
mcix earned 150 total points
ID: 1430064
Hey Witty, long time no hear... Hope things are moving along for you.  I am glad to have helped you...

If you need more help, just e-mail me

marko_justus@hotmail.com

so we can be more direct without having to check these questions all the time...
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
String manipulation in Visual Basic 7 59
MsgBox 2 47
maro to copy and paste from one worksheet to another based on a condition 11 47
Excel Automation VBA 19 30
Introduction While answering a recent question (http://www.experts-exchange.com/Q_27402310.html) in the VB classic zone, I wrote some VB code in the (Office) VBA environment, rather than fire up my older PC.  I didn't post completely correct code o…
You can of course define an array to hold data that is of a particular type like an array of Strings to hold customer names or an array of Doubles to hold customer sales, but what do you do if you want to coordinate that data? This article describes…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now