By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,793 Members | 1,252 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,793 IT Pros & Developers. It's quick & easy.

empty connection string

P: n/a
AMC
Hi,

I'm using an include file to store the connection string to a database.
Whenever I try to reference that string to open a connection in the page
that includes the file I get the error 'empy connection string' . When I
write the string to the page using response.write(connectionstring) it shows
up fine. Is the something else that I need to do?

Thanks
Jul 19 '05 #1
Share this Question
Share on Google+
17 Replies


P: n/a
AMC wrote:
Hi,

I'm using an include file to store the connection string to a
database. Whenever I try to reference that string to open a
connection in the page that includes the file I get the error 'empy
connection string' . When I write the string to the page using
response.write(connectionstring) it shows up fine. Is the something
else that I need to do?

Thanks


Ah! I see it! the problem is on line 22 - right there at the 15th character!
Don't you see it?!?

Oh wait ... neither do I! You neglected to post the code that generated the
error.

;-)

Bob Barrows

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"
Jul 19 '05 #2

P: n/a
AMC
Sorry,

Here is the code for the include file: By the way this connection string
works fine when used directly from a page rather than referenced from an
include file.

<%

constr = "Driver={MySQL}; SERVER=localhost; Port=0; Option=0;
Socket=/home/greyso2/greysonproperties.com/.database/mysql/mysql.sock;
DATABASE=greyso2_Greyson;UID=greyso2; PWD=kramer;"

%>
Here's the code for the asp page that includes this file:

<!--#include virtual="/db.asp"-->

<%
set conn = server.CreateObject("ADODB.Connection")
conn.Open constr
%>
THanks again
"Bob Barrows [MVP]" <re******@NOyahoo.SPAMcom> wrote in message
news:e$*************@TK2MSFTNGP12.phx.gbl...
AMC wrote:
Hi,

I'm using an include file to store the connection string to a
database. Whenever I try to reference that string to open a
connection in the page that includes the file I get the error 'empy
connection string' . When I write the string to the page using
response.write(connectionstring) it shows up fine. Is the something
else that I need to do?

Thanks
Ah! I see it! the problem is on line 22 - right there at the 15th

character! Don't you see it?!?

Oh wait ... neither do I! You neglected to post the code that generated the error.

;-)

Bob Barrows

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

Jul 19 '05 #3

P: n/a
Nothing stands out. Time for some debugging:

<!--#include virtual="/db.asp"-->
<%
if len(constr) = 0 then
response.write "Empty connection string"
else
response.write constr
set conn = server.CreateObject("ADODB.Connection")
conn.Open constr
end if
%>

Bob Barrows

AMC wrote:
Sorry,

Here is the code for the include file: By the way this connection
string works fine when used directly from a page rather than
referenced from an include file.

<%

constr = "Driver={MySQL}; SERVER=localhost; Port=0; Option=0;
Socket=/home/greyso2/greysonproperties.com/.database/mysql/mysql.sock;
DATABASE=greyso2_Greyson;UID=greyso2; PWD=kramer;"

%>
Here's the code for the asp page that includes this file:

<!--#include virtual="/db.asp"-->

<%
set conn = server.CreateObject("ADODB.Connection")
conn.Open constr
%>
THanks again
"Bob Barrows [MVP]" <re******@NOyahoo.SPAMcom> wrote in message
news:e$*************@TK2MSFTNGP12.phx.gbl...
AMC wrote:
Hi,

I'm using an include file to store the connection string to a
database. Whenever I try to reference that string to open a
connection in the page that includes the file I get the error 'empy
connection string' . When I write the string to the page using
response.write(connectionstring) it shows up fine. Is the something
else that I need to do?

Thanks


Ah! I see it! the problem is on line 22 - right there at the 15th
character! Don't you see it?!?

Oh wait ... neither do I! You neglected to post the code that
generated the error.

;-)

Bob Barrows

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so
I don't check it very often. If you must reply off-line, then remove
the "NO SPAM"


--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"
Jul 19 '05 #4

P: n/a
AMC
Hi,

I've already tried this - before I posted, and the connection string was
written to the page. This is why I'm perplexed as to why I am getting the
error that declares it empty.

Thanks

