Calling stored procedures from SQL Server in VB code 
Author Message
 Calling stored procedures from SQL Server in VB code

How can I execute an SQL Server stored procedure from VB without using the
RDO method?



Mon, 18 Dec 2000 03:00:00 GMT
 Calling stored procedures from SQL Server in VB code

Effie,

 You can also use ADO, native ODBC, VBSQL (vbx or ocx) or any of the
other data access methods MS supplies - you have to use one of them
though.

 Neil Pike MVP/MCSE
 Protech Computing Ltd



Tue, 19 Dec 2000 03:00:00 GMT
 Calling stored procedures from SQL Server in VB code



Quote:
> How can I execute an SQL Server stored procedure from VB without using
the
> RDO method?

If you really don't want to use any of the layers that
Neil has listed, you can still run ISQL.EXE through VB's
Shell command. This is just for completeness, I don't
suggest you to use this method.

Best regards,
--
Gianluca Hotz                                __
Technical Service Manager at Alphasys srl   /  \/ /
MCP Windows & MCP + MVP SQL Server         / /\/ /
Currently working for Ekar spa             \ \/ /\
http://ghotz.home.ml.org                    \__/\ \



Fri, 22 Dec 2000 03:00:00 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. ANNOUNCE : dbcodegen.com - Tool to generate C# code to call SQL Server Stored Procedures

2. ANNOUNCE : dbcodegen.com - Tool to generate C# code to call SQL Server Stored Procedures

3. Calling Oracle Stored Procedure from within SQL Server Stored Procedure

4. Calling SQL Server stored procedure with parameters using ADO in VB

5. VB (ADO) calling stored procedures in SQL server 2000

6. Calling Crystal Report from VB, repo is based on Stored Procedure in Sql Server

7. Calling Stored Procedure that calls Stored Procedure in ASP

8. How to call an Oracle Stored procedure from MSSQL Server Stored Procedure

9. Calling a stored procedure on another server from within a stored procedure

10. Calling 8i Stored Procedure From ASP with ADO Slower than Hard-Coded SQL String

11. Calling Java Stored Procedure from SQL Stored Procedure

12. TimeOut with VB 6 call to SQL 7.0 Stored Procedure


 
Powered by phpBB® Forum Software