Wrox Home  
Search P2P Archive for: Go

  Return to Index  

asp_database_setup thread: problem with dll and db connection


Message #1 by "jussi rämö" <jusa19@h...> on Mon, 27 Aug 2001 11:30:29
I cannot make dll file with vb. I get permission denied. I gave 

permissions to IUSER_NAME. Is the right order to make active dll like this?



Make dll

regsvr active.dll

regsvr active.dll \u

make active.dll...



i tried to delete my dll file also, but keep getting destination file may 

be in use messge. ism and sql server were stopped and all projects were 

closed. Reason i asked this is that I keep getting error message like 

this. I installed MDAC 2.6 already. Could the reason for error be with dll 

file.



Microsoft OLE DB Provider for ODBC Drivers error '80004005' 



[Microsoft][ODBC SQL Server Driver][Named Pipes]Specified SQL server not 

found. 



/JoCoffee_Local/admin/default.asp, line 18



Here are lines 16 - 21



Dim NewDepartmentID

   if Request("departmentidp") = "" then

      NewDepartmentID = Visit.Catalog.AddDepartment(Request("name"))

   else

      NewDepartmentID = Visit.Catalog.AddDepartment(Request("name"), _

                        Request("departmentidp")



here is some of my site.asp code...



   ' Do we have one?

   If IsEmpty(m_visit) Then



      ' Create an instance of a Visit object...

      Set m_visit = Server.CreateObject("WroxCommerce.Visit")

      

      m_visit.Configure g_sitename, g_domainname, "driver=SQL Server;" & _

                        "DATABASE=JoCoffee;UID=JoCoffeeWeb;PWD=eermlate;" 

& _

                        "SERVER=localhost"

      

   End If





Message #2 by "Gerhard Wentink" <data@w...> on Mon, 27 Aug 2001 16:08:11 +0200
Most of the time it is necessary to restart IIS after unregestering a dll.

I hope this helps



Regards,



Gerhard Wentink

----- Original Message -----

From: "jussi rämö" <jusa19@h...>

To: "ASP Database Setup" <asp_database_setup@p...>

Sent: Monday, August 27, 2001 11:30 AM

Subject: [asp_database_setup] problem with dll and db connection





> I cannot make dll file with vb. I get permission denied. I gave

> permissions to IUSER_NAME. Is the right order to make active dll like

this?

>

> Make dll

> regsvr active.dll

> regsvr active.dll \u

> make active.dll...

>

> i tried to delete my dll file also, but keep getting destination file may

> be in use messge. ism and sql server were stopped and all projects were

> closed. Reason i asked this is that I keep getting error message like

> this. I installed MDAC 2.6 already. Could the reason for error be with dll

> file.

>

> Microsoft OLE DB Provider for ODBC Drivers error '80004005'

>

> [Microsoft][ODBC SQL Server Driver][Named Pipes]Specified SQL server not

> found.

>

> /JoCoffee_Local/admin/default.asp, line 18

>

> Here are lines 16 - 21

>

> Dim NewDepartmentID

>    if Request("departmentidp") = "" then

>       NewDepartmentID = Visit.Catalog.AddDepartment(Request("name"))

>    else

>       NewDepartmentID = Visit.Catalog.AddDepartment(Request("name"), _

>                         Request("departmentidp")

>

> here is some of my site.asp code...

>

>    ' Do we have one?

>    If IsEmpty(m_visit) Then

>

>       ' Create an instance of a Visit object...

>       Set m_visit = Server.CreateObject("WroxCommerce.Visit")

>

>       m_visit.Configure g_sitename, g_domainname, "driver=SQL Server;" & _

>                         "DATABASE=JoCoffee;UID=JoCoffeeWeb;PWD=eermlate;"

> & _

>                         "SERVER=localhost"

>

>    End If

>

>


  Return to Index