"Bob Barrows [MVP]" <re******@NOyahoo.SPAMcom> wrote in message
news:%2***************@TK2MSFTNGP11.phx.gbl...
Nothing stands out. Time for some debugging:

<!--#include virtual="/db.asp"-->
<%
if len(constr) = 0 then
response.write "Empty connection string"
else
response.write constr
set conn = server.CreateObject("ADODB.Connection")
conn.Open constr
end if
%>

Bob Barrows

AMC wrote:
Sorry,

Here is the code for the include file: By the way this connection
string works fine when used directly from a page rather than
referenced from an include file.

<%

constr = "Driver={MySQL}; SERVER=localhost; Port=0; Option=0;
Socket=/home/greyso2/greysonproperties.com/.database/mysql/mysql.sock;
DATABASE=greyso2_Greyson;UID=greyso2; PWD=kramer;"

%>
Here's the code for the asp page that includes this file:

<!--#include virtual="/db.asp"-->

<%
set conn = server.CreateObject("ADODB.Connection")
conn.Open constr
%>
THanks again
"Bob Barrows [MVP]" <re******@NOyahoo.SPAMcom> wrote in message
news:e$*************@TK2MSFTNGP12.phx.gbl...
AMC wrote:
Hi,

I'm using an include file to store the connection string to a
database. Whenever I try to reference that string to open a
connection in the page that includes the file I get the error 'empy
connection string' . When I write the string to the page using
response.write(connectionstring) it shows up fine. Is the something
else that I need to do?

Thanks

Ah! I see it! the problem is on line 22 - right there at the 15th
character! Don't you see it?!?

Oh wait ... neither do I! You neglected to post the code that
generated the error.

;-)

Bob Barrows

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so
I don't check it very often. If you must reply off-line, then remove
the "NO SPAM"


--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

Jul 19 '05 #5

P: n/a
"AMC" wrote in message news:OD**************@TK2MSFTNGP09.phx.gbl...
: Sorry,
:
: Here is the code for the include file: By the way this connection string
: works fine when used directly from a page rather than referenced from an
: include file.
:
: <%
:
: constr = "Driver={MySQL}; SERVER=localhost; Port=0; Option=0;
: Socket=/home/greyso2/greysonproperties.com/.database/mysql/mysql.sock;
: DATABASE=greyso2_Greyson;UID=greyso2; PWD=kramer;"
:
: %>
:
:
: Here's the code for the asp page that includes this file:
:
: <!--#include virtual="/db.asp"-->
:
: <%
: set conn = server.CreateObject("ADODB.Connection")
: conn.Open constr
: %>

In this line:
Socket=/home/greyso2/greysonproperties.com/.database/mysql/mysql.sock;
Is this correct? .database (dot database)?

--
Roland Hall
/* This information is distributed in the hope that it will be useful, but
without any warranty; without even the implied warranty of merchantability
or fitness for a particular purpose. */
Technet Script Center - http://www.microsoft.com/technet/scriptcenter/
WSH 5.6 Documentation - http://msdn.microsoft.com/downloads/list/webdev.asp
MSDN Library - http://msdn.microsoft.com/library/default.asp
Jul 19 '05 #6

P: n/a
Let me get this straight. You are telling me that if you do this:

<!--#include virtual="/db.asp"-->
<%
dim localstr
on error resume next
if len(constr) = 0 then
response.write "Empty connection string from include file"
else
response.write "constr contains:<BR>" & constr & "<BR>"
set conn = server.CreateObject("ADODB.Connection")
conn.Open constr
if err <> 0 then
response.write "constr failure:<BR>"
response.write err.description & "<BR><BR>"
else
response.write "Successful connection with constr<BR>"
conn.close
end if
end if
localstr = "Driver={MySQL}; SERVER=localhost;" & _
"Port=0; Option=0;" & _
"Socket=/home/greyso2/greysonproperties.com/" & _
".database/mysql/mysql.sock;" & _
"DATABASE=greyso2_Greyson;UID=greyso2; PWD=kramer;"
response.write "<BR>localstr contains:<BR>"
response.write localstr & "<BR>"
err.clear
conn.open localstr
if err <> 0 then
response.write "localstr failure:<BR>"
response.write err.description & "<BR><BR>"
else
response.write "Successful connection with localstr<BR>"
conn.close
end if
set conn=nothing
%>

