Name Redefined? What is this Dim? (DWMX/ASP/VBscript/Access)

[Nathon Jones]

Hi,

I've been having this problem with a few sites now.
It appears that in some cases, and I can't spot a trend, but when I add a
recordset to a page it, somehow, is re-writing my Connections.asp file to
include an additional line:
Dim MM_dsnName_STRING

This is causing the connection to fail. Here's my precise error:

Name redefined
/webdirectory/Connections/dsnName.asp, line 8, column 4
Dim MM_dsnName_STRING
---^

So I've been going in and deleting this line, which I'm not sure I'm
actually supposed to do, and it solves my problem.
Why does DW add this line? It's knackering all of my database driven
pages!! :(

Nath.

[CarlGrint]

Sometimes Dreamweaver will add in the Connection Include link to a page which
already contains the link, never seen a trend, just an annoyance, and 'lovely'
little 'querk' of the application....it you get this error, and find duplicate
lines of the Connection file, then simple remove one of them, you are doing no
harm, just making it work again.

All the fun of using a GUI web tool.


Originally posted by: Newsgroup User
Hi,

I've been having this problem with a few sites now.
It appears that in some cases, and I can't spot a trend, but when I add a
recordset to a page it, somehow, is re-writing my Connections.asp file to
include an additional line:
Dim MM_dsnName_STRING

This is causing the connection to fail. Here's my precise error:

Name redefined
/webdirectory/Connections/dsnName.asp, line 8, column 4
Dim MM_dsnName_STRING
---^

So I've been going in and deleting this line, which I'm not sure I'm
actually supposed to do, and it solves my problem.
Why does DW add this line? It's knackering all of my database driven
pages!! :(

Nath.

[Nathon Jones]

A rather expensive GUI web tool Carl!

Seems a shame that Macromedia couldn't have sorted this out, but then I
guess they had Adobe on the phone!! ;)

Nath.

"CarlGrint" <webforumsuser@macromedia.com> wrote in message
news:d4dh1v$qmf$1@forums.macromedia.com...

> Sometimes Dreamweaver will add in the Connection Include link to a page
> which
> already contains the link, never seen a trend, just an annoyance, and
> 'lovely'
> little 'querk' of the application....it you get this error, and find
> duplicate
> lines of the Connection file, then simple remove one of them, you are
> doing no
> harm, just making it work again.
>
> All the fun of using a GUI web tool.
>
>
> Originally posted by: Newsgroup User
> Hi,
>
> I've been having this problem with a few sites now.
> It appears that in some cases, and I can't spot a trend, but when I add a
> recordset to a page it, somehow, is re-writing my Connections.asp file to
> include an additional line:
> Dim MM_dsnName_STRING
>
> This is causing the connection to fail. Here's my precise error:
>
> Name redefined
> /webdirectory/Connections/dsnName.asp, line 8, column 4
> Dim MM_dsnName_STRING
> ---^
>
> So I've been going in and deleting this line, which I'm not sure I'm
> actually supposed to do, and it solves my problem.
> Why does DW add this line? It's knackering all of my database driven
> pages!! :(
>
> Nath.
>
>
>
>
>
>

[CarlGrint]

Since Dreamweaver and UltraDev merged, its just been full of bugs, I never
remember it being so bad when it was UltraDev, but maybe that is wishful
thinking.

As the bug list goes, this is one of the those that is a little annoying, but
once it has happened a couple of times and you realise what it is, you can fix
it and get on with your work with having to worry.

Obviously ideally such annoying things should not happen, but to be honest
that will only happen when you develop in NotePad ;o)


Originally posted by: Newsgroup User
A rather expensive GUI web tool Carl!

Seems a shame that Macromedia couldn't have sorted this out, but then I
guess they had Adobe on the phone!! ;)

Nath.

"CarlGrint" <webforumsuser@macromedia.com> wrote in message
news:D4dh1v$qmf$1@forums.macromedia.com...

