472,353 Members | 1,020 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,353 software developers and data experts.

>> 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 1401
"< 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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

28
by: prunoki | last post by:
Hello, I am an SQL server newbie. Our company has a massive application written in PL/SQL. I need to port parts of it to SQL Server. - Which...
1
by: Davey | last post by:
I have an MS Access 2003 database that uses a SQL Server 2000 database as it's back-end. The database runs well most of the time but if the users...
1
by: BuddyWork | last post by:
Hello, When a particular user (has administrator rights) on a Windows 2000 Server SP4 tries to run any MSI's we get the message mentioned in the...
14
by: Mark B | last post by:
Our webhost (www.usbusinessweb.net) had a W2K IIS5 server crash after a scheduled hard-boot occurred during a ms-security patch install overnight....
3
by: pb648174 | last post by:
I recently needed to upgrade a sql 2000 machine to 2005. Instead of upgrading the sql 2000 default instance, I installed sql 2005 as a separate...
2
by: adambossy | last post by:
I have a nasty situation in SQL Server 7.0. I have a table, in which one column contains a string-delimited list of IDs pointing to another table,...
0
by: TechWitch | last post by:
I've seen a number of posts from frustrated folks about this topic, with not much offered as a solution. I actually managed to get this to work...
11
by: raylopez99 | last post by:
Keep in mind this is my first compiled SQL program Stored Procedure (SP), copied from a book by Frasier Visual C++.NET in Visual Studio 2005...
1
by: sebastien1101 | last post by:
I have to produce a new application using now Visual Studio 2005 & Sql server 2005 express Before with VS2003 i use the msde Boostraper to deploy...
1
by: Kemmylinns12 | last post by:
Blockchain technology has emerged as a transformative force in the business world, offering unprecedented opportunities for innovation and...
0
jalbright99669
by: jalbright99669 | last post by:
Am having a bit of a time with URL Rewrite. I need to incorporate http to https redirect with a reverse proxy. I have the URL Rewrite rules made...
0
by: antdb | last post by:
Ⅰ. Advantage of AntDB: hyper-convergence + streaming processing engine In the overall architecture, a new "hyper-convergence" concept was...
0
by: Matthew3360 | last post by:
Hi there. I have been struggling to find out how to use a variable as my location in my header redirect function. Here is my code. ...
2
by: Matthew3360 | last post by:
Hi, I have a python app that i want to be able to get variables from a php page on my webserver. My python app is on my computer. How would I make it...
0
hi
by: WisdomUfot | last post by:
It's an interesting question you've got about how Gmail hides the HTTP referrer when a link in an email is clicked. While I don't have the specific...
0
by: Matthew3360 | last post by:
Hi, I have been trying to connect to a local host using php curl. But I am finding it hard to do this. I am doing the curl get request from my web...
0
by: Carina712 | last post by:
Setting background colors for Excel documents can help to improve the visual appeal of the document and make it easier to read and understand....
0
BLUEPANDA
by: BLUEPANDA | last post by:
At BluePanda Dev, we're passionate about building high-quality software and sharing our knowledge with the community. That's why we've created a SaaS...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.