Sunday, March 25, 2012

access data at web server

I have placed my sql server database files on the database webspace given for my site. I am not being able to access the tables residing in my database on web.

Same database is working well at my localhhost. Why am i getting this kind of error?

Please explain "webspace given for my site" - - is this a hosted site, etc?

what error are you actually getting?

|||

The webspace given is a www folder and a db folder. www folder to keep all my aspx pages and db to keep my sqlserver database files .

The name of my database files are dodg_data.mdf and dodge_log.ldf The database name and user id given by my webhost is different , I have changed my file names according to that before uploading.

My database is not being accessed at all. I am getting inavalid object name'detail' error . detail is my tablename.

same database is working with my localhost.

I need help...........

|||

augustwind:

Please explain "webspace given for my site" - - is this a hosted site, etc?

what error are you actually getting?

The webspace given is a www folder and a db folder. www folder to keep all my aspx pages and db to keep my sqlserver database files .

The name of my database files are dodg_data.mdf and dodge_log.ldf The database name and user id given by my webhost is different , I have changed my file names according to that before uploading.

My database is not being accessed at all. I am getting inavalid object name'detail' error . detail is my tablename.

same database is working with my localhost.

I need help...........

|||You need to work with your host on this. They have most likely NOT given you a database folder for your SQL Server database, as this would imply that they would allow you to use SQL Express 2005, which most hosts would not do. They have instead likely given you space on their SQL Server. You would need to connect to this SQL Server and transfer your database to it.|||

tmorton:

You need to work with your host on this. They have most likely NOT given you a database folder for your SQL Server database, as this would imply that they would allow you to use SQL Express 2005, which most hosts would not do. They have instead likely given you space on their SQL Server. You would need to connect to this SQL Server and transfer your database to it.

Hi Terri,

But i am not getting it.Is keeping database files into the folder given is not enough. how can i get connected to their server. I am using connection string with username and password given by them.

No comments:

Post a Comment