You get this:

constr contains:
Driver={MySQL}; SERVER=localhost; Port=0; Option=0;
Socket=/home/greyso2/greysonproperties.com/.database/mysql/mysql.sock;
DATABASE=greyso2_Greyson;UID=greyso2; PWD=kramer;
constr failure:
....empty connection string...

localstr contains:
Driver={MySQL}; SERVER=localhost; Port=0; Option=0;
Socket=/home/greyso2/greysonproperties.com/.database/mysql/mysql.sock;
DATABASE=greyso2_Greyson;UID=greyso2; PWD=kramer;
Successful connection with localstr

Really? Are you sure you've correctly spelled "constr" in your conn.Open
statement?

Are you using Option Explicit? If not, you should add that line to your
db.asp file (it needs to be the first line processed")

Bob Barrows

AMC wrote:
Hi,

I've already tried this - before I posted, and the connection string
was written to the page. This is why I'm perplexed as to why I am
getting the error that declares it empty.

Thanks

"Bob Barrows [MVP]" <re******@NOyahoo.SPAMcom> wrote in message
news:%2***************@TK2MSFTNGP11.phx.gbl...
Nothing stands out. Time for some debugging:

<!--#include virtual="/db.asp"-->
<%
if len(constr) = 0 then
response.write "Empty connection string"
else
response.write constr
set conn = server.CreateObject("ADODB.Connection")
conn.Open constr
end if
%>

Bob Barrows

AMC wrote:
Sorry,

Here is the code for the include file: By the way this connection
string works fine when used directly from a page rather than
referenced from an include file.

<%

constr = "Driver={MySQL}; SERVER=localhost; Port=0; Option=0;
Socket=/home/greyso2/greysonproperties.com/.database/mysql/mysql.sock;
DATABASE=greyso2_Greyson;UID=greyso2; PWD=kramer;"

%>
Here's the code for the asp page that includes this file:

<!--#include virtual="/db.asp"-->

<%
set conn = server.CreateObject("ADODB.Connection")
conn.Open constr
%>
THanks again
"Bob Barrows [MVP]" <re******@NOyahoo.SPAMcom> wrote in message
news:e$*************@TK2MSFTNGP12.phx.gbl...
AMC wrote:
> Hi,
>
> I'm using an include file to store the connection string to a
> database. Whenever I try to reference that string to open a
> connection in the page that includes the file I get the error
> 'empy connection string' . When I write the string to the page
> using response.write(connectionstring) it shows up fine. Is the
> something else that I need to do?
>
> Thanks

Ah! I see it! the problem is on line 22 - right there at the 15th
character! Don't you see it?!?

Oh wait ... neither do I! You neglected to post the code that
generated the error.

;-)

Bob Barrows

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap
so I don't check it very often. If you must reply off-line, then
remove the "NO SPAM"


--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so
I don't check it very often. If you must reply off-line, then remove
the "NO SPAM"


--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"
Jul 19 '05 #7

P: n/a
AMC
That is correct, here is what I got when I rant the exact code you posted
below:

constr = "Driver={MySQL}; SERVER=localhost; Port=0; Option=0;
Socket=/home/greyso2/greysonproperties.com/.database/mysql/mysql.sock;
DATABASE=greyso2_Greyson;UID=greyso2; PWD=kramer;"
Empty connection string from include file

localstr contains:Driver={MySQL}; SERVER=localhost;Port=0;
Option=0;Socket=/home/greyso2/greysonproperties.com/.database/mysql/mysql.so
ck;DATABASE=greyso2_Greyson;UID=greyso2; PWD=kramer;
Successful connection with localstr

I'll add option explicit to the include file. And yes I am spelling constr
correctly

Thanks

"Bob Barrows [MVP]" <re******@NOyahoo.SPAMcom> wrote in message
news:O3**************@TK2MSFTNGP12.phx.gbl...
Let me get this straight. You are telling me that if you do this:

