Solved

.asp connection string to MySQL WordPress database

Posted on 2011-02-11
42
3,899 Views
Last Modified: 2012-05-11
Can somebody please help me figure out 2 things.
1) what should I use for a  database connection string to connect a .asp page to a WordPress MySQL database.  I have asked the web host for a URL or IP address for the database and they refuse to get me any information.
2) should I put the connection.asp   file and the  .asp page in the httpdocs  folder?  Or, in the httpdocs/WordPress folder?

the information below is from my wp-config.php

/** The name of the database for WordPress */
define('DB_NAME', 'tcmassag_mysql05ca7bc461cb8285c7d0698c2a3eec46');

/** MySQL database username */
define('DB_USER', 'tcmas_rickDB');

/** MySQL database password */
define('DB_PASSWORD', 'MySecretPassword');

/** MySQL hostname */
define('DB_HOST', 'localhost');
0
Comment
Question by:STP8377
  • 22
  • 20
42 Comments
 
LVL 11

Expert Comment

by:G_H
ID: 34875944
Are you running the ASP script on the same server ad the php?

GH
0
 

Author Comment

by:STP8377
ID: 34876035
I copied the information below from http://webhostingworld.net/cheap_windows_hosting_details.php
from their information about "shared Windows Hosting".  It looks like the answer to your question is yes, ASP script and PHP are on the same server.

Number of MySql Databases             1
PhPmyadmin                         Yes
Number of MsSql Ddatabases (2005 / 2008)      1
Ms Sql Web Admin          My Little Admin
Ms Access Support      Yes
ODBC Support                       Yes

==== Server Side Scripts =====
ASP.NET 4.0, 3.5, 3.0, 2.0 & 1.1      Yes
PHP 4.4.7 & PHP 5.2.13      Yes
Server Side Includes (SSI)      Yes
Zend Optimizer 3.0.1      Yes
GD Library      Yes
ASP      Yes
Fastcgi           Yes
Python        Yes
CGI support      Yes
Perl 5.8.7         Yes
0
 
LVL 11

Expert Comment

by:G_H
ID: 34876123
In that case, you should be able to use 'localhosts' in your connection string, as well as the username and password.

All ee need to know now is which ODBC driver they have installed. The most common ate 3.51 and 5.1. I'll post shortly.
0
 
LVL 11

Expert Comment

by:G_H
ID: 34876184
OK here is a "modified for you" version of the script I use...

 
'' ## Dim Exerything
Dim DBServer, Database, DBPass, DBUser

'' ## Database settings
DBServer = "localhost"
DBUser   = "tcmas_rickDB"
DBPass   = "MySecretPassword"
DataBase = "tcmassag_mysql05ca7bc461cb8285c7d0698c2a3eec46"

Function CreateDatabaseConnection()
	Set Conn = Server.CreateObject("ADODB.Connection")
		'' ## Use ONE of these
		Conn.Open "driver={MySQL ODBC 5.1 Driver};server=" & DBServer & ";uid=" & DBUser & ";pwd=" & DBPass & ";database=" & Database
		Conn.Open "driver={MySQL ODBC 3.51 Driver};server=" & DBServer & ";uid=" & DBUser & ";pwd=" & DBPass & ";database=" & Database
End Function

Function CloseDatabaseConnection()
		Conn.Close
	Set Conn = Nothing
End Function

Open in new window


I always put this a directory away from public eyes, in a file called "database.asp" which is "included".

You do not always have the ability in ASP to go "up" a directory, but id you do use:

 
<!--#include file="../hidden/database.asp"-->

Open in new window


GH
0
 

Author Comment

by:STP8377
ID: 34876718
I need to clarify a couple of things. Do I copy all the code and replace the password with my real password and then save the file as connection.asp?  I can deal with the "include" and putting the connection file away after I get it working, but for testing purposes, do I put both the connection file and the .asp file in the httpdocs folder?  I tried putting both files in the httpdocs folder and in the sub folder named wordpress and get an error message with either location.  The code is for the file I am using to test the connection, let me know if there is an easier way to test the connection.
<!--#INCLUDE VIRTUAL="/connectionv3.asp" -->