> Sometimes Dreamweaver will add in the Connection Include link to a page
> which
> already contains the link, never seen a trend, just an annoyance, and
> 'lovely'
> little 'querk' of the application....it you get this error, and find
> duplicate
> lines of the Connection file, then simple remove one of them, you are
> doing no
> harm, just making it work again.
>
> All the fun of using a GUI web tool.
>
>
> Originally posted by: Newsgroup User
> Hi,
>
> I've been having this problem with a few sites now.
> It appears that in some cases, and I can't spot a trend, but when I add a
> recordset to a page it, somehow, is re-writing my Connections.asp file to
> include an additional line:
> Dim MM_dsnName_STRING
>
> This is causing the connection to fail. Here's my precise error:
>
> Name redefined
> /webdirectory/Connections/dsnName.asp, line 8, column 4
> Dim MM_dsnName_STRING
> ---^
>
> So I've been going in and deleting this line, which I'm not sure I'm
> actually supposed to do, and it solves my problem.
> Why does DW add this line? It's knackering all of my database driven
> pages!! :(
>
> Nath.
>
>
>
>
>
>

[Nathon Jones]

There are a few wee things in DW which cause concern. Mainly database
issues right enough.
I wouldn't mind so much if it was a cheap piece of software, but it's not.

As you say, maybe time to resort back to Notepad!
Thanks for the advice.

Nath.

"CarlGrint" <webforumsuser@macromedia.com> wrote in message
news:d4l23f$p0c$1@forums.macromedia.com...

> Since Dreamweaver and UltraDev merged, its just been full of bugs, I never
> remember it being so bad when it was UltraDev, but maybe that is wishful
> thinking.
>
> As the bug list goes, this is one of the those that is a little annoying,
> but
> once it has happened a couple of times and you realise what it is, you can
> fix
> it and get on with your work with having to worry.
>
> Obviously ideally such annoying things should not happen, but to be honest
> that will only happen when you develop in NotePad ;o)
>
>
> Originally posted by: Newsgroup User
> A rather expensive GUI web tool Carl!
>
> Seems a shame that Macromedia couldn't have sorted this out, but then I
> guess they had Adobe on the phone!! ;)
>
> Nath.
>
> "CarlGrint" <webforumsuser@macromedia.com> wrote in message
> news:D4dh1v$qmf$1@forums.macromedia.com...

> > Sometimes Dreamweaver will add in the Connection Include link to a page
> > which
> > already contains the link, never seen a trend, just an annoyance, and
> > 'lovely'
> > little 'querk' of the application....it you get this error, and find
> > duplicate
> > lines of the Connection file, then simple remove one of them, you are
> > doing no
> > harm, just making it work again.
> >
> > All the fun of using a GUI web tool.
> >
> >
> > Originally posted by: Newsgroup User
> > Hi,
> >
> > I've been having this problem with a few sites now.
> > It appears that in some cases, and I can't spot a trend, but when I add
> > a
> > recordset to a page it, somehow, is re-writing my Connections.asp file
> > to
> > include an additional line:
> > Dim MM_dsnName_STRING
> >
> > This is causing the connection to fail. Here's my precise error:
> >
> > Name redefined
> > /webdirectory/Connections/dsnName.asp, line 8, column 4
> > Dim MM_dsnName_STRING
> > ---^
> >
> > So I've been going in and deleting this line, which I'm not sure I'm
> > actually supposed to do, and it solves my problem.
> > Why does DW add this line? It's knackering all of my database driven
> > pages!! :(
> >
> > Nath.
> >
> >
> >
> >
> >
> >

>
>
>
>
>
>

[Lionstone]

Yes, Notepad's design view is simply amazing.

"Nathon Jones" <nathon@SHPAMkirkmoor.com> wrote in message
news:d4l7vm$4c4$1@forums.macromedia.com...

> There are a few wee things in DW which cause concern. Mainly database
> issues right enough.
> I wouldn't mind so much if it was a cheap piece of software, but it's not.
>
> As you say, maybe time to resort back to Notepad!
> Thanks for the advice.
>
> Nath.
>
> "CarlGrint" <webforumsuser@macromedia.com> wrote in message
> news:d4l23f$p0c$1@forums.macromedia.com...

>> Since Dreamweaver and UltraDev merged, its just been full of bugs, I
>> never
>> remember it being so bad when it was UltraDev, but maybe that is wishful
>> thinking.
>>
>> As the bug list goes, this is one of the those that is a little annoying,
>> but
>> once it has happened a couple of times and you realise what it is, you
>> can fix
>> it and get on with your work with having to worry.
>>
>> Obviously ideally such annoying things should not happen, but to be
>> honest
>> that will only happen when you develop in NotePad ;o)
>>
>>
>> Originally posted by: Newsgroup User
>> A rather expensive GUI web tool Carl!
>>
>> Seems a shame that Macromedia couldn't have sorted this out, but then I
>> guess they had Adobe on the phone!! ;)
>>
>> Nath.
>>
>> "CarlGrint" <webforumsuser@macromedia.com> wrote in message
>> news:D4dh1v$qmf$1@forums.macromedia.com...

