Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 200
  • Last Modified:

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
0
witty
Asked:
witty
  • 7
  • 6
1 Solution
 
mcixCommented:
What kind of database is this?
0
 
wittyAuthor Commented:
it should run on mssql and centura!
wiity
0
 
wittyAuthor Commented:
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!

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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 7
  • 6
Tackle projects and never again get stuck behind a technical roadblock.
Join Now