p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

asp_databases thread: Global.asa not working


Message #1 by "Dominic" <jfdbp@h...> on Tue, 11 Jul 2000 16:11:18
Help



I have specified a system dsn in my Global.asa file but when I try to 

access it from within an ActiveX dll that I have coded in VB6, it does not 

work. I have read somewhere that the root folder that the Glbal.asa file 

resides in must have the execute option enabled, but this does not seem to 

work either..



Can anyone help



Dominic Brooke-Pestell

Message #2 by "Joe Sabado" <joe.sabado@g...> on Tue, 11 Jul 2000 09:16:04 -0700
what's your referencing code in VB6?



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

From: Dominic 

To: ASP Databases <asp_databases@p...>

Sent: Tuesday, July 11, 2000 4:11 PM

Subject: [asp_databases] Global.asa not working





> Help

>

> I have specified a system dsn in my Global.asa file but when I try to

> access it from within an ActiveX dll that I have coded in VB6, it does not

> work. I have read somewhere that the root folder that the Glbal.asa file

> resides in must have the execute option enabled, but this does not seem to

> work either..

>

> Can anyone help

>

> Dominic Brooke-Pestell

>
Message #3 by "Dominic Brooke-Pestell" <jfdbp@h...> on Tue, 11 Jul 2000 19:23:50 +0100
Hi Joe



The VB code I am using to refernece the connectstring variable is:



' Code taken from Wrox VB6 Web development



With m_objConn



    .ConnectionTimeout = CInt(m_Session("Connectiontimeout"))

    .CommandTimeout = CInt(m_Session("Commandtimeout"))

    .Open m_Application("connectionstring")



End With





My global.asa file is where I have set these session and application

variables, using the Session_onstart and Application_onstart methods.





Many Thanks in advance



Dominic









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

From: Joe Sabado 

To: ASP Databases <asp_databases@p...>

Sent: Tuesday, July 11, 2000 5:16 PM

Subject: [asp_databases] Re: Global.asa not working





> what's your referencing code in VB6?

>

> ----- Original Message -----

> From: Dominic

> To: ASP Databases <asp_databases@p...>

> Sent: Tuesday, July 11, 2000 4:11 PM

> Subject: [asp_databases] Global.asa not working

>

>

> > Help

> >

> > I have specified a system dsn in my Global.asa file but when I try to

> > access it from within an ActiveX dll that I have coded in VB6, it does

not

> > work. I have read somewhere that the root folder that the Glbal.asa file

> > resides in must have the execute option enabled, but this does not seem

to

> > work either..

> >

> > Can anyone help

> >

> > Dominic Brooke-Pestell

> >

Message #4 by "Frankie, Loh Teck Seng" <lohts@p...> on Wed, 12 Jul 2000 22:31:47 +0800
Greeting;



	I have tried on the sample given by

Wrox and it worked. What I did was stored

the Global.asa inside the project folder

of the wwwroot folder.



	I don't know whether what I did is

correct but it worked. Perhaps someone can

comment on the correctness of these approach.



	Thanks.





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

From: Dominic Brooke-Pestell 

Sent: Wednesday, July 12, 2000 2:24 AM

To: ASP Databases

Subject: [asp_databases] Re: Global.asa not working





Hi Joe



The VB code I am using to refernece the connectstring variable is:



' Code taken from Wrox VB6 Web development



With m_objConn



    .ConnectionTimeout = CInt(m_Session("Connectiontimeout"))

    .CommandTimeout = CInt(m_Session("Commandtimeout"))

    .Open m_Application("connectionstring")



End With





My global.asa file is where I have set these session and application

variables, using the Session_onstart and Application_onstart methods.





Many Thanks in advance



Dominic









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

From: Joe Sabado

To: ASP Databases <asp_databases@p...>

Sent: Tuesday, July 11, 2000 5:16 PM

Subject: [asp_databases] Re: Global.asa not working





> what's your referencing code in VB6?

>

> ----- Original Message -----

> From: Dominic

> To: ASP Databases <asp_databases@p...>

> Sent: Tuesday, July 11, 2000 4:11 PM

> Subject: [asp_databases] Global.asa not working

>

>

> > Help

> >

> > I have specified a system dsn in my Global.asa file but when I try to

> > access it from within an ActiveX dll that I have coded in VB6, it does

not

> > work. I have read somewhere that the root folder that the Glbal.asa file

> > resides in must have the execute option enabled, but this does not seem

to

> > work either..

> >

> > Can anyone help

> >

> > Dominic Brooke-Pestell

> >


  Return to Index