Last post Mar 22, 2008 11:24 AM by wisecarver
Mar 11, 2008 01:52 PM|bjagdeesh|LINK
When I work offline I am able to connect to my local database, and there no problem in working.
Sir recently I had developed and hosted one web site, in my ftp control I am having sqldatabase, I don't know how to connect this database. I would like know how to pass the connectionstring in the webconfig file to connect this database which exists
in my control panel.
Mar 11, 2008 02:08 PM|wisecarver|LINK
Who is your Host?
Mar 11, 2008 02:23 PM|bjagdeesh|LINK
Sir recently I had developed and hosted one web site, in my ftp control I am having sqldatabase, I don't how to connect this database. I would like know how to pass the connectionstring in the webconfig file to connect this database which exists in my
my host name is mysqlblade1.ebiz4india.us
Mar 11, 2008 02:56 PM|Enroth|LINK
Your hosting provider should have a FAQ or Knowledge Base on its site. Also you can ask your hoster's support team. If the support is useless and no answer in the FAQ, change your hosting provider. Two of them which do know the answer to your question are:
Mar 11, 2008 03:24 PM|wisecarver|LINK
I tried to take a look for you but it doesn't appear they have customer FAQs online:
You may however have access to the information you need from your control panel login.
Mar 12, 2008 12:16 AM|bjagdeesh|LINK
I had made login to my control panel, I had created database login name and
My main problem is I am unable to write connection string in my web config file, as a result I am unable to link to my database.
If you want more details I am ready to provide details of my control panel.
Please kindly help me in this regard.
Mar 12, 2008 10:36 AM|wisecarver|LINK
Please do not post your sensitive user information. (Such as username and password)
You will find many people here who can help however logging into your account may be beyond that scope.
If your host does not respond to your requests for support please let us know, but make that your first step.
Mar 21, 2008 06:02 PM|amritrr|LINK
Hello Jagdish, your hosting provider must have given you access to some sort of control panel. You will need to login to your control panel and make an online database. While creating the database, it will ask you to name this database. Give it a name. It
will then ask you to create a user and will ask you for a username and password. Remember this username and password. Also ask your hosting provider the ip address to use.
So now you have four things databse name, username, password, and the i.p. to be used. You need to replace this info in the connections string in your web.cofig file and upload that web.config to your remote server. Now finally you will need to export your
database to the one you just created remotely. You can do this by right clicking your local database file and select Export and follow the steps thereafter. I hope this helps somehow.
Mar 22, 2008 10:20 AM|bjagdeesh|LINK
When I right click my local database file and select export and followed the steps accordingly, while following the steps it had given me the following error
your database server setting doesn't allow to access to remote database>
I am at present using sql server 2005 express edition.
According to you I had created database, username,.and password, I am having IP address for my database also.
I required help in this regard.
Mar 22, 2008 11:24 AM|wisecarver|LINK
If your Host supports Linq to SQL Server features you can easily perform some amazing feats.
http://discountasp.net fully supports Linq on IIS6 and the new Windows Server 2008 accounts, I'm having a blast with it.
Honestly, it's a lot of fun to work with. [;)]