locked
Web.config ConnectionString RRS feed

  • Question

  • User699643714 posted

    Hi,

    I have an app that runs great on my machine accessing Access 07 data. I'm trying to host it on godaddy and they gave me a dsn for the database. I've tried all kinds of things and looked for answers to no avail. Any help would be greatly appreciated.

    Thank you

    Tuesday, April 20, 2010 3:00 PM

Answers

  • User-1199946673 posted

    All over the internet, you'll find many problems regarding Godaddy. A very common complaint is that they refuse to install anything on their server, so I doubt that they have the ACE provider installed that is need to use an Access 2007 database. Instead, I would save your file as a mdb file, then you could use the standard Jet 4.0 OleDb provider

    http://www.mikesdotnetting.com/Article/78/AccessDataSource-SqlDataSource-and-connecting-to-Access-databases-in-ASP.NET

    In this article it is recommended to place the database in the App_Data folder. However, form what I understand, this doesn't work on Godaddy, because the ASP.NET user doesn't have modify rights on this folder (to create the ldb file), and Godaddy will not set this permissions for you. Instead, they provide an Access_db folder outside of the root, all you need to do is use the full path in the connectionstring

    http://forums.asp.net/p/1546360/3788262.aspx#3781136

    But a better option is to move to another host that doesn't impose all kinds of limitations and a better customer service. I really can't believe that you, and many other Godaddy clients need to ask these kinds of questions on a public forum, which need to be answered and solved by your host!

     

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Tuesday, April 20, 2010 4:33 PM

All replies

  • User-1199946673 posted

    All over the internet, you'll find many problems regarding Godaddy. A very common complaint is that they refuse to install anything on their server, so I doubt that they have the ACE provider installed that is need to use an Access 2007 database. Instead, I would save your file as a mdb file, then you could use the standard Jet 4.0 OleDb provider

    http://www.mikesdotnetting.com/Article/78/AccessDataSource-SqlDataSource-and-connecting-to-Access-databases-in-ASP.NET

    In this article it is recommended to place the database in the App_Data folder. However, form what I understand, this doesn't work on Godaddy, because the ASP.NET user doesn't have modify rights on this folder (to create the ldb file), and Godaddy will not set this permissions for you. Instead, they provide an Access_db folder outside of the root, all you need to do is use the full path in the connectionstring

    http://forums.asp.net/p/1546360/3788262.aspx#3781136

    But a better option is to move to another host that doesn't impose all kinds of limitations and a better customer service. I really can't believe that you, and many other Godaddy clients need to ask these kinds of questions on a public forum, which need to be answered and solved by your host!

     

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Tuesday, April 20, 2010 4:33 PM
  • User699643714 posted

    Thanks Hans, I thought they were a premiere hosting service, guess not. I'll pay someone else gladly for their customer service. Thanks again.

    Tuesday, April 20, 2010 7:25 PM