>> > Sometimes Dreamweaver will add in the Connection Include link to a page
>> > which
>> > already contains the link, never seen a trend, just an annoyance, and
>> > 'lovely'
>> > little 'querk' of the application....it you get this error, and find
>> > duplicate
>> > lines of the Connection file, then simple remove one of them, you are
>> > doing no
>> > harm, just making it work again.
>> >
>> > All the fun of using a GUI web tool.
>> >
>> >
>> > Originally posted by: Newsgroup User
>> > Hi,
>> >
>> > I've been having this problem with a few sites now.
>> > It appears that in some cases, and I can't spot a trend, but when I add
>> > a
>> > recordset to a page it, somehow, is re-writing my Connections.asp file
>> > to
>> > include an additional line:
>> > Dim MM_dsnName_STRING
>> >
>> > This is causing the connection to fail. Here's my precise error:
>> >
>> > Name redefined
>> > /webdirectory/Connections/dsnName.asp, line 8, column 4
>> > Dim MM_dsnName_STRING
>> > ---^
>> >
>> > So I've been going in and deleting this line, which I'm not sure I'm
>> > actually supposed to do, and it solves my problem.
>> > Why does DW add this line? It's knackering all of my database driven
>> > pages!! :(
>> >
>> > Nath.
>> >
>> >
>> >
>> >
>> >
>> >

>>
>>
>>
>>
>>
>>

>
>

[Nathon Jones]

At least it works! :)

Nath.

"Lionstone" <HIDElionstoneHIDE@HIDEhush.com> wrote in message
news:d4lem5$ev5$1@forums.macromedia.com...

> Yes, Notepad's design view is simply amazing.
>
> "Nathon Jones" <nathon@SHPAMkirkmoor.com> wrote in message
> news:d4l7vm$4c4$1@forums.macromedia.com...

>> There are a few wee things in DW which cause concern. Mainly database
>> issues right enough.
>> I wouldn't mind so much if it was a cheap piece of software, but it's
>> not.
>>
>> As you say, maybe time to resort back to Notepad!
>> Thanks for the advice.
>>
>> Nath.
>>
>> "CarlGrint" <webforumsuser@macromedia.com> wrote in message
>> news:d4l23f$p0c$1@forums.macromedia.com...

