Sybase, MSACCESS and VB3.0 
Author Message
 Sybase, MSACCESS and VB3.0

We recently installed our first Sybase server and are beginning to
develop some small applications.  We are evaluating a number of GUI
application development tools (e.g., MS-ACCESS, MS-VB3.0, Powerbuilder,
etc), and have run into some problems with updating views.  We are aware
that Sybase has restrictions on updating views, and that updates may only
update columns that are in a single base table.  We assumed that updating
into view would involve writing some ACCESS/VB code to handle the multiple
tables, but it appears (this is clearly stated in the VB3.0 manual) that
whenever ACCESS/VB opens to a view (through ODBC) that its always read-only.
Can anyone give us some feedback on how they've gotten around this problem?

Thanks in advance....



Tue, 26 Dec 1995 22:54:40 GMT
 Sybase, MSACCESS and VB3.0


Quote:
>We recently installed our first Sybase server and are beginning to
>develop some small applications.  We are evaluating a number of GUI
>application development tools (e.g., MS-ACCESS, MS-VB3.0, Powerbuilder,
>etc), and have run into some problems with updating views.  We are aware
>that Sybase has restrictions on updating views, and that updates may only
>update columns that are in a single base table.  We assumed that updating
>into view would involve writing some ACCESS/VB code to handle the multiple
>tables, but it appears (this is clearly stated in the VB3.0 manual) that
>whenever ACCESS/VB opens to a view (through ODBC) that its always read-only.
>Can anyone give us some feedback on how they've gotten around this problem?

You should use DB-Lib that came with VB 3.0 to update view instead of
ODBC drivers.  ODBC drivers still have many limitations for Sybase SQL-Server
db admin. apps.  ODBC is good enough for decision support or data query
application.  You also should get better performance using db-lib.

Regards.  Thuyen



Wed, 27 Dec 1995 12:53:05 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. VB3/MsAccess locking

2. VB3 Pro / MSAccess Problems - HELP!!!

3. VB3 (yes, VB3!) database question

4. Sybase ODBC Call in VB4 and VB3

5. Error in ODBC setup for Sybase SQL Server (VB3)

6. VB3 to VB4 vs. VB3 to VB5

7. VB3 (yes, VB3!) database question

8. Sybase, MSAccess, ODBC, and PC-NFS

9. ODBC driver/MSAccess/Sybase

10. vb3 and Sybase 16 bit ODBC

11. GUI Programmer/Analyst VB3, Crystal, Sybase

12. Converting Sybase to MSAccess


 
Powered by phpBB® Forum Software