by Ko Lam N » Sat, 09 Aug 1997 04:00:00
I heard that System 11/ODBC 3.0 have not been adapted for use with
Microsft's VB 4.0 and 5.0's RDO data access method. Can someone confirm
this? Has anyone been able to successfully (error-free) use VB's RDO to
access a System 11 database with stored procedures? We are experiencing
several problems with passing parameters to stored procedures.
--
The opinions expressed in this message are my own personal views
and do not reflect the official views of Microsoft Corporation
1. Sybase 11 Server and Intersolv ODBC drivers 3.0
Dear All,
Does anyone use Sybase Server 11 (11.0.2.1) with Intersolv's ODBC version
3.0 drivers. I have this setup on Windows NT 4.0 Server (Service Pack 2)
and I get an error message saying that stored procedure Sp_SeRvEr_InFo not
found (note the case!!). This error occurs with both MSQuery32 and Visual
Basic 5.0. I have found this error only occurs when I specify the database
when connecting (if it is not specified, that is the default is used there
is no problem connecting even the default is the same as the one I was
specifying). Another thing to note is this problem does not occur with the
Intersolv 2.12 drivers. When I connect with WISQL or Intersolv 2.12
drivers I can quite happily execute the stored procedure sp_server_info
without any problem.
To summarise:
Sybase Server 11 (11.0.2.1) and Intersolv ODBC Drivers 3.0 produce the
error Sp_SeRvEr_InFo not found when a database is specified when
connecting.
Any help appreciated
Allan Taunt
Global Information Solutions
Christchurch
New Zealand
2. New install: Fatal ASF_INIT_DATA error on initialization
3. VB 4.0 and SQL Server 11.0.2 using RDO
4. Parameters in Stored Procedures
5. vb4 RDO, intersolv odbc, and Sybase system 10
7. Can't connect to Sybase System 11 w/ Intersolv v3.0
8. SQLNet v1 and 7.3 any work arounds?
9. Q: How to connect to System 11 and SQL Anywhere from VB 4.0
10. LONDON - VB 5.0/Sql-Server 6.5/ NT 4.0 - Developers - Derivatives Trading Systems