>>> Since Dreamweaver and UltraDev merged, its just been full of bugs, I
>>> never
>>> remember it being so bad when it was UltraDev, but maybe that is wishful
>>> thinking.
>>>
>>> As the bug list goes, this is one of the those that is a little
>>> annoying, but
>>> once it has happened a couple of times and you realise what it is, you
>>> can fix
>>> it and get on with your work with having to worry.
>>>
>>> Obviously ideally such annoying things should not happen, but to be
>>> honest
>>> that will only happen when you develop in NotePad ;o)
>>>
>>>
>>> Originally posted by: Newsgroup User
>>> A rather expensive GUI web tool Carl!
>>>
>>> Seems a shame that Macromedia couldn't have sorted this out, but then I
>>> guess they had Adobe on the phone!! ;)
>>>
>>> Nath.
>>>
>>> "CarlGrint" <webforumsuser@macromedia.com> wrote in message
>>> news:D4dh1v$qmf$1@forums.macromedia.com...
>>> > Sometimes Dreamweaver will add in the Connection Include link to a
>>> > page
>>> > which
>>> > already contains the link, never seen a trend, just an annoyance, and
>>> > 'lovely'
>>> > little 'querk' of the application....it you get this error, and find
>>> > duplicate
>>> > lines of the Connection file, then simple remove one of them, you are
>>> > doing no
>>> > harm, just making it work again.
>>> >
>>> > All the fun of using a GUI web tool.
>>> >
>>> >
>>> > Originally posted by: Newsgroup User
>>> > Hi,
>>> >
>>> > I've been having this problem with a few sites now.
>>> > It appears that in some cases, and I can't spot a trend, but when I
>>> > add a
>>> > recordset to a page it, somehow, is re-writing my Connections.asp file
>>> > to
>>> > include an additional line:
>>> > Dim MM_dsnName_STRING
>>> >
>>> > This is causing the connection to fail. Here's my precise error:
>>> >
>>> > Name redefined
>>> > /webdirectory/Connections/dsnName.asp, line 8, column 4
>>> > Dim MM_dsnName_STRING
>>> > ---^
>>> >
>>> > So I've been going in and deleting this line, which I'm not sure I'm
>>> > actually supposed to do, and it solves my problem.
>>> > Why does DW add this line? It's knackering all of my database driven
>>> > pages!! :(
>>> >
>>> > Nath.
>>> >
>>> >
>>> >
>>> >
>>> >
>>> >
>>>
>>>
>>>
>>>
>>>
>>>

>>
>>

>
>

[CarlGrint]

As this was only aimed at database coding, thus my statement about Notepad, of
course if you wish to combine Database usage and Design, I think there is no
better solution then Dreamweaver, but if you want to get around the bugs that
Dreamweaver has especially regarding database connection, then the only
solutions is to use Notepad, as no other package, either Frontpage or GoLive
does it better.

I have taken to only using the inbuilt behaviours when I have to and when they
save me time, and I can marry up with an Extension, such as the Dmxzone
ASPUploader and Jules CharonCart, but really I try to enter the rest by hand or
use the Command option for Insert/Update and Delete to reduce the over use of
code that Dreamweaver produces.


Originally posted by: Newsgroup User
Yes, Notepad's design view is simply amazing.

"Nathon Jones" <nathon@SHPAMkirkmoor.com> wrote in message
news:D4l7vm$4c4$1@forums.macromedia.com...

> There are a few wee things in DW which cause concern. Mainly database
> issues right enough.
> I wouldn't mind so much if it was a cheap piece of software, but it's not.
>
> As you say, maybe time to resort back to Notepad!
> Thanks for the advice.
>
> Nath.
>
> "CarlGrint" <webforumsuser@macromedia.com> wrote in message
> news:D4l23f$p0c$1@forums.macromedia.com...

>> Since Dreamweaver and UltraDev merged, its just been full of bugs, I
>> never
>> remember it being so bad when it was UltraDev, but maybe that is wishful
>> thinking.
>>
>> As the bug list goes, this is one of the those that is a little annoying,
>> but
>> once it has happened a couple of times and you realise what it is, you
>> can fix
>> it and get on with your work with having to worry.
>>
>> Obviously ideally such annoying things should not happen, but to be
>> honest
>> that will only happen when you develop in NotePad ;o)
>>
>>
>> Originally posted by: Newsgroup User
>> A rather expensive GUI web tool Carl!
>>
>> Seems a shame that Macromedia couldn't have sorted this out, but then I
>> guess they had Adobe on the phone!! ;)
>>
>> Nath.
>>
>> "CarlGrint" <webforumsuser@macromedia.com> wrote in message
>> news:D4dh1v$qmf$1@forums.macromedia.com...