<p>
Venue <a href="usersortv3.asp?OB=f_a">ASC</a> sort <a href="usersortv3.asp?OB=f_d">DESC</a><br>
Subject <a href="usersortv3.asp?OBt=l_a">ASC</a> sort <a href="usersortv3.asp?OB=l_d">DESC</a>
</p>


<%
DIM strOrderBy, tmpOrderBy
strOrderBy = Request.QueryString("OB")
Select Case strOrderBy
Case "f_a"
tmpOrderBy = "ORDER BY Subject ASC"
Case "fn_d"
tmpOrderBy = "ORDER BY Subject DESC"
Case "l_a"
tmpOrderBy = "ORDER BY Venue ASC"
Case "l_d"
tmpOrderBy = "ORDER BY Venue DESC"
Case Else
tmpOrderBy = "ORDER BY Subject DESC"
End Select

DIM mySQL, objRS
mySQL = "Select Subject, Venue FROM tutorials_meetings " & tmpOrderBy
Set objRS = Server.CreateObject("ADODB.Recordset")
objRS.Open mySQL, objConn

DO WHILE NOT objRS.EOF
%>

<%=objRS("Subject")%> <%=objRS("Venue")%><br>

<%
objRS.MoveNext
Loop

objRS.Close
Set objRS = Nothing
objConn.Close
Set objConn = Nothing
%>

Open in new window

0
 
LVL 11

Expert Comment

by:G_H
ID: 34877392
For testing, I would be temped to put all of the code in a single file, just so as to exclude all possible errors. Put this file into the httpdocs folder:

 
'' ## Connection Test

'' ## Dim Exerything
Dim Conn, DBServer, Database, DBPass, DBUser
Dim sqlA, rsA

'' ## Database settings
DBServer = "localhost"
DBUser   = "tcmas_rickDB"
DBPass   = "MySecretPassword"
DataBase = "tcmassag_mysql05ca7bc461cb8285c7d0698c2a3eec46"

CreateDatabaseConnection

'' ## Creta some sql
sqlA = "SELECT Subject, Venue FROM tutorials_meetings"
'' ## Set the recordset
Set rsA = Conn.execute(sqlA)
'' ## Loop the recordset
while NOT(rsA.EOF)
'' ## Write something to screen
response.write rsA("Subject") & "<br />"
rsA.movenext
wend
rsA.close
Set rsA = nothing

CloseDatabaseConnection

Function CreateDatabaseConnection()
	Set Conn = Server.CreateObject("ADODB.Connection")
		'' ## Use ONE of these
		Conn.Open "driver={MySQL ODBC 5.1 Driver};server=" & DBServer & ";uid=" & DBUser & ";pwd=" & DBPass & ";database=" & Database
		Conn.Open "driver={MySQL ODBC 3.51 Driver};server=" & DBServer & ";uid=" & DBUser & ";pwd=" & DBPass & ";database=" & Database
End Function

Function CloseDatabaseConnection()
		Conn.Close
	Set Conn = Nothing
End Function

Open in new window


...If this gives you an error, post the error message, as it may help us get to the bottom of the problem...

GH
0
 

Author Comment

by:STP8377
ID: 34878254
I put all of the code above into a file (with a text editor) and changed the password to my real password and named the file        test.asp  
When I put the file in the httpdocs folder and put this in the browser url address  http://tcmassagereviews.com/test.asp
the file contents displayed in the browser window, then I put the same file in the httpdocs/wordpress subfolder:    http://tcmassagereviews.com/wordpress/test.asp
and got a 404 Not Found error:
The requested document was not found on this server.      Web Server at tcmassagereviews.com
0
 
LVL 11

Expert Comment

by:G_H
ID: 34878874
If you put this into the httpdocs folder, and the files shows as text in your browser, then the server is not setup to (process and) serve ".asp" pages.

Check this with their tech support.

GH
0
 

Author Comment

by:STP8377
ID: 34878980
I submitted a ticket to www.webhostingworld.net      I don't see the file contents/text in the browser when I run the .asp pages from the WordPress folder, does that indicate anything?
0
 
