468,278 Members | 1,582 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,278 developers. It's quick & easy.

>> SQL Server 2005 Database Problem with ASP.Net

hii all,

im new on ASP.Net and working on a website project now. im using Visual
Studio.Net 2005(c#.net) and SQL Server 2005.

i made a connection to database from Default.aspx, and my connection
string is

myConnection = new SqlConnection("server =(local); uid =sa;
password=bilsekbiz; database=KIMLIK");

its working on my local server.

i have tryied to send my project to internet to try if it is working or
not, i have sent my project files with CuteFTP
but i realized that i dont know where i ll put my databse on internet.

what must i do to be able to make it working on internet ???

Thanks for now....

Nov 28 '06 #1
2 1309
"< g n d z k d r >" wrote:
its working on my local server.

i have tryied to send my project to internet to try if it is working or
not, i have sent my project files with CuteFTP
but i realized that i dont know where i ll put my databse on internet.
This depends on the way your webhost has configured your account. Have a
look in their support pages which some give you some pointers as to how to
manage your database.
Nov 28 '06 #2
"< g n d z k d r >" <gn*****@gmail.comwrote in message
news:11**********************@n67g2000cwd.googlegr oups.com...
im new on ASP.Net and working on a website project now. im using Visual
Studio.Net 2005(c#.net) and SQL Server 2005.

i made a connection to database from Default.aspx, and my connection
string is

myConnection = new SqlConnection("server =(local); uid =sa;
password=bilsekbiz; database=KIMLIK");

its working on my local server.
Well, first things first: I can't imagine anyone would be so stupid as to
actually publish their database password on an Internet newsgroup but, if
you have, the first thing you need to do is change it...
i have tryied to send my project to internet to try if it is working or
not, i have sent my project files with CuteFTP
but i realized that i dont know where i ll put my databse on internet.

what must i do to be able to make it working on internet ???
Secondly, when you say "send my project to internet", I presume you mean
that your public site is hosted with a 3rd-party service provider. If so,
then they will need to create the SQL Server database for you, after which
you will need to deploy it. Maybe you can register the live SQL Server in
Enterprise Manager, in which case it should be a simple matter to script
your local copy and create the live one.

Thirdly, you will need to modify your connection string to point at the live
server.
Nov 28 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

28 posts views Thread by prunoki | last post: by
reply views Thread by NPC403 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.