Skip navigation
Currently Being Moderated

Need help establishing a connection within DW to SQL2005 database on godaddy.com

Jul 10, 2008 12:09 AM

i have the connection string setup within my connections file and if i
handcode the displaying of my recordset, the page works once uploaded.. but
im use to having the ability to make my selection of tables and stored
procedures from the dreamweaver windows..

Right now if i try to open the Bindings list i get an error HTTP Error
Code 400 Bad Request

with that i cant select my column names and bind them to the page..

Has anyone been able to make a connection to the SQL database and use these
features withing DW?

I really dont have the time to ref my table and column layouts to hand code
every field i want displayed on the page and such.. any ideas or suggestions
would be great...

Also, when i upload the pages, they work fine, so i know my connection is
working, but not locally. If i setup a Custom Connection String that doesnt
work either..

--
************************************************
ASP, SQL2005, DW8 VBScript, Access


 
Replies
  • Currently Being Moderated
    Jul 10, 2008 9:32 AM   in reply to Newsgroup_User
    Yes! I've been successfully able to connect to GoDaddy MySQL database. But only through lots of trial and error and only through help with customer support. First off, what kind of server do you have with them? Is it a shared hosting or is it virtual dedicated or dedicated. The method is hugely different with each one. I'm checking this regularly because I'm trying to get a question answered, so let me know and I'll try to share the knowledge.
     
    |
    Mark as:
  • Currently Being Moderated
    Jul 10, 2008 10:06 PM   in reply to Newsgroup_User
    I was able to connect to the MySQL database by going to my godaddy database list in the hosting control center. I picked the database I wanted and clicked on the "pencil" to view the details of the database. Then I clicked on the configuration icon. I highlighted the entire box of ODBC 3.51 settings and copied them to the connection string. I was able to connect and to test. it shows all tables, but now when I go to live view I get an error message that says "Microsoft VBScript compilation error 800a0408 invalid character"
     
    |
    Mark as:
  • Currently Being Moderated
    Jul 11, 2008 3:58 AM   in reply to Newsgroup_User
    Thanks for the great information
     
    |
    Mark as:

More Like This

  • Retrieving data ...

Bookmarked By (0)