<!--#include virtual="/db.asp"-->
<%
dim localstr
on error resume next
if len(constr) = 0 then
response.write "Empty connection string from include file"
else
response.write "constr contains:<BR>" & constr & "<BR>"
set conn = server.CreateObject("ADODB.Connection")
conn.Open constr
if err <> 0 then
response.write "constr failure:<BR>"
response.write err.description & "<BR><BR>"
else
response.write "Successful connection with constr<BR>"
conn.close
end if
end if
localstr = "Driver={MySQL}; SERVER=localhost;" & _
"Port=0; Option=0;" & _
"Socket=/home/greyso2/greysonproperties.com/" & _
".database/mysql/mysql.sock;" & _
"DATABASE=greyso2_Greyson;UID=greyso2; PWD=kramer;"
response.write "<BR>localstr contains:<BR>"
response.write localstr & "<BR>"
err.clear
conn.open localstr
if err <> 0 then
response.write "localstr failure:<BR>"
response.write err.description & "<BR><BR>"
else
response.write "Successful connection with localstr<BR>"
conn.close
end if
set conn=nothing
%>

You get this:

constr contains:
Driver={MySQL}; SERVER=localhost; Port=0; Option=0;
Socket=/home/greyso2/greysonproperties.com/.database/mysql/mysql.sock;
DATABASE=greyso2_Greyson;UID=greyso2; PWD=kramer;
constr failure:
...empty connection string...

localstr contains:
Driver={MySQL}; SERVER=localhost; Port=0; Option=0;
Socket=/home/greyso2/greysonproperties.com/.database/mysql/mysql.sock;
DATABASE=greyso2_Greyson;UID=greyso2; PWD=kramer;
Successful connection with localstr

Really? Are you sure you've correctly spelled "constr" in your conn.Open
statement?

Are you using Option Explicit? If not, you should add that line to your
db.asp file (it needs to be the first line processed")

Bob Barrows

AMC wrote:
Hi,

I've already tried this - before I posted, and the connection string
was written to the page. This is why I'm perplexed as to why I am
getting the error that declares it empty.

Thanks

"Bob Barrows [MVP]" <re******@NOyahoo.SPAMcom> wrote in message
news:%2***************@TK2MSFTNGP11.phx.gbl...
Nothing stands out. Time for some debugging:

<!--#include virtual="/db.asp"-->
<%
if len(constr) = 0 then
response.write "Empty connection string"
else
response.write constr
set conn = server.CreateObject("ADODB.Connection")
conn.Open constr
end if
%>

Bob Barrows

AMC wrote:
Sorry,

Here is the code for the include file: By the way this connection
string works fine when used directly from a page rather than
referenced from an include file.

<%

constr = "Driver={MySQL}; SERVER=localhost; Port=0; Option=0;
Socket=/home/greyso2/greysonproperties.com/.database/mysql/mysql.sock;
DATABASE=greyso2_Greyson;UID=greyso2; PWD=kramer;"

%>
Here's the code for the asp page that includes this file:

<!--#include virtual="/db.asp"-->

<%
set conn = server.CreateObject("ADODB.Connection")
conn.Open constr
%>
THanks again
"Bob Barrows [MVP]" <re******@NOyahoo.SPAMcom> wrote in message
news:e$*************@TK2MSFTNGP12.phx.gbl...
> AMC wrote:
>> Hi,
>>
>> I'm using an include file to store the connection string to a
>> database. Whenever I try to reference that string to open a
>> connection in the page that includes the file I get the error
>> 'empy connection string' . When I write the string to the page
>> using response.write(connectionstring) it shows up fine. Is the
>> something else that I need to do?
>>
>> Thanks
>
> Ah! I see it! the problem is on line 22 - right there at the 15th
> character! Don't you see it?!?
>
> Oh wait ... neither do I! You neglected to post the code that
> generated the error.
>
> ;-)
>
> Bob Barrows
>
> --
> Microsoft MVP - ASP/ASP.NET
> Please reply to the newsgroup. This email account is my spam trap
> so I don't check it very often. If you must reply off-line, then
> remove the "NO SPAM"

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so
I don't check it very often. If you must reply off-line, then remove
the "NO SPAM"


--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

Jul 19 '05 #8

P: n/a
AMC
I added option explicit, but still have the same problem. Any additional
help would be appreciated. I really don't want to have to set the connection
string in every page that access the db.

Thanks again

"Bob Barrows [MVP]" <re******@NOyahoo.SPAMcom> wrote in message
news:O3**************@TK2MSFTNGP12.phx.gbl...
Let me get this straight. You are telling me that if you do this:

