VB and Sybase SQL

VB and Sybase SQL

Post by P. van Leeuwe » Sat, 29 Jun 1996 04:00:00

I used Sybase SQL Anywhere 5.0 to create a database with one table.
The page size of the Database is 2048 (I have also used page sizes of
1024 and 512) and the table consists of 12 columns and approximately
9000 rows. Everything works fine when I access the database using Sybase
Interactive SQL interface on the same computer as the SQL server, so I
know the database works.

My problem is with my Visual Basic interface. I use the Remote Data
Control to access the Database Firstly it opens another instance of the
server, although there is one currently running. The biggest problem is
that I am denied access to the database with the error message:


Can anyone please tell me what am I doing wrong?

I use VB 4.0 Enterprise Edition on a 486DX50 machine.

Pierre van Leeuwen



Contract positions immediately available in the New Jersey area, Sub-
contractors are welcome:

                - Full-time
                - Long-term and/or ongoing contracts
                - Compensation, commensurate with experience
                - We provide VISA assistance.
                C                   C++     DBLib
                CTLIB               Sybase  Visual C++
                Open server/Open client     Unix            VB

Send all correspondence to the following:

Nagender Rao
Unicom Systems & Consultants Inc.
609-799-2756 (voice)
609-897-0647 (fax)
609-275-0243 (evening)

Compuserve Id  75273,3015.(USE PRIVATE EMAIL for resumes and messages.
We prefer MS Word/text format)
Currently seeking consultants for the following:

                - C/C++/Unix/Sybase application developer with        
                  experience using DBLibrary and CTLIB, Open server and
                  open client programming.(3 positions)

                - Unix and NT administrators with C Programming        
                  background. (Sun/unix)

                - Sybase DBA's and system administrators. Solaris a
                  plus.(2 positions)

                - UNIX Solaris system administrators.

                - 32 bit Visual C++ developers with MFC/OLE. Sybase is
                  a plus.(3 positions)

                - Strong Visual Basic/OLE/SYBASE SQL                  

                - Power Builder(object oriented programming) with      
                  Oracle database. Oracel PL/SQL, Stored              
                  procedures/triggers,packages expertise.

                - Unix/C++ Developers with multithreading and          
                  semaphores experience.


2. Is this a FAQ? Clustered vs non Clustered Index

3. SYBASE SQL Anywhere and VB 4 and 5

4. How to permanantly erase deleted records ?

5. Sybase SQL Server / VB ODBC GPF!!!

6. Exporting decision tree

7. VB, ODBC, Sybase System 10, and Dynamic (real) SQL

8. How can I determine the SQL server name from a connection object?

9. VB Sybase/SQL Server Stored Procs Question

10. Sybase 11 SQL to VB 5

11. Accessing Sybase SQL Anywhere server from VB problem

12. VB, rdo, and Sybase SQL Server 11.5