Database

Re: how do I find the IP of the 2005 sql server instance?

7-May-10 5:09

The problem is that you're asking Sql server where Sql server is located. The name "ADMIN-PC" points to an IP-adress. Your data source would be "ADMIN-PC\SQL2005", or something similar.

It may very well be that you require the IP-adress to connect from the PDA to the server. That requires you to know at least the connection-details of your server, and it will require a network-connection.

I are Troll Suspicious | :suss:

Tunisien867-May-10 5:18

Re: how do I find the IP of the 2005 sql server instance? [modified]

7-May-10 5:18

Hi Eddy,
If the name of my server in sql server is:ADMIN-PC (SQL Server 9.0.1399 - sa),what sould be the datasource field???is it like that:

string sConnection = "Data Source= ADMIN-PC\\SQL Server 9.0.1399 - sa,1433;Initial Catalog=GMAO;User ID=sa;Password=sa;";

Thanks for u clarification

Eddy Vluggen7-May-10 5:24

Re: how do I find the IP of the 2005 sql server instance?

7-May-10 5:24

Something along these lines;

string sConnection = "Data Source= ADMIN-PC\\SQL2005;Initial Catalog=GMAO;User ID=sa;Password=sa;";

or, for the default instance;

string sConnection = "Data Source= ADMIN-PC;Initial Catalog=GMAO;User ID=sa;Password=sa;";

..and no, it's not going to be that simple. Take a deep breath and make some coffee Smile | :)

--edit;
Location and instance-name of Sql Server are determined when you install it[^].

Your PDA-application needs to "know" where this server is, and it needs to be in the same network as that computer. At this moment I'm still wondering whether you have network-connectivity between those two.

I are Troll Suspicious | :suss:

modified on Friday, May 7, 2010 11:34 AM

Tunisien867-May-10 22:43

Re: how do I find the IP of the 2005 sql server instance?

7-May-10 22:43

Hi Eddy,
I have not a real PDA to check.I wanna use only the emulator on my application.
Also I changed my code someway:

string adr="SELECT @@SERVERNAME AS 'Server Name';";
string sConnection = "Data Source=" + adr + ",1433;Initial Catalog=GMAO;User ID=sa;Password=sa;";

but not knowing my SQL SERVER
If I installed saye my sql server and don't get the info about the instance,noway to know it after????
I am really boulversing
Thanks D'Oh! | :doh:

Eddy Vluggen8-May-10 2:17

Re: how do I find the IP of the 2005 sql server instance?

8-May-10 2:17

Tunisien86 wrote:
If I installed saye my sql server and don't get the info about the instance,noway to know it after????

Well, you can, using the very same SQL statement that you're posting.

Open Sql Management Studio Express, and connect to the server
Start a new query
Execute the statement SELECT @@SERVERNAME

That would result in a string in the format "Computername/Instancename".

I'd recommend creating a small application to do a simple select against that server; It's easier to build and limits the scope of the problem to "connect to Sql Server from a PDA".

I are Troll Suspicious | :suss:

Tunisien868-May-10 4:47

Re: how do I find the IP of the 2005 sql server instance?

8-May-10 4:47

Hi Eddy,

I found the solution ther in this post:
http://www.sqlservercentral.com/Forums/Topic918470-323-1.aspx?Update=1[^]
My string connection is like that now:

string sConnection = @"Data Source=Admin-PC\MSSQLSERVER,1433;Initial Catalog=GMAO;User ID=sa;Password=sa;";

