[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 294
  • Last Modified:

INVOKE STORED PROC IN VB6

i need to create an application that invokes a stored procedure.
The stored proc synchronises two databases.  So my question is, should i give connectionstring of both databases that the stored proc use to synchronise or only the connectionstring of the db that the stored proc reside on in my vb code?
0
AnnaJames77
Asked:
AnnaJames77
  • 2
1 Solution
 
gplanaCommented:
As you just have to call your stored procedure, you need just a connection to the database who has the stored procedure.

Here you have a link explaining how to call to a stored procudure from VB6:

http://www.codeproject.com/KB/vbscript/simple_sp_vb6.aspx

Hope it helps.
0
 
AnnaJames77Author Commented:
Thankyou gplana for your reply.
0
 
gplanaCommented:
You are welcome.

Thank you for your rating. Good luck !
0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now