RemoteData Example

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
LVL 1
wittyAsked:
Who is Participating?
 
mcixConnect With a Mentor Commented:
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
 
mcixCommented:
What kind of database is this?
0
 
wittyAuthor Commented:
it should run on mssql and centura!
wiity
0
The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

 
wittyAuthor Commented:
it should run on mssql and centura!
witty
0
 
mcixCommented:
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
 
wittyAuthor Commented:
OK - but what's the different between DATA and MSRDC - object?
0
 
mcixCommented:
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
 
wittyAuthor Commented:
Can I use DATA - object for access to CENTURA Databases via ODBC?

witty
0
 
mcixCommented:
Do you mean SQLBase?
0
 
mcixCommented:
According to Centura, the answer is yes!

Look @

http://www.centurasoft.com/products/sqlbase/white/sqlconn.html
0
 
wittyAuthor Commented:
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
 
mcixCommented:
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
 
wittyAuthor Commented:
hey you helped me!

if you wanna points write a "answer" - or should I delete the question ;-) ?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.