(But Eddy still some problems in my TCP/IP connection Cry | :((

)
Thanks

Eddy Vluggen8-May-10 5:39

Re: how do I find the IP of the 2005 sql server instance?

8-May-10 5:39

Tunisien86 wrote:
I found the solution ther in this post:
My string connection is like that now:

That's looking better Smile | :)

Tunisien86 wrote:
But Eddy still some problems in my TCP/IP connection

There's some bumps on the road, but we can tackle them one atta time. I'd suggest starting with a "New Project", and to create a small prototype application that connects to the server and displays the results of the query, or the Exception if one is generated.

Your connectionstring should be enough to allow you to create a SqlConnection.

I are Troll Suspicious | :suss:

Tunisien868-May-10 5:56

Re: how do I find the IP of the 2005 sql server instance?

8-May-10 5:56

Hi Eddy,
As u told me,I open a new thread:SQL server name not found:Admin-PC\MSSQLSERVER,1433
but still not working yet Cry | :((

Thanks Eddy
(after this long collaboration between as i suggest if u like we meet in msn or skype as freinds ok Laugh | :laugh:

my skype is :elgafsiensi and my msn is:marwenG@hotmail.fr)

Eddy Vluggen8-May-10 8:23

8-May-10 8:23

Tunisien86 wrote:
As u told me,I open a new thread:SQL server name not found:Admin-PC\MSSQLSERVER,1433

Not a new thread, but a new project Smile | :)

A small application to "prove" that it works and to test whether all settings are correct.

Tunisien86 wrote:
but still not working yet

You know the drill; we'd need code and an exception-message to diagnose something.

Tunisien86 wrote:
Thanks Eddy(after this long collaboration between as i suggest if u like we meet in msn or skype as freinds ok

You're welcome. I'll add you to the list, I'm online once or twice every month Smile | :)

I are Troll Suspicious | :suss:

spatial database

hotthoughtguy6-May-10 7:57

hotthoughtguy

6-May-10 7:57

hi
i want to make a GIS application in .net 4.0
can any one provide me the Link of how to create spatial database in SQL 2005
and connecting it with c#

Re: spatial database

Bassam Saoud6-May-10 8:40

Bassam Saoud

6-May-10 8:40

Spatial is new to SQL SERVER 2008. here is a tutorial[^]

Re: spatial database

Abdul-Rhman Alsri6-May-10 9:11

search in database- do you have other than "like" ? [modified]

6-May-10 9:11

visit:

http://www.cise.ufl.edu/~mschneid/Service/Tutorials/TutorialSDT.html[^]

Re: spatial database

hotthoughtguy6-May-10 9:13

hotthoughtguy

6-May-10 9:13

thank u so much
jazak ALLAH

Abdul-Rhman Alsri6-May-10 7:24

Re: search in database- do you have other than "like" ?

6-May-10 7:24

When we search with for "mobile" word, using "like" as follows:

select ID from Table where column like '%mobile%'

we can get: mobile, bile.

But we can not get mobility or mobilization in result, even though they are related words for mobile word we are searching for.

So, Do you have solutions to handle those related words, I mean when search for mobile, we can get in result the words mobility and mobilization?

modified on Thursday, May 6, 2010 3:07 PM

Chris Meech6-May-10 9:29

Chris Meech

6-May-10 9:29

Abdul-Rhman Alsri wrote:
related words for mobile word

Someone needs to define that relationship.
One way is to include that in your query

select ID from Table where column like '% mobile %'
                        or column like '% mobilization %'
                        or column like '% mobility %'
;

Chris Meech
I am Canadian. [heard in a local bar]

In theory there is no difference between theory and practice. In practice there is. [Yogi Berra]

Re: search in database- do you have other than "like" ?

Abdul-Rhman Alsri6-May-10 9:33

Re: search in database- do you have other than "like" ?

6-May-10 9:33

I need it in general, because the word I search for is not determined explicity, but it's also retrieved from database.

SELECT a.id AS [CampaignID],
       b.id AS [ZoneID],
       a.adheadline,
       a.adtext,
       a.displayurl,
       a.targeturl
FROM   adcampaign a
       INNER JOIN adzone b
         ON a.sitecategory = b.category
            AND a.LANGUAGE = b.LANGUAGE
            AND a.keyword LIKE '%' + b.keyword + '%';

Chris Meech6-May-10 9:57

Chris Meech

6-May-10 9:57

Perhaps another table that links similar words is needed. Smile | :)

Chris Meech
I am Canadian. [heard in a local bar]

In theory there is no difference between theory and practice. In practice there is. [Yogi Berra]

Re: search in database- do you have other than "like" ?

T M Gray6-May-10 10:45

T M Gray

6-May-10 10:45

What database product are you using? If you are using MS SQL you can use things like SOUNDEX and FREETEXT.

Re: search in database- do you have other than "like" ?

Abdul-Rhman Alsri8-May-10 16:12

GetChanges( ) - Not returning null

8-May-10 16:12

SELECT id FROM AdCampaign WHERE FREETEXT(Keyword, 'going');

Error:
Cannot use a CONTAINS or FREETEXT predicate on table or indexed view 'AdCampaign' because it is not full-text indexed.

gmhanna6-May-10 4:42

gmhanna

6-May-10 4:42

One of the things I did in VS2008, was to call GetChanges on the dataset during the FormClosing event to determine if changes have been made but not saved. Doing this in VS2010 always returns a non-null value even if the dataset has not been changed. This is causing the user to be prompted if they want to save their changes even though they just selected the SAVE icon from the application which saves any changes. I even tried calling AcceptChanges but I still get a non-null value coming back from GetChanges.

Is this a bug, or did something change in VS2010. Is there another way to check this?

Thank you,

Glenn

Update Error

msomar6-May-10 4:00

msomar

6-May-10 4:00

When I click button Update this error is cccurred :
Exception Details: System.Data.SqlClient.SqlException: Incorrect syntax near 'nvarchar'.
my SqlDataSource is:

<asp:SqlDataSource ID="SqlDataSource1" runat="server" 
            ConnectionString="<%$ ConnectionStrings:AdNetConnectionString %>" 
            SelectCommand="SELECT AdCampaign.CampaignName, AdCampaign.AdType AS [Campaign Type], AdCampaign.Date AS [Start Date], AdCampaign.Clicks, AdCampaign.Impr, AdCampaign.DailyBudget AS [Daily budget] , AdCampaign.Status FROM Account INNER JOIN AdCampaign ON Account.ID = AdCampaign.AccountID WHERE (Account.EmailAddress = @EmailAddress)" 
            UpdateCommand="UPDATE AdCampaign SET DailyBudget = 30 FROM Account INNER JOIN AdCampaign ON Account.ID = AdCampaign.AccountID WHERE (Account.EmailAddress = @EmailAddress)">
            <SelectParameters>
                <asp:SessionParameter Name="EmailAddress" SessionField="EmailAddress" />
            </SelectParameters>
            <UpdateParameters>
                <asp:Parameter Name="EmailAddress"   />
            </UpdateParameters>
            </asp:SqlDataSource>

the parameter :

<asp:Parameter Name="EmailAddress"   />

is a session parameter.

I am waiting please guide me.

Re: Update Error

loyal ginger6-May-10 5:35

loyal ginger

6-May-10 5:35

When you click the Update button, some other command was executed. Since I don't see a statement containing "nvarchar" in the code you have posted, I believe you have hooked up the event handler to somewhere else. You can track down the problem using your debugging environment and pinpoint the problematic statement.

Re: Update Error

Vimalsoft(Pty) Ltd6-May-10 10:51

Vimalsoft(Pty) Ltd

6-May-10 10:51

I don't use Wizards to do my database work. But this parameter isn't supposed to have a data type ?

Vuyiswa Maseko,

Spoted in Daniweb-- Sorry to rant. I hate websites. They are just wierd. They don't behave like normal code.

C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.com
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/

Correct this sql

Abdul-Rhman Alsri6-May-10 3:52