<!--#include virtual="/db.asp"-->
<%
dim localstr
on error resume next
if len(constr) = 0 then
response.write "Empty connection string from include file"
else
response.write "constr contains:<BR>" & constr & "<BR>"
set conn = server.CreateObject("ADODB.Connection")
conn.Open constr
if err <> 0 then
response.write "constr failure:<BR>"
response.write err.description & "<BR><BR>"
else
response.write "Successful connection with constr<BR>"
conn.close
end if
end if
localstr = "Driver={MySQL}; SERVER=localhost;" & _
"Port=0; Option=0;" & _
"Socket=/home/greyso2/greysonproperties.com/" & _
".database/mysql/mysql.sock;" & _
"DATABASE=greyso2_Greyson;UID=greyso2; PWD=kramer;"
response.write "<BR>localstr contains:<BR>"
response.write localstr & "<BR>"
err.clear
conn.open localstr
if err <> 0 then
response.write "localstr failure:<BR>"
response.write err.description & "<BR><BR>"
else
response.write "Successful connection with localstr<BR>"
conn.close
end if
set conn=nothing
%>

You get this:

constr contains:
Driver={MySQL}; SERVER=localhost; Port=0; Option=0;
Socket=/home/greyso2/greysonproperties.com/.database/mysql/mysql.sock;
DATABASE=greyso2_Greyson;UID=greyso2; PWD=kramer;
constr failure:
...empty connection string...

localstr contains:
Driver={MySQL}; SERVER=localhost; Port=0; Option=0;
Socket=/home/greyso2/greysonproperties.com/.database/mysql/mysql.sock;
DATABASE=greyso2_Greyson;UID=greyso2; PWD=kramer;
Successful connection with localstr

Really? Are you sure you've correctly spelled "constr" in your conn.Open
statement?

Are you using Option Explicit? If not, you should add that line to your
db.asp file (it needs to be the first line processed")

Bob Barrows

AMC wrote:
Hi,

I've already tried this - before I posted, and the connection string
was written to the page. This is why I'm perplexed as to why I am
getting the error that declares it empty.

Thanks

"Bob Barrows [MVP]" <re******@NOyahoo.SPAMcom> wrote in message
news:%2***************@TK2MSFTNGP11.phx.gbl...
Nothing stands out. Time for some debugging:

<!--#include virtual="/db.asp"-->
<%
if len(constr) = 0 then
response.write "Empty connection string"
else
response.write constr
set conn = server.CreateObject("ADODB.Connection")
conn.Open constr
end if
%>

Bob Barrows

AMC wrote:
Sorry,

Here is the code for the include file: By the way this connection
string works fine when used directly from a page rather than
referenced from an include file.

<%

constr = "Driver={MySQL}; SERVER=localhost; Port=0; Option=0;
Socket=/home/greyso2/greysonproperties.com/.database/mysql/mysql.sock;
DATABASE=greyso2_Greyson;UID=greyso2; PWD=kramer;"

%>
Here's the code for the asp page that includes this file:

<!--#include virtual="/db.asp"-->

<%
set conn = server.CreateObject("ADODB.Connection")
conn.Open constr
%>
THanks again
"Bob Barrows [MVP]" <re******@NOyahoo.SPAMcom> wrote in message
news:e$*************@TK2MSFTNGP12.phx.gbl...
> AMC wrote:
>> Hi,
>>
>> I'm using an include file to store the connection string to a
>> database. Whenever I try to reference that string to open a
>> connection in the page that includes the file I get the error
>> 'empy connection string' . When I write the string to the page
>> using response.write(connectionstring) it shows up fine. Is the
>> something else that I need to do?
>>
>> Thanks
>
> Ah! I see it! the problem is on line 22 - right there at the 15th
> character! Don't you see it?!?
>
> Oh wait ... neither do I! You neglected to post the code that
> generated the error.
>
> ;-)
>
> Bob Barrows
>
> --
> Microsoft MVP - ASP/ASP.NET
> Please reply to the newsgroup. This email account is my spam trap
> so I don't check it very often. If you must reply off-line, then
> remove the "NO SPAM"

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so
I don't check it very often. If you must reply off-line, then remove
the "NO SPAM"


--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