>> > Sometimes Dreamweaver will add in the Connection Include link to a page
>> > which
>> > already contains the link, never seen a trend, just an annoyance, and
>> > 'lovely'
>> > little 'querk' of the application....it you get this error, and find
>> > duplicate
>> > lines of the Connection file, then simple remove one of them, you are
>> > doing no
>> > harm, just making it work again.
>> >
>> > All the fun of using a GUI web tool.
>> >
>> >
>> > Originally posted by: Newsgroup User
>> > Hi,
>> >
>> > I've been having this problem with a few sites now.
>> > It appears that in some cases, and I can't spot a trend, but when I add
>> > a
>> > recordset to a page it, somehow, is re-writing my Connections.asp file
>> > to
>> > include an additional line:
>> > Dim MM_dsnName_STRING
>> >
>> > This is causing the connection to fail. Here's my precise error:
>> >
>> > Name redefined
>> > /webdirectory/Connections/dsnName.asp, line 8, column 4
>> > Dim MM_dsnName_STRING
>> > ---^
>> >
>> > So I've been going in and deleting this line, which I'm not sure I'm
>> > actually supposed to do, and it solves my problem.
>> > Why does DW add this line? It's knackering all of my database driven
>> > pages!! :(
>> >
>> > Nath.
>> >
>> >
>> >
>> >
>> >
>> >

>>
>>
>>
>>
>>
>>

>
>

[CarlGrint]

Check out Notepad 2, very good, the colour coding helps when you are coding

[url]http://www.flos-freeware.ch/notepad2.html[/url]

Originally posted by: Newsgroup User
At least it works! :)

Nath.

"Lionstone" <HIDElionstoneHIDE@HIDEhush.com> wrote in message
news:D4lem5$ev5$1@forums.macromedia.com...

> Yes, Notepad's design view is simply amazing.
>
> "Nathon Jones" <nathon@SHPAMkirkmoor.com> wrote in message
> news:D4l7vm$4c4$1@forums.macromedia.com...

>> There are a few wee things in DW which cause concern. Mainly database
>> issues right enough.
>> I wouldn't mind so much if it was a cheap piece of software, but it's
>> not.
>>
>> As you say, maybe time to resort back to Notepad!
>> Thanks for the advice.
>>
>> Nath.
>>
>> "CarlGrint" <webforumsuser@macromedia.com> wrote in message
>> news:D4l23f$p0c$1@forums.macromedia.com...

>>> Since Dreamweaver and UltraDev merged, its just been full of bugs, I
>>> never
>>> remember it being so bad when it was UltraDev, but maybe that is wishful
>>> thinking.
>>>
>>> As the bug list goes, this is one of the those that is a little
>>> annoying, but
>>> once it has happened a couple of times and you realise what it is, you
>>> can fix
>>> it and get on with your work with having to worry.
>>>
>>> Obviously ideally such annoying things should not happen, but to be
>>> honest
>>> that will only happen when you develop in NotePad ;o)
>>>
>>>
>>> Originally posted by: Newsgroup User
>>> A rather expensive GUI web tool Carl!
>>>
>>> Seems a shame that Macromedia couldn't have sorted this out, but then I
>>> guess they had Adobe on the phone!! ;)
>>>
>>> Nath.
>>>
>>> "CarlGrint" <webforumsuser@macromedia.com> wrote in message
>>> news:D4dh1v$qmf$1@forums.macromedia.com...
>>> > Sometimes Dreamweaver will add in the Connection Include link to a
>>> > page
>>> > which
>>> > already contains the link, never seen a trend, just an annoyance, and
>>> > 'lovely'
>>> > little 'querk' of the application....it you get this error, and find
>>> > duplicate
>>> > lines of the Connection file, then simple remove one of them, you are
>>> > doing no
>>> > harm, just making it work again.
>>> >
>>> > All the fun of using a GUI web tool.
>>> >
>>> >
>>> > Originally posted by: Newsgroup User
>>> > Hi,
>>> >
>>> > I've been having this problem with a few sites now.
>>> > It appears that in some cases, and I can't spot a trend, but when I
>>> > add a
>>> > recordset to a page it, somehow, is re-writing my Connections.asp file
>>> > to
>>> > include an additional line:
>>> > Dim MM_dsnName_STRING
>>> >
>>> > This is causing the connection to fail. Here's my precise error:
>>> >
>>> > Name redefined
>>> > /webdirectory/Connections/dsnName.asp, line 8, column 4
>>> > Dim MM_dsnName_STRING
>>> > ---^
>>> >
>>> > So I've been going in and deleting this line, which I'm not sure I'm
>>> > actually supposed to do, and it solves my problem.
>>> > Why does DW add this line? It's knackering all of my database driven
>>> > pages!! :(
>>> >
>>> > Nath.
>>> >
>>> >
>>> >
>>> >
>>> >
>>> >
>>>
>>>
>>>
>>>
>>>
>>>

>>
>>

>
>

[Lionstone]

Just making a joke, dude. :)

