Access a in house sql server from a remote web server

does anybody know how I would create a connection string in asp.net 2.0express to access a database in a different location from the webserver. I have a static IP address on the web server, so I've allowedaccess from the web server through the firewall. I have a user name andpassword, and I've made sure that I have the correct database. Would Iaccess the database using the network IP address and if so, where do Iput it. Thank you to anyone that can give me some insight to thisproblem, I'm very new to asp.net so, about a weeks worth of knowledge,so if you could explain as such I would appreciate it.
Seewww.connectionstrings.com. You put the IP where you normally put the Server name, all else should be the same. That said, hitting a SQL Server on the other side of a firewall may not be the best thing to do.|||thanks
"That said, hitting a SQL Server on the other side of a firewall may not be the best thing to do."
what you recommend then, like I said, I'm pretty new to this. Theproject that I'm working on requires me to create a web form, that ison an outsourced web server, and import the data into our database thatis behind a firewall. Would this be a security issue?

|||Yes, it can be. If SQL Server was perfect, it would not be a problem to leave the SQL port open. SQL Server is not perfect (recall the Slammer virus). So, in the circumstances you describe, perhaps it is your only option. However, I would make very certain that the database server is always patched up to date.sql

Absolute position or location of report table.

Hello,

I have a report that prints cards for customers. The body of the report contains an address box, letter body, followed by a table that contains all the people to be printed on the cards. If the number exceeds 6 people, another page is to be printed, with no address or letter body, but the table with the remainder of the people on it.

I have been able to get everything to work except for the location of the table on the subsequent pages. They do not appear at the bottom as they do on the first page, but at the top of the page. I've tried using a rectangle as a container for the table, with no luck.

I seem to remember doing this in the past, but as projects get shelved for an extended period of time, the technical knowledge tends to fade.

Any suggestions would be greatly appreciated. Thanks

Have you tried setting both PrintOnFirstPage and PrintOnLastPage to true? This is described here:

http://msdn2.microsoft.com/en-us/library/aa178940(SQL.80).aspx

If you don't want header labels to show on the second and subsequent pages, then put them all inside of one container element and set its Hidden property to true if the PageNumber is > 1. This way the header area will still be rendered but everything in it is invisible.

sluggy

About the location of database file.

I can install the SQL Server Express in a computer and locate the database files in another computer of the same local network?

No, you cannot.

The datafiles have to be on a local drive -NOT a mapped drive, or even an UNC share. (A properly configured NAS/SAN is different though.)

About storing and receiving a location from SQL SERVER.....................

hi friends,

i want to store an image in DB. but most of my friends told that, to store an image in web server then store tat location in a DB and access it anywhere. this is for asp.net in C#-code behind. how to do this? i've a table with a text field. then ......? waiting for ur reply.........

note: i need coding. not by using controls. pls...

Hi,

if you want store the image on DB, you can pass it asSqlDbType.Image, and assign a byte array to the field to be saved.

cmd.Parameters.Add("@.Image",SqlDbType.Image, 0,"Image_Data");

DataRow row = new ...

row.Image_Data =File.ReadAllBytes(pathToFile); //assuming you uploaded it and saved it somewhere.

//your update command

Hope this help

About Sql Server 2005

Does anyone know when such version will be available in this world?
I mean, no beta, ctp, bla,bla
--
current location: alicante (es)Enric
SQL Server 2005 was finaly released on 7 November 2005, what did you mean?
"Enric" <Enric@.discussions.microsoft.com> wrote in message
news:DD3938E7-141D-442A-A90C-42D565495EF2@.microsoft.com...
> Does anyone know when such version will be available in this world?
> I mean, no beta, ctp, bla,bla
> --
> current location: alicante (es)|||jesus christ, am I living where I am living?
--
current location: alicante (es)
"Uri Dimant" wrote:

> Enric
> SQL Server 2005 was finaly released on 7 November 2005, what did you mean?
> "Enric" <Enric@.discussions.microsoft.com> wrote in message
> news:DD3938E7-141D-442A-A90C-42D565495EF2@.microsoft.com...
>
>