Solved

RemoteData Example

Posted on 1998-08-20
13
192 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
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Introduction I needed to skip over some file processing within a For...Next loop in some old production code and wished that VB (classic) had a statement that would drop down to the end of the current iteration, bypassing the statements that were c…
This article describes some techniques which will make your VBA or Visual Basic Classic code easier to understand and maintain, whether by you, your replacement, or another Experts-Exchange expert.
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
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…

756 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