LVL 11

Expert Comment

by:G_H
ID: 34879607
Because you got a 404, there is something else going on there. Can you upload a PHP info file to each location, and view the results?
0
 

Author Comment

by:STP8377
ID: 34881190
from wordpress folder from httpdocs folder
0
 

Author Comment

by:STP8377
ID: 34881200
You can view the php info files here:
http://tcmassagereviews.com/wordpress/phpinfo.php
and here:
http://tcmassagereviews.com/phpinfo.php

the are exactly the same except for the entry in the httpdocs folder is:
Server API  CGI/FastCGI  
and the same entry in the httpdocs/wordpress folder is:
Server API  ISAPI  
0
 

Author Comment

by:STP8377
ID: 34881217
Disregard my comments about both versions being the same, I didn't realize that there was a lot more to the file/info than the images I uploaded.
Do you think the connection string needs to specify the website IP address instead of "localhost"  ?
0
 
LVL 11

Expert Comment

by:G_H
ID: 34882554
OK, your post #34881200. This is all about PHP. References to the "Server API" are "how" the windows server serves PHP pages. This has nothing to do with ASP. It does however show that both places are having PHP executed.

For your post #34881217. MySQL authentication uses "user name". "password" and "place" to decide if it is going to give you access. As your PHP scripts are connecting to "localhost" your ASP should too. If not, it is possible that the request for access will look like it is coming from "outside", and there for your username and password may not work.

While you are waiting for your support ticket to come back, lets try a simple test. save the following as "write.asp" and upload it to both locations:

<%
response.write "Hello World!"
%>


Lets see what you get when you browse to each location...

GH

0
 

Author Comment

by:STP8377
ID: 34882774
Thanks again for your help.  The support ticket said: "we have asp.net installed on the server. It works for application and httpdocs too.

I put your Hello World file in both locations, you can view the results below.  It works in httpdocs (the first URL below), but not in the WordPress folder.
http://tcmassagereviews.com/write.asp
I get the 404 not found error in the wordpress folder below
http://tcmassagereviews.com/wordpress/write.asp
0
 
LVL 11

Expert Comment

by:G_H
ID: 34883009
OK, so the Word Press directory has something special going on with it. We can view a PHP page you put in there, but not an ASP page...

So we know we can run ASP in the root, but not the wordpress directory.

As I see it, we have two options:

1. go back to the host and ask them to prove the hello world does work in the wordpress folder.

2. Try to run a database script from the httpdocs directory.

Probably best to do both.

I have commented-out one of the connection strings, if it does not work, try the other one. This should hopefully give us an error message at least...

 
response.write "Easy As: "
'' ## Dim Exerything
Dim DBServer, Database, DBPass, DBUser

'' ## Database settings
DBServer = "localhost"
DBUser   = "tcmas_rickDB"
DBPass   = "MySecretPassword"
DataBase = "tcmassag_mysql05ca7bc461cb8285c7d0698c2a3eec46"

response.write "1"
Call CreateDatabaseConnection()
response.write "2"
Call CloseDatabaseConnection()
response.write "3"

Function CreateDatabaseConnection()
	Set Conn = Server.CreateObject("ADODB.Connection")
		'' ## Use ONE of these
		Conn.Open "driver={MySQL ODBC 5.1 Driver};server=" & DBServer & ";uid=" & DBUser & ";pwd=" & DBPass & ";database=" & Database
'		Conn.Open "driver={MySQL ODBC 3.51 Driver};server=" & DBServer & ";uid=" & DBUser & ";pwd=" & DBPass & ";database=" & Database
End Function

Function CloseDatabaseConnection()
		Conn.Close
	Set Conn = Nothing
End Function

Open in new window


GH
0
 

Author Comment

by:STP8377
ID: 34883374
you can view the results, I named the files easy3-51.asp  and  easy5-1.asp  and commented out one of the a different connection string in each one.
http://tcmassagereviews.com/easy5-1.asp    displays the file contents
http://tcmassagereviews.com/wordpress/easy5-1.asp     error 404 not found  The requested document was not found on this server.
http://tcmassagereviews.com/wordpress/easy3-51.asp   error 404 not found
http://tcmassagereviews.com/easy3-51.asp     displays the file contents

