setting site's testing server

[VictorA]

I have a problem setting up my testing server.

I have two web apps already running on 2 sites. Nothing fancy, just a search function (master/detail). When I developed them 2 years ago, I had no problems setting up my test server. Actually I’m using the same connection string for this new project. Therefore, my web server and sql server are fine. By the way I upgraded to DW 8.0.2 / ASP and backend is MS SQL 2000.
Here’s my working connection string: (replaced var names with Xs and Ys)

<%
' FileName="Connection_odbc_conn_dsn.htm"
' Type="ADO"
' DesigntimeType="ADO"
' HTTP="true"
' Catalog=""
' Schema=""
Dim MM_connXXXXXX_STRING
MM_connXXXXXX_STRING = "dsn=xxxxxxxx;uid=yyyyyyyyy;pwd=;"
%>

From the tab Databases, I can see all the tables. The tab Bindings shows 4 steps but I cannot pass item “ 3. Set up the site’s testing server” It brings me to the Site Definition Dialog box where I set up Server Model = ASP VBScript, Access= Local/Network and other 2 items. This is exactly my settings on my 2 previous apps. A checkmark did not show up at step 3 hence cannot press + button to set up my recordset.

I checked the other working apps and it shows a red exclamation point infront of ‘Go to Detail Page’ under the Server Behaviors tab. Now this 2 year old, previously working version is also messed up.

What happened? Please help, I’m in big trouble! Where will I start checking? web server? sql server? DW?

Thank you.

[Newsgroup_User]

DW 8.0.2 changed recordset code to prevent SQL injection attacks. As a
result, older recordsets need to be remade, which just takes a few clicks.
You can read more about the 8.0.2 updater here.

http://www.adobe.com/cfusion/knowledgebase/index.cfm?id=2f916373


--
Nancy Gill
Adobe Community Expert
BLOG: http://www.dmxwishes.com/blog.asp
Author: Dreamweaver 8 e-book for the DMX Zone
Co-Author: Dreamweaver MX: Instant Troubleshooter (August, 2003)
Technical Editor: DMX 2004: The Complete Reference, DMX 2004: A Beginner's
Guide, Mastering Macromedia Contribute
Technical Reviewer: Dynamic Dreamweaver MX/DMX: Advanced PHP Web Development



"VictorA" <webforumsuser@macromedia.com> wrote in message
news:eattki$kn2$1@forums.macromedia.com...
>I have a problem setting up my testing server.
>
> I have two web apps already running on 2 sites. Nothing fancy, just a
> search
> function (master/detail). When I developed them 2 years ago, I had no
> problems
> setting up my test server. Actually I?m using the same connection string
> for
> this new project. Therefore, my web server and sql server are fine. By
> the way
> I upgraded to DW 8.0.2 / ASP and backend is MS SQL 2000.
> Here?s my working connection string: (replaced var names with Xs and Ys)
>
> <%
> ' FileName="Connection_odbc_conn_dsn.htm"
> ' Type="ADO"
> ' DesigntimeType="ADO"
> ' HTTP="true"
> ' Catalog=""
> ' Schema=""
> Dim MM_connXXXXXX_STRING
> MM_connXXXXXX_STRING = "dsn=xxxxxxxx;uid=yyyyyyyyy;pwd=;"
> %>
>
> From the tab Databases, I can see all the tables. The tab Bindings shows
> 4
> steps but I cannot pass item ? 3. Set up the site?s testing server? It
> brings
> me to the Site Definition Dialog box where I set up Server Model = ASP
> VBScript, Access= Local/Network and other 2 items. This is exactly my
> settings
> on my 2 previous apps. A checkmark did not show up at step 3 hence cannot
> press + button to set up my recordset.
>
> I checked the other working apps and it shows a red exclamation point
> infront
> of ?Go to Detail Page? under the Server Behaviors tab. Now this 2 year
> old,
> previously working version is also messed up.
>
> What happened? Please help, I?m in big trouble! Where will I start
> checking?
> web server? sql server? DW?
>
> Thank you.
>
>
>
>

[VictorA]

hi nancy,
thaks for the reply. i downloaded/install the 8.0.2 updater but the problem remains the same. also, i deleted my old connection and created a new one but yet to see the check mark on step 3 on Bindings tab.

If I will uninstall DW8 and go back to DW MX 2004 , or just intall MX2004 on a seperate PC and see if this will resolve the problem. Anybody encountered this same problem? I'm desperate (pressured?) to finish up this project, I'm willing to go back one version.

[Newsgroup_User]

Victor .. did you get this?

What are you specifying in your site definitions for your testing server ..
your URL, etc. ?


--
Nancy Gill
Adobe Community Expert
BLOG: http://www.dmxwishes.com/blog.asp
Author: Dreamweaver 8 e-book for the DMX Zone
Co-Author: Dreamweaver MX: Instant Troubleshooter (August, 2003)
Technical Editor: DMX 2004: The Complete Reference, DMX 2004: A Beginner's
Guide, Mastering Macromedia Contribute
Technical Reviewer: Dynamic Dreamweaver MX/DMX: Advanced PHP Web Development



"VictorA" <webforumsuser@macromedia.com> wrote in message
news:eb0j4f$si0$1@forums.macromedia.com...
> hi nancy,
> thaks for the reply. i downloaded/install the 8.0.2 updater but the
> problem
> remains the same. also, i deleted my old connection and created a new one
> but
> yet to see the check mark on step 3 on Bindings tab.
>
> If I will uninstall DW8 and go back to DW MX 2004 , or just intall MX2004
> on a
> seperate PC and see if this will resolve the problem. Anybody encountered
> this
> same problem? I'm desperate (pressured?) to finish up this project, I'm
> willing to go back one version.
>

[VictorA]

On Testing Server under Site Definition dialog box:

Server Model - ASP VBscript
Access - Local/Network
Testing Server Folder - W:\Website\Mysite\ <------(this is my repository folder on the web server)
URL prefix - http://localhost/

That's my office server. Again, this is the same setup that was working before. The kicker here is, it works fine at my house server even I'm on DW8 without the 8.0.2 update, but I have to do my developments on the company server.

[VictorA · Accepted solution]

looks like i got it. all i have to do is replace the URL.