|
 |
asp_database_setup thread: Fwd: Re: connectionstring
Message #1 by sanna.m.korpela@l... on Tue, 19 Jun 2001 12:22:37 +0300
|
|
Allready tried that and the same error assumed. Any other suggestions?
Thanks,
Sanna
Quoting Ken Schaefer <ken@a...>:
> Change con.open=Application(\\\"ConnectString\\\") to
>
> con.open Application(\\\"ConnectString\\\")
>
> (no = OK?)
>
> Cheers
> Ken
>
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> ----- Original Message -----
> From: \\\"Sanna Korpela\\\" <sanna.m.korpela@l...>
> To: \\\"ASP Database Setup\\\" <asp_database_setup@p...>
> Sent: Tuesday, June 19, 2001 10:34 AM
> Subject: [asp_database_setup] Re: connectionstring
>
>
> : > Hello Ken!
> : I\\\'m still a beginner with ASP and have been trying to use Global.asa-file
> : for declaring a connectionstring. Maybe you know answer to my problem? I
> : would be most gratefull.
> : Below I copy some code from Global.asa, The ASP-page and the
> error-message
> : received from the browser.
> :
> : Global.asa
> : <SCRIPT LANGUAGE=\\\"VBScript\\\" RUNAT=\\\"Server\\\">
> : Sub Application_OnStart
> : Application(\\\"ConnectString\\\")=\\\"provider=SQLOLEDB; Data
> : Source=ltnt152; Initial Catalog=tkr04; User Id=tkr04; Password=cqJyVV\\\"
> : End Sub
> : Sub Application_OnEnd
> : Application(\\\"ConnectString\\\")=\\\"\\\"
> : End Sub
> : Sub Session_OnStart
> : end sub
> : Sub Session_OnEnd
> : end sub
> : </SCRIPT>
> :
> : The beginning of the ASP-page
> : <%@language=vbscript%>
> : <html>
> : <head>
> : <title>Taloyhtiön yhteystiedot</title>
> : </head>
> : <body>
> : <%set con=Server.CreateObject(\\\"ADODB.Connection\\\")
> : con.open=Application(\\\"ConnectString\\\")
> : %>
> :
> : Error Type:
> : Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
> : [Microsoft][ODBC Driver Manager] Data source name not found and no
> default
> : driver specified
> : /Asp00/Tam99sa/SannaKorpela/expoin/yhteystiedot2.asp, line 8
> :
> : Thank you,
> : Sanna
> : > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> : >
%%%%%%%%%%%%%%%%%%%%%%
Sanna Korpela
sanna.m.korpela@l...
Message #2 by "Ken Schaefer" <ken@a...> on Wed, 20 Jun 2001 16:27:26 +1000
|
|
Try doing this:
Response.Write(Application("ConnectString"))
and post the output back to the list.
Cheers
Ken
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
----- Original Message -----
From: <sanna.m.korpela@l...>
To: "ASP Database Setup" <asp_database_setup@p...>
Sent: Tuesday, June 19, 2001 7:22 PM
Subject: [asp_database_setup] Fwd: Re: connectionstring
:
: Allready tried that and the same error assumed. Any other suggestions?
: Thanks,
: Sanna
Message #3 by "Sanna Korpela" <sanna.m.korpela@l...> on Wed, 20 Jun 2001 09:26:58
|
|
There is no response at all. Just a blank page. I also checked 'view
sourse' and there is only:
<html>
<head>
<title>Taloyhtiön yhteystiedot</title>
</head>
<body>
</body>
</html>
Well what next?
Sanna
>
Try doing this:
>
> Response.Write(Application("ConnectString"))
>
> and post the output back to the list.
>
> Cheers
> Ken
>
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> ----- Original Message -----
> From: <sanna.m.korpela@l...>
> To: "ASP Database Setup" <asp_database_setup@p...>
> Sent: Tuesday, June 19, 2001 7:22 PM
> Subject: [asp_database_setup] Fwd: Re: connectionstring
>
>
> :
> : Allready tried that and the same error assumed. Any other suggestions?
> : Thanks,
> : Sanna
>
Message #4 by "Ken Schaefer" <ken@a...> on Wed, 20 Jun 2001 22:22:03 +1000
|
|
It means that your global.asa in not being processed, thus nothing it being
put into your application variable. Then, when you try to open the
connection, it is not working.
Is your global.asa in an application root? (you can check using the IIS MMC
Snapin - right click on the folder, and go to the Home Directory tab - make
sure there is an application name there, otherwise hit the create new
button). Global.asa is only processed when it is in the web root, or in an
application root.
Cheers
Ken
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
----- Original Message -----
From: "Sanna Korpela" <sanna.m.korpela@l...>
To: "ASP Database Setup" <asp_database_setup@p...>
Sent: Wednesday, June 20, 2001 9:26 AM
Subject: [asp_database_setup] Re: Fwd: Re: connectionstring
: There is no response at all. Just a blank page. I also checked 'view
: sourse' and there is only:
:
: <html>
: <head>
: <title>Taloyhtiön yhteystiedot</title>
: </head>
: <body>
: </body>
: </html>
:
: Well what next?
: Sanna
:
: >
: Try doing this:
: >
: > Response.Write(Application("ConnectString"))
: >
: > and post the output back to the list.
: >
: > Cheers
: > Ken
: >
: > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
: > ----- Original Message -----
: > From: <sanna.m.korpela@l...>
: > To: "ASP Database Setup" <asp_database_setup@p...>
: > Sent: Tuesday, June 19, 2001 7:22 PM
: > Subject: [asp_database_setup] Fwd: Re: connectionstring
: >
: >
: > :
: > : Allready tried that and the same error assumed. Any other suggestions?
: > : Thanks,
: > : Sanna
: >
:
: ---
: STAY UP TO DATE ON ASP.NET, C#, VB.NET, SQL and XML
: Developersdex indexes over 100 of the top ASP, SQL, VB
: and XML sites bringing in more than 5,000 new resources
: every day. They even integrate all the top .NET
: newsgroups so you can search/post/reply across
: multiple newsgroups within their site. The next time
: you want to find an answer on ASP, C#, SQL, VB or XML
: think of Devdex! http://www.developersdex.com/
ken@a...
$subst('Email.Unsub')
|
|
|
View Cart