I will create another support ticket right now for the Hello World in the WordPress folder
0
 

Author Comment

by:STP8377
ID: 34883398
Is it possible to run the .asp page from the httpdocs folder and make it retrieve data from the wordpress database?   Can .asp retrieve data from a subfolder like that?  I don't even think the wordpress database is actually in the wordpress folder but I don't know where it is located.
0
 

Author Comment

by:STP8377
ID: 34883522
Another Option:  Maybe I could install a new instance of wordpress and this time -not- install it into a sub-folder?  I think that is possible, I think the default was that it installed into a sub-folder and I did not notice at the time that I was running the installation.  I would need to move the website and delete the sub folder version of wordpress but that's ok.
0
 
LVL 11

Expert Comment

by:G_H
ID: 34883671
Change the password in the easy files as they ate displaying online.

0
 
LVL 11

Accepted Solution

by:
G_H earned 500 total points
ID: 34883990
OK, I have used the details from your post above, which gives me your password and everything. I have used my server here, and connected to your MySQL database using ASP.

Below is the code I used, with just the password changed...

 
<%
response.write "Easy As: "
'' ## Dim Exerything
Dim DBServer, Database, DBPass, DBUser
Dim Conn

'' ## Database settings
DBServer = "tcmassagereviews.com"
DBUser   = "tcmas_rickDB"
DBPass   = "MySecretPassword"
DataBase = "tcmassag_mysql05ca7bc461cb8285c7d0698c2a3eec46"

response.write "1"
Call CreateDatabaseConnection()
response.write "2"
Call CloseDatabaseConnection()
response.write "3"

Function CreateDatabaseConnection()
	Set Conn = Server.CreateObject("ADODB.Connection")
		'' ## Use ONE of these
'		Conn.Open "driver={MySQL ODBC 5.1 Driver};server=" & DBServer & ";uid=" & DBUser & ";pwd=" & DBPass & ";database=" & Database
		Conn.Open "driver={MySQL ODBC 3.51 Driver};server=" & DBServer & ";uid=" & DBUser & ";pwd=" & DBPass & ";database=" & Database
End Function

Function CloseDatabaseConnection()
		Conn.Close
	Set Conn = Nothing
End Function
%>

Open in new window


I am concerned about your file you saved to your server... I assumed (always bad) that you have done ASP before (now I do not think you have).

Note the code below has <% at the start, and %> at the end, as ASP delimiters. (You either love or hate me now)...

Anything outside of these will show as HTML or Text. I think that is where you are going wrong.

GH
0
Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

 
LVL 11

Expert Comment

by:G_H
ID: 34884029
Your Post: #34883374, delete these files NOW. Then change your password for a new one.

As a "Good Deed" I have taken a backup of your MySQL Database, but I do not know if anyone had messed with it, by the time I had. 20:45 GMT. If you need this file, or need it restored, PM me.

Your Post: #34883398, "MySQL database" is *NOT* IN the Word Press folder. MySQL is on the "Server", and can be accessed by anybody with the right user name and password. As my post above shows, I am able to access your Database from My Server, here in my office!

Your Post #34883522, This should not be necessary. You may need to tell us more about what you are actually trying to achieve before we decide... But probably not.
 
0
 

Author Comment

by:STP8377
ID: 34884239
Thanks again.  I deleted the files and changed my password.  I submitted a ticket to the hosting company about the Hello World files not working in the WordPress folder and they fixed the problem.  Before the hello world file only ran in the httpdocs folder now it runs in both.  I named the file helloworld.asp, you can see the results below.  Should I delete these two files right away?
I also backed up the database, just coincidentally.
http://tcmassagereviews.com/helloworld.asp
http://tcmassagereviews.com/wordpress/helloworld.asp
I hope I got both password changed correctly.

I put your new code in a file named new.asp and put it in both folders.  I get a 500 internal server error
0
 
LVL 11

Expert Comment