Jul 19 '05 #9

P: n/a
AMC
Is there anything else I need to add to the include file or specify in the
other page to recognize this string? I feel like I'm missing something
really simple here.

"Bob Barrows [MVP]" <re******@NOyahoo.SPAMcom> wrote in message
news:O3**************@TK2MSFTNGP12.phx.gbl...
Let me get this straight. You are telling me that if you do this:

<!--#include virtual="/db.asp"-->
<%
dim localstr
on error resume next
if len(constr) = 0 then
response.write "Empty connection string from include file"
else
response.write "constr contains:<BR>" & constr & "<BR>"
set conn = server.CreateObject("ADODB.Connection")
conn.Open constr
if err <> 0 then
response.write "constr failure:<BR>"
response.write err.description & "<BR><BR>"
else
response.write "Successful connection with constr<BR>"
conn.close
end if
end if
localstr = "Driver={MySQL}; SERVER=localhost;" & _
"Port=0; Option=0;" & _
"Socket=/home/greyso2/greysonproperties.com/" & _
".database/mysql/mysql.sock;" & _
"DATABASE=greyso2_Greyson;UID=greyso2; PWD=kramer;"
response.write "<BR>localstr contains:<BR>"
response.write localstr & "<BR>"
err.clear
conn.open localstr
if err <> 0 then
response.write "localstr failure:<BR>"
response.write err.description & "<BR><BR>"
else
response.write "Successful connection with localstr<BR>"
conn.close
end if
set conn=nothing
%>

You get this:

constr contains:
Driver={MySQL}; SERVER=localhost; Port=0; Option=0;
Socket=/home/greyso2/greysonproperties.com/.database/mysql/mysql.sock;
DATABASE=greyso2_Greyson;UID=greyso2; PWD=kramer;
constr failure:
...empty connection string...

localstr contains:
Driver={MySQL}; SERVER=localhost; Port=0; Option=0;
Socket=/home/greyso2/greysonproperties.com/.database/mysql/mysql.sock;
DATABASE=greyso2_Greyson;UID=greyso2; PWD=kramer;
Successful connection with localstr

Really? Are you sure you've correctly spelled "constr" in your conn.Open
statement?

Are you using Option Explicit? If not, you should add that line to your
db.asp file (it needs to be the first line processed")

Bob Barrows

AMC wrote:
Hi,

I've already tried this - before I posted, and the connection string
was written to the page. This is why I'm perplexed as to why I am
getting the error that declares it empty.

Thanks

"Bob Barrows [MVP]" <re******@NOyahoo.SPAMcom> wrote in message
news:%2***************@TK2MSFTNGP11.phx.gbl...
Nothing stands out. Time for some debugging:

<!--#include virtual="/db.asp"-->
<%
if len(constr) = 0 then
response.write "Empty connection string"
else
response.write constr
set conn = server.CreateObject("ADODB.Connection")
conn.Open constr
end if
%>

Bob Barrows

AMC wrote:
Sorry,

Here is the code for the include file: By the way this connection
string works fine when used directly from a page rather than
referenced from an include file.

<%

constr = "Driver={MySQL}; SERVER=localhost; Port=0; Option=0;
Socket=/home/greyso2/greysonproperties.com/.database/mysql/mysql.sock;
DATABASE=greyso2_Greyson;UID=greyso2; PWD=kramer;"

%>
Here's the code for the asp page that includes this file:

<!--#include virtual="/db.asp"-->

<%
set conn = server.CreateObject("ADODB.Connection")
conn.Open constr
%>
THanks again
"Bob Barrows [MVP]" <re******@NOyahoo.SPAMcom> wrote in message
news:e$*************@TK2MSFTNGP12.phx.gbl...
> AMC wrote:
>> Hi,
>>
>> I'm using an include file to store the connection string to a
>> database. Whenever I try to reference that string to open a
>> connection in the page that includes the file I get the error
>> 'empy connection string' . When I write the string to the page
>> using response.write(connectionstring) it shows up fine. Is the
>> something else that I need to do?
>>
>> Thanks
>
> Ah! I see it! the problem is on line 22 - right there at the 15th
> character! Don't you see it?!?
>
> Oh wait ... neither do I! You neglected to post the code that
> generated the error.
>
> ;-)
>
> Bob Barrows
>
> --
> Microsoft MVP - ASP/ASP.NET
> Please reply to the newsgroup. This email account is my spam trap
> so I don't check it very often. If you must reply off-line, then
> remove the "NO SPAM"

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so
I don't check it very often. If you must reply off-line, then remove
the "NO SPAM"


