i want to work on both (internet & sql server) simoultaniously.

hi friends

DNS entry is a must in my PC to connect to internet but i canot connect to an MS SQL database server
installed on another machine on same lan. but if i remove DNS entry in my PC i could connect to MSSQLServer but i canot connect internet. i want to work on both simoultaniously.
some one please suggest what to do ..?

stephen

HI,

I had the same thing @. my home. IM having two servers primary and secondary

Primary server --> internet connection available & shared my internet connection and installed sql2005

Secondary server --> I can connect to internet and i can connect to sql using primary server name from this sys

Both the sys are in one-2-one LAN connection and having two ehternet adapaters on primary sys, one for connecting to internet and another one for connecting secondary sys.

i had enabled "share internet option" on the ethernet card that is used to connect to internet in primary sys.
|||hi vidhya sagar

thank you for your reply..

let me go through it..

stephen

I want to make formula in business Intelligence Project

Hi Friends,
I want to make formula in business Intelligence Project like as we make
formula in Crystal report.
Thanks,
AlexWell if I understand your question correctly you want to convert a Crystal
formula to RS. I had a lot of trouble with this as well and without doing
custom code that I'm not experienced with you are going to have to move to
single line vb .net functions in order to get your functionality.
The one that I have used the most is the =Iff statement as it lets you test
and chose 2 results and you can nest them inside each other. Here is a link
to the Microsoft MSDN Reference and some text from the link:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vblr7/html/vafctiif.asp
Visual Basic Language Reference IIf FunctionReturns one of two objects,
depending on the evaluation of an expression.Public Function IIf( _
ByVal Expression As Boolean, _
ByVal TruePart As Object, _
ByVal FalsePart As Object _
) As ObjectExampleThis example uses the IIf function to evaluate the TestMe
parameter of the CheckIt procedure and returns the word "Large" if the
amount is greater than 1000; otherwise, it returns the word "Small".Function
CheckIt (ByVal TestMe As Integer) As String
CheckIt = IIf(TestMe > 1000, "Large", "Small")
End FunctionGood luck,Dan"Alex Smith" <sam@.gmail.com> wrote in message
news:ODPzlaGfFHA.2372@.TK2MSFTNGP14.phx.gbl...
> Hi Friends,
> I want to make formula in business Intelligence Project like as we make
> formula in Crystal report.
> Thanks,
> Alex
>