by:G_H
ID: 34884418
Ok good. Now we have ASP enabled everywhere we stand a better chance.

Two things now:
Do you just get 500 or does it have mote detail? If no extra detail make sure your browser has friendly error messages turned off. Then post the full error.

Also, change from 3.51 to 5.1. Ad we don't know what they are using...

GH
0
 

Author Comment

by:STP8377
ID: 34884477
The error message is below, same message for both folders.  I switched from 3.51 to 5.1 and the error message is the same.
=================
Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.
Please contact the server administrator to inform of the time the error occurred and of anything you might have done that may have caused the error.
More information about this error may be available in the server error log.
0
 
LVL 11

Expert Comment

by:G_H
ID: 34886359
OK, almost exactly as the message says...

Download your W3C logfile, and search for "new.asp", lets see if there is more information in there...

GH
0
 

Author Comment

by:STP8377
ID: 34887488
I have attached the file, I think this is the right file, let me know if it is not. u-ex110213.log
0
 

Author Comment

by:STP8377
ID: 34887533
I also found this file on the server, it looks like it is used for testing, I am including the code in case you think it might be helpful.
<%@ Language=VBScript%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<%
mes=""
IsSuccess = false

sServer = Trim(Request.Form("txtServer"))
sPort = Trim(Request.Form("txtPort"))
sUser = Trim(Request.Form("txtUser"))
sPassword = Trim(Request.Form("txtPassword"))

if Request("__action")="TestDB" then
  TestDB()
end if

Sub TestDB()

  Err.Clear()
  on error resume next
  Set objConn = Server.CreateObject("ADODB.Connection")
  if len(Err.Description)<>0 then
    mes = " " & Err.Description & " MySQL connection can't be established!"
  else
    objConn.ConnectionString = _
    "DRIVER={MySQL ODBC 3.51 Driver};PORT=" & sPort & _
    ";SERVER=" & sServer & _
    ";UID=" & sUser & _
    ";PWD=" & sPassword
    objConn.Open
    if len(Err.Description)<>0 then
      mes = " " & Err.Description & " MySQL connection can't be established!"
    else
      mes = " MySQL connection succesfull established!"
      IsSuccess = true
    end if
  end if
  Set objConn = Nothing
End sub

Sub Alert(html)
  if IsSuccess then
    Response.Write "<div class='testRelults' id='testSuccessful'><span class='testResult'>Success:</span>" & html & "</div>"
  else
    Response.Write "<div class='testRelults' id='testFailed'><span class='testResult'>Fail:</span>" & html & "</div>"
  end if
