Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

stored procedures

Status
Not open for further replies.

Delphin

Programmer
Nov 27, 2001
134
US
This may or may not be a simple question. I am running a TAPI program where everything is programed in VBA. I am sending this to a SQL Server 2000 db and would like to use my stored procedures that I am using in another interface. Is it possible to do this without creating a dll to accept it and then process it? Billy Ballard

For in the past, Lies the future.
 
Yup. Just use an ADO connection with the OLE DB SQL provider and use a command to pass the stored procedure to your db (check out the post marked Nikita6003: a SQL question for you ar ...) for more information.

ADO is a standard data connection source available as of Office97

Cheers
Nikki
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top