"CarlGrint" <webforumsuser@macromedia.com> wrote in message
news:d4lg60$het$1@forums.macromedia.com...

> As this was only aimed at database coding, thus my statement about
> Notepad, of
> course if you wish to combine Database usage and Design, I think there is
> no
> better solution then Dreamweaver, but if you want to get around the bugs
> that
> Dreamweaver has especially regarding database connection, then the only
> solutions is to use Notepad, as no other package, either Frontpage or
> GoLive
> does it better.
>
> I have taken to only using the inbuilt behaviours when I have to and when
> they
> save me time, and I can marry up with an Extension, such as the Dmxzone
> ASPUploader and Jules CharonCart, but really I try to enter the rest by
> hand or
> use the Command option for Insert/Update and Delete to reduce the over use
> of
> code that Dreamweaver produces.
>
>
> Originally posted by: Newsgroup User
> Yes, Notepad's design view is simply amazing.
>
> "Nathon Jones" <nathon@SHPAMkirkmoor.com> wrote in message
> news:D4l7vm$4c4$1@forums.macromedia.com...

> > There are a few wee things in DW which cause concern. Mainly database
> > issues right enough.
> > I wouldn't mind so much if it was a cheap piece of software, but it's
> > not.
> >
> > As you say, maybe time to resort back to Notepad!
> > Thanks for the advice.
> >
> > Nath.
> >
> > "CarlGrint" <webforumsuser@macromedia.com> wrote in message
> > news:D4l23f$p0c$1@forums.macromedia.com...

> >> Since Dreamweaver and UltraDev merged, its just been full of bugs, I
> >> never
> >> remember it being so bad when it was UltraDev, but maybe that is
> >> wishful
> >> thinking.
> >>
> >> As the bug list goes, this is one of the those that is a little
> >> annoying,
> >> but
> >> once it has happened a couple of times and you realise what it is, you
> >> can fix
> >> it and get on with your work with having to worry.
> >>
> >> Obviously ideally such annoying things should not happen, but to be
> >> honest
> >> that will only happen when you develop in NotePad ;o)
> >>
> >>
> >> Originally posted by: Newsgroup User
> >> A rather expensive GUI web tool Carl!
> >>
> >> Seems a shame that Macromedia couldn't have sorted this out, but then I
> >> guess they had Adobe on the phone!! ;)
> >>
> >> Nath.
> >>
> >> "CarlGrint" <webforumsuser@macromedia.com> wrote in message
> >> news:D4dh1v$qmf$1@forums.macromedia.com...
> >> > Sometimes Dreamweaver will add in the Connection Include link to a
> >> > page
> >> > which
> >> > already contains the link, never seen a trend, just an annoyance, and
> >> > 'lovely'
> >> > little 'querk' of the application....it you get this error, and find
> >> > duplicate
> >> > lines of the Connection file, then simple remove one of them, you
> >> > are
> >> > doing no
> >> > harm, just making it work again.
> >> >
> >> > All the fun of using a GUI web tool.
> >> >
> >> >
> >> > Originally posted by: Newsgroup User
> >> > Hi,
> >> >
> >> > I've been having this problem with a few sites now.
> >> > It appears that in some cases, and I can't spot a trend, but when I
> >> > add
> >> > a
> >> > recordset to a page it, somehow, is re-writing my Connections.asp
> >> > file
> >> > to
> >> > include an additional line:
> >> > Dim MM_dsnName_STRING
> >> >
> >> > This is causing the connection to fail. Here's my precise error:
> >> >
> >> > Name redefined
> >> > /webdirectory/Connections/dsnName.asp, line 8, column 4
> >> > Dim MM_dsnName_STRING
> >> > ---^
> >> >
> >> > So I've been going in and deleting this line, which I'm not sure I'm
> >> > actually supposed to do, and it solves my problem.
> >> > Why does DW add this line? It's knackering all of my database driven
> >> > pages!! :(
> >> >
> >> > Nath.
> >> >
> >> >
> >> >
> >> >
> >> >
> >> >
> >>
> >>
> >>
> >>
> >>
> >>

> >
> >

>
>
>
>
>
>