Re: Create Storedprocedure with VB6? Is this possible?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I don't want to use a third party tool.
Is there any way I can create a storedprocedure
from a VB6 Application. Or can itbe done another way,
I do not want to use .Net

TIA

Sam


"William Vaughn" <billvaNoSPAM@xxxxxxxxx> wrote in message
news:3DB62B88-E5C2-4F75-9D49-11E5F033AE9B@xxxxxxxxxxxxxxxx
Sure. I have examples in all of my Hitchhiker Guide books.
Basically, you can create and execute an SQL query that includes the
CREATE PROCEDURE call.
I don't think the VB6 IDE itself could create a stored procedure, but
there are lots of other tools that will. SQL Server Enterprise Manager can
and so can SQL Server Management Studio (there's even a free Express
version).

hth

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant, Dad, Grandpa
Microsoft MVP
INETA Speaker
www.betav.com
www.betav.com/blog/billva
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no
rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
-----------------------------------------------------------------------------------------------------------------------

"sam" <sam@xxxxxxxxxx> wrote in message
news:eb%23upnA0HHA.5152@xxxxxxxxxxxxxxxxxxxxxxx
Can a Storedprocedure be created using code in VB6?

If so how?

Is there some sample code?

TIA

Sam




.

Relevant Pages

  • Re: Create Storedprocedure with VB6? Is this possible?
    ... Is there any way I can create a storedprocedure ... from a VB6 Application. ... Call the connection's Execute method, ... can and so can SQL Server Management Studio (there's even a free Express ...
    (microsoft.public.vb.database.ado)
  • Re: Create Storedprocedure with VB6? Is this possible?
    ... VB6 and ADO no .NET ... can SQL Server Management Studio." ... Can VB6 create a stored procedure on the fly. ... something similar) exactly what you're sending to the db engine (via ADO), ...
    (microsoft.public.vb.database.ado)
  • Re: T-SQL and OLE Automation
    ... A library created as type ActiveX.exe will run out of the SQL Server ... To deploy a .dll, you make it, using the VB6 file/make command, then copy to ... Creating COM libraries with VB6 is probably better discussed in a VB ... > OLE automation and I'm not sure how to write the application on the VB6 ...
    (microsoft.public.sqlserver.programming)
  • Re: T-SQL and OLE Automation
    ... components from VB6 now that VB.Net is so well established as that code will ... Choose a path to save the .dll & remember where it is. ... If you are running your SQL Server on that machine, ... >> Greg Linwood ...
    (microsoft.public.sqlserver.programming)
  • Re: Compact SQL Database and ADO
    ... SQL Server 3.5 Compact 3.5 SP1 Database ... Set prmID = .CreateParameter("plngID", adInteger, ... Set prmText = .CreateParameter("pstrText", adVarWChar, ... VB6 to crash. ...
    (microsoft.public.data.ado)