--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

Jul 19 '05 #10

P: n/a
AMC
Yes, I'm sure this is correct

"Roland Hall" <nobody@nowhere> wrote in message
news:eH**************@TK2MSFTNGP11.phx.gbl...
"AMC" wrote in message news:OD**************@TK2MSFTNGP09.phx.gbl...
: Sorry,
:
: Here is the code for the include file: By the way this connection string
: works fine when used directly from a page rather than referenced from an
: include file.
:
: <%
:
: constr = "Driver={MySQL}; SERVER=localhost; Port=0; Option=0;
: Socket=/home/greyso2/greysonproperties.com/.database/mysql/mysql.sock;
: DATABASE=greyso2_Greyson;UID=greyso2; PWD=kramer;"
:
: %>
:
:
: Here's the code for the asp page that includes this file:
:
: <!--#include virtual="/db.asp"-->
:
: <%
: set conn = server.CreateObject("ADODB.Connection")
: conn.Open constr
: %>

In this line:
Socket=/home/greyso2/greysonproperties.com/.database/mysql/mysql.sock;
Is this correct? .database (dot database)?

--
Roland Hall
/* This information is distributed in the hope that it will be useful, but
without any warranty; without even the implied warranty of merchantability
or fitness for a particular purpose. */
Technet Script Center - http://www.microsoft.com/technet/scriptcenter/
WSH 5.6 Documentation - http://msdn.microsoft.com/downloads/list/webdev.asp MSDN Library - http://msdn.microsoft.com/library/default.asp

Jul 19 '05 #11

P: n/a
"AMC" wrote in message news:e8**************@tk2msftngp13.phx.gbl...
: Yes, I'm sure this is correct

You are attempting to use ODBC. You should use OLE DB.
constr = "Driver={MySQL}; SERVER=localhost; Port=0; Option=0;
Socket=/home/greyso2/greysonproperties.com/.database/mysql/mysql.sock;
DATABASE=greyso2_Greyson;UID=greyso2; PWD=kramer;"


An OLE DB connection for mySQL:
"Provider=MySQLProv;Data Source=mydb;User Id=myuserid;Password=mypassword;"

http://dev.mysql.com/doc/connector/odbc/en/manual.html
http://able-consulting.com/MDAC/ADO/...oviderForMySQL
http://www.connectionstrings.com/
http://www.vzio.com/tutorials/mysql_database.asp?page=4

--
Roland Hall
/* This information is distributed in the hope that it will be useful, but
without any warranty; without even the implied warranty of merchantability
or fitness for a particular purpose. */
Technet Script Center - http://www.microsoft.com/technet/scriptcenter/
WSH 5.6 Documentation - http://msdn.microsoft.com/downloads/list/webdev.asp
MSDN Library - http://msdn.microsoft.com/library/default.asp
Jul 19 '05 #12

P: n/a
AMC wrote:
That is correct, here is what I got when I rant the exact code you
posted below:

constr = "Driver={MySQL}; SERVER=localhost; Port=0; Option=0;
Socket=/home/greyso2/greysonproperties.com/.database/mysql/mysql.sock;
DATABASE=greyso2_Greyson;UID=greyso2; PWD=kramer;"
Is this text being written to the browser window? If so, where is it coming
from? Is it from a line of code in the include file?

The output from the code I posted begins below:
Empty connection string from include file
So this verifies that the constr variable does not have a value at this
point.

I'll add option explicit to the include file.


Bob Barrows
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"
Jul 19 '05 #13

P: n/a
AMC wrote:
I added option explicit, but still have the same problem. Any
additional help would be appreciated. I really don't want to have to
set the connection string in every page that access the db.


I think the next step is to add:

response.write "Within #include file, constr contains:<BR>"
response.write """" & constr & """"

to the include file to verify that the constr variable contains the
connection string. We know that it has no value in the "host" page so we
need to look more closely at the include file itself.

Bob Barrows
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"
Jul 19 '05 #14