End Sub
%>
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<title>ASP test page.</title>
<meta name=vs_targetSchema content="http://schemas.microsoft.com/intellisense/ie5">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta http-equiv="Cache-Control" content="no-cache" />
<link rel="shortcut icon" href="favicon.ico" type="image/x-icon" />
<link rel="icon" href="favicon.ico" type="image/x-icon" />
<link rel="stylesheet" type="text/css" href="../../css/style.css" />
<link rel="stylesheet" type="text/css" href="../../css/tabs.css" />
<!--[if lte IE 7]><style type="text/css">#tabs li, #tabs a { display: inline; zoom: 1; } #tabs li { margin: 0; }</style><![endif]-->
<script type="text/javascript" src="/header.js"></script>
<script type="text/javascript">
//<![CDATA[
writeCopyFlag();
//]]>
</script>
</head>
<body>
<div class="page">
  <form id="form1" action="test_mysql.asp?__action=TestDB&tp=<%= rnd(1)*100*timer %>" method="POST">
  <input id="__action" type="hidden" value="" />
  <div class="header clear">
    <script type="text/javascript">
    //<![CDATA[
      if (window.product_copyrights) { writeHeader(window.plesk_promo.virtuozzo); }
    //]]>
    </script>
  </div>
  <div class="wrapper test">
    <div class="pathbar"><a href="/index.html">Site Home Page</a> &gt;</div>
    <h2>ASP possibilities test page</h2>
    <div id="tabs">
      <ul>
        <li class="first" id="current"><a href="test_mysql.asp"><span>MySQL</span></a></li>
        <li><a href="test_mssql.asp"><span>MSSQL</span></a></li>
        <li><a href="test_msaccess.asp"><span>MS Access</span></a></li>
        <li class="last"><a href="test_mail.asp"><span>E-Mail</span></a></li>
      </ul>
    </div>
    <!-- MySQL server -->
    <div class="tab-content clear">
      <p>This page allows to check the connection possibility between the SQL client on your host and one of remote database server. You should have working accounts on the database servers you want to test. Here you can test the connection possibility with the MySQL server.</p>
      <% if len(mes) > 0 then	Alert(mes) end if %>
      <fieldset>
        <legend id="LegendName">Test MySQL Connection</legend>
        <table class="formFields" cellspacing="0" width="100%">
          <tr>
            <td class="name"><label id="lblSource" for="txtServer">Server</label></td>
            <td><input type = text name="txtServer" size = "25" value = "<% Response.Write(sServer) %>"></td>
          </tr>
          <tr>
            <td class="name"><label for="txtPort">Port</label></td>
            <td><input type = text name="txtPort" MaxLength="4" size="5" value="<% if len(sPort)=0 then Response.Write("3306") else Response.Write(sPort) end if%>"></td>
          </tr>
          <tr>
            <td class="name"><label for="txtUser">User name</label></td>
            <td><input type = text name="txtUser" size="25" value = "<% Response.Write(sUser) %>"></td>
          </tr>
          <tr>
            <td class="name"><label for="txtPassword">Password</label></td>
            <td><input type = password  name="txtPassword" size="25"></td>
          </tr>
        </table>
      </fieldset>
      <div class="buttonsContainer">
        <div class="commonButton" id="DBTestButton" title="Test"><button type="submit" name="bname_ok">Test</button><span>Test</span></div>
      </div>
    </div>
  </div>
  </form>
  <div class="footer">
    <div class="footer-area">
    <script type="text/javascript">
    //<![CDATA[
      if (window.product_copyrights) { writeFooter(window.plesk_promo.virtuozzo); }
    //]]>
    </script>
    </div>
  </div>
</div>
</body>
</html>

Open in new window

0
 
LVL 11

Expert Comment

by:G_H
ID: 34887561
OK, this tells me that they have got the 3.51 driver installed, so let stick with that. Delete the 5.1 line.

I can also see that you are connecting to the Database Server using the code, which is also good.

The next thing is the response from the MySQL Server, which is saying:

Access_denied_for_user_'tcmas_rickDB'@'WIN-OHYAI7ESQG3'_(using_password:_YES)

This tells me that the username / password combination is wrong. I have managed to connect with the original password, so I would suggest:

First, try to use the old password. I think this will let you connect.

Second, change the MySQL database password, as this one has been in the public domain.

GH
0
 

Author Comment

by:STP8377
ID: 34887609
I filled out the code previously submitted and I get this page, what do I use for the server name?

 test page
0
 
LVL 11

Expert Comment

by:G_H
ID: 34887681
Post #34887609, use your domain name. I am sure I do not need to tell you, but the user name in the image is wrong...

Have you tried the old password in the "new.asp" file? I am sure this will work

GH
0
 

Author Comment

by:STP8377
ID: 34887686
Should I keep the server as:      DBServer = "tcmassagereviews.com"
this is what it shows in the plesk panel:      Server: localhost:3306
or should I try just   localhost

To change the database password, i change the password in the wp-config.php file right?  
0
 
LVL 11

Expert Comment

by:G_H
ID: 34887971
Try my code (new.asp) first, before anything else. (with the old password).

I mean it!!

AFTER that, try:
DBServer = "localhost"

I think this will work too...

To change the MySQL password, you may have to speak to your host, or you may be able to do this in your "Control Panel".

Changing the password in "wp-config.php" changes the password USED by WP to connect to the database. not the password the database uses to protect itself.

You will need to change the wp-config.php file, but not until after you have sorted the MySQL password elsewhere...

GH
0
 

Author Comment

by:STP8377
ID: 34888641
It works!     just as you said, the new code, etc..  In both folders  httpdocs and the wordpress folder
0
 
