could someone show me some snippets on how to pass parameters to a stored 
procedure in a class module within a vb dll project?

thx

Inside Class module.....

Set dbConn = CreateObject("adodb.connection")
dbConn.Open sODBC, sUserName, sPassword

Set a_dbCmd = CreateObject("ADODB.Command")
a_dbCmd .ActiveConnection = dbConn

a_dbCmd .CommandText = "pSPAddCustomer" ' Stored Procedure Name .....
a_dbCmd .CommandType = 4

Set a_GetRS = a_dbCmd.Execute(lngRecsAffected, Array(a_First_Nm,a_Last_Nm))

Thanks
Ramesh



> could someone show me some snippets on how to pass parameters to a 
stored 
p> rocedure in a class module within a vb dll project?

> thx

hey guys can you help me?

I need to create a connection component with Active X.
So i will instance a DLL in ASP to get connection to my SQL Server 2000 
database

Example:
<%
Set DBConn = Server.CreateObject("ADODB.Connection")
DBConn.Open "driver=SQL Server;Server=MyServer;database=Northwind;uid=sa"
%>

I need to write this code with Active X

thanxs!

Create a new ActiveX DLL in VB and have something like

public sub DoSomething
dim objCon as adodb.connection

set objCon = new adodb.connection
objCon.Open "driver=....."

objCon.Execute "some sql..."

objCon.Close
set objCon = nothing

end sub

-----Original Message-----
From: Luis Yoshihira [mailto:lyoshihira@h...]
Sent: Friday, September 27, 2002 8:15 AM
To: ASP components
Subject: [asp_components] Re: passing parameters to a vb dll


hey guys can you help me?

I need to create a connection component with Active X.
So i will instance a DLL in ASP to get connection to my SQL Server 2000
database

Example:
<%
Set DBConn = Server.CreateObject("ADODB.Connection")
DBConn.Open "driver=SQL Server;Server=MyServer;database=Northwind;uid=sa"
%>

I need to write this code with Active X

thanxs!

%%email.unsub%%