P: n/a
AMC
I'm connecting to a MYSQL database. I'm not sure if there is an OLEDB driver
for MYSQL, besides, the connection string works fine when used directly in a
page, the problem is accessing it from an included file. That is the issue I
am trying to address here. I appreciate your help, but please read my posts
before replying next time.

"Roland Hall" <nobody@nowhere> wrote in message
news:Oi**************@TK2MSFTNGP10.phx.gbl...
"AMC" wrote in message news:e8**************@tk2msftngp13.phx.gbl...
: Yes, I'm sure this is correct

You are attempting to use ODBC. You should use OLE DB.
constr = "Driver={MySQL}; SERVER=localhost; Port=0; Option=0;
Socket=/home/greyso2/greysonproperties.com/.database/mysql/mysql.sock;
DATABASE=greyso2_Greyson;UID=greyso2; PWD=kramer;"
An OLE DB connection for mySQL:
"Provider=MySQLProv;Data Source=mydb;User

Id=myuserid;Password=mypassword;"
http://dev.mysql.com/doc/connector/odbc/en/manual.html
http://able-consulting.com/MDAC/ADO/...oviderForMySQL http://www.connectionstrings.com/
http://www.vzio.com/tutorials/mysql_database.asp?page=4

--
Roland Hall
/* This information is distributed in the hope that it will be useful, but
without any warranty; without even the implied warranty of merchantability
or fitness for a particular purpose. */
Technet Script Center - http://www.microsoft.com/technet/scriptcenter/
WSH 5.6 Documentation - http://msdn.microsoft.com/downloads/list/webdev.asp MSDN Library - http://msdn.microsoft.com/library/default.asp

Jul 19 '05 #15

P: n/a
AMC
Thanks Bob, I'll try this next

"Bob Barrows [MVP]" <re******@NOyahoo.SPAMcom> wrote in message
news:eq*************@TK2MSFTNGP09.phx.gbl...
AMC wrote:
I added option explicit, but still have the same problem. Any
additional help would be appreciated. I really don't want to have to
set the connection string in every page that access the db.


I think the next step is to add:

response.write "Within #include file, constr contains:<BR>"
response.write """" & constr & """"

to the include file to verify that the constr variable contains the
connection string. We know that it has no value in the "host" page so we
need to look more closely at the include file itself.

Bob Barrows
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

Jul 19 '05 #16

P: n/a
AMC
Okay, this is the code now in the include file:

<%

option explicit

dim constr

constr = "Driver={MySQL}; SERVER=localhost; Port=0; Option=0;
Socket=/home/greyso2/greysonproperties.com/.database/mysql/mysql.sock;
DATABASE=greyso2_Greyson;UID=greyso2; PWD=kramer;"

response.write(constr)
%>

When I ran the page the string was written to the page, but I am still
getting the same error in the page that includes the file. Thanks for your
help.
"Bob Barrows [MVP]" <re******@NOyahoo.SPAMcom> wrote in message
news:eq*************@TK2MSFTNGP09.phx.gbl...
AMC wrote:
I added option explicit, but still have the same problem. Any
additional help would be appreciated. I really don't want to have to
set the connection string in every page that access the db.


I think the next step is to add:

response.write "Within #include file, constr contains:<BR>"
response.write """" & constr & """"

to the include file to verify that the constr variable contains the
connection string. We know that it has no value in the "host" page so we
need to look more closely at the include file itself.

Bob Barrows
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

Jul 19 '05 #17

P: n/a
AMC
I take that back. It looks like adding option explicit did the trick after
all.
Thanks again!
"Bob Barrows [MVP]" <re******@NOyahoo.SPAMcom> wrote in message
news:eq*************@TK2MSFTNGP09.phx.gbl...
AMC wrote:
I added option explicit, but still have the same problem. Any
additional help would be appreciated. I really don't want to have to
set the connection string in every page that access the db.


I think the next step is to add:

response.write "Within #include file, constr contains:<BR>"
response.write """" & constr & """"

to the include file to verify that the constr variable contains the
connection string. We know that it has no value in the "host" page so we
need to look more closely at the include file itself.

Bob Barrows
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

Jul 19 '05 #18

This discussion thread is closed

Replies have been disabled for this discussion.