LVL 11

Expert Comment

by:G_H
ID: 34888752
Brilliant! OK, now test with the DBServer set to localhost, just to check...
0
 

Author Comment

by:STP8377
ID: 34888876
Still working in both folders with  DBServer set to localhost

I added your code from earlier to display some data from the database, just to see and it worked, you can see the results at:    http://tcmassagereviews.com/newd.asp
(the file is named newd because I started with newa, newb, newc)
=================== code added =============
'' ## Creta some sql
sqlA = "SELECT Subject, Venue FROM tutorials_meetings"
'' ## Set the recordset
Set rsA = Conn.execute(sqlA)
'' ## Loop the recordset
while NOT(rsA.EOF)
'' ## Write something to screen
response.write rsA("Subject") & "<br />"
rsA.movenext
wend
rsA.close
Set rsA = nothing
0
 
LVL 11

Expert Comment

by:G_H
ID: 34888987
OK, now we have fully working code, using the principal of minimum changes, we need to get the Database Password changed.

I can still connect to your database, from here, so I know the current password is the one which was diplayed on line for a while.

I am not sure how you go about changing this, but I guess you have a "Hosting Control Panel" where you can change the "MySQL Database Password". IF this is the case, this needs doing next.

You should be able to prove that the change has been made, because the ASP script will not work any more.

Please post back when you have done this...

GH
0
 

Author Comment

by:STP8377
ID: 34891753
Still waiting for hosting company to figure out how to change the password.
0
 
LVL 11

Expert Comment

by:G_H
ID: 34892645
Lol, that's a good advert for webhostingworld.
0
 

Author Comment

by:STP8377
ID: 34893343
whw tells me that the database password cannot be changed.  They say the only option is to delete or uninstall WordPress and do a fresh installation.    Unless I find out differently, I will do another backup just to be safe and uninstall/reinstall and then upload/restore my backup.  I've tried changing every password that know of and I tried all the Google  and Wordpress support forum suggestions.
0
 

Author Comment

by:STP8377
ID: 34897177
I will close this question soon.  I really, really appreciate the huge amount of effort and troubleshooting you did G H.  Thank for sticking it out and getting this fixed.  
What do you think was the problem?  Or, was it a lot of little things, syntax, etc.

I will take care of the password problem in the next few days, I will do one of several options, I installed wp into a subfolder by mistake so I will most likely backup/copy everything and then wipe everything out and reinstall wp at the main level.
0
 
LVL 11

Expert Comment

by:G_H
ID: 34897828
I think there were lots of issues here...

1. Poor support from the hosting company - not telling you the server address (you.domain or localhost).
2. Poor support from the hosting company - not telling you which connector (3.51) they have installed.
3. Poor advice from GH (LOL) - not telling you to put your code inside <%%>
4. Poor service from the hosting company, not providing ASP on all of your web-space.
5. Your poor understanding of code (don't take this the wrong way - we all start at the beginning). You are also doing the right thing, which is learning from the process, that is good to see. Too many people ask questions here to *just* get a solution, whereas they would be better off learning something!

So on the plus side...

1. I think the code provided will help you connect to your database.
2. I think you have learnt about how these connections done, and now understand the terminology.
3. I think you have probably learnt a lot about de-bugging as well...

So good luck with your PW change...

Happy programming,

GH
0

Featured Post

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

Both Easy and Powerful How easy is PHP? http://lmgtfy.com?q=how+easy+is+php (http://lmgtfy.com?q=how+easy+is+php)  Very easy.  It has been described as "a programming language even my grandmother can use." How powerful is PHP?  http://en.wikiped…
Creating and Managing Databases with phpMyAdmin in cPanel.
The purpose of this video is to demonstrate how to Test the speed of a WordPress Website. Site Speed is an important metric of a site’s health. Slow site speed can result in viewers leaving your site quickly and not seeing your content. This…
The purpose of this video is to demonstrate how to Import and export files in WordPress. This will be demonstrated using a Windows 8 PC. Go to your WordPress login page. This will look like the following: mywebsite.com/wp-login.php : Click on Too…

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now