Re: Creating Web Service in C# - C# Discussion Boards

4-Nov-07 5:46

typing in

<%@ WebService Language="C#" Class="StockQuote.XPlatformServices" %><br />

at top of code page but it does not like this for some reason i am using 2005 web developer, but coding from an old book, can anyone please help

The web service will be crossplatform.

1. keyword,identifier, or string expected after verbatim specifier:@
2. A namespace does not directly contain members such as fields or methods

Please HELP

Thank You

pmarfleet4-Nov-07 6:13

4-Nov-07 6:13

Where have you put the @WebService directive? In your .asmx file? Or in your .asmx.cs file?

Paul Marfleet

"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush

kendo174-Nov-07 6:48

4-Nov-07 6:48

in the service.cs file

kendo174-Nov-07 7:06

4-Nov-07 7:06

When i enter the code in the .asmx file it it comes back with error when i build it; could not create type 'StockQuote.XPlatformServices'

Any Ideas.
Is it that this code does not run from within the program where it is created that it requires to be called from another platform language. Confused | :confused:

pmarfleet4-Nov-07 7:09

4-Nov-07 7:09

In the code-behind file for your webservice, you should create a class called XPlatformServices that belongs to the StockQuote namespace.

Paul Marfleet

"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush

pmarfleet4-Nov-07 7:07

4-Nov-07 7:07

The WebService directive should only go in the .asmx file. The .cs file i only for your C# code. If you create your web service using Visual Studio, the .asmx file is automatically generated for you. You shouldn't need to modify the directive yourself.

Paul Marfleet

"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush

kendo174-Nov-07 7:10

4-Nov-07 7:10

i altered the asmx as so i can call the web service from another language platform Java.

I understand that this is the code that i need but dont know what is the correct way to use it.

pmarfleet4-Nov-07 7:14

Re: Creating Web Service in C# [modified]

4-Nov-07 7:14

kendo17 wrote:
I understand that this is the code that i need but dont know what is the correct way to use it.

I don't understand what you mean. Is there still a problem with your .asmx file? If so, post your code.

Paul Marfleet

"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush

kendo174-Nov-07 7:45

4-Nov-07 7:45

this is the code i am using in the asmx file i have saved it as SimpleStockQuote and it is on my C:

<%@ WebService Language="C#" Class="SimpleStockQuote.XPlatformServices" %>

-- modified at 13:53 Sunday 4th November, 2007

pmarfleet4-Nov-07 7:59

4-Nov-07 7:59

That looks OK. Are you still having problems?

Paul Marfleet

"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush

kendo174-Nov-07 8:16

4-Nov-07 8:16

yes sorted it was had not changed the class details thank you

i need to complete this tonight or i am going to struggle at Uni.

pmarfleet4-Nov-07 8:19

Integrated two project in one

4-Nov-07 8:19

OK. Good luck.

Paul Marfleet

"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush

Assaf824-Nov-07 4:00

Assaf82

4-Nov-07 4:00

Hello
I do separate project i want to integrated in one how to do

Any idea is helpful

Thanks in advance

Assaf

Paul Conrad4-Nov-07 4:42

Paul Conrad

4-Nov-07 4:42

Assaf82 wrote:
I do separate project i want to integrated in one how to do

Huh? Rephrase your question. At the beginning you sound like you want to separate two projects, and then you want to integrate them?

"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon

Anthony Mushrow4-Nov-07 4:58

Anthony Mushrow

4-Nov-07 4:58

I think they have two separate projects, and want to merge them togeather.

So, "I do separate project" becomes "I've done separate projects"

My current favourite word is: Waffle

Cheese is still good though.

Paul Conrad4-Nov-07 5:26

Paul Conrad

4-Nov-07 5:26

That could very well be the case, but who knows for sure.

"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon

Assaf824-Nov-07 6:13

Assaf82

4-Nov-07 6:13

Sorry for my mistakes
yes i've done two separate project and i want to merge them

Thanks in advance

Assaf

Connecting to remote MySQL database: cannot open connection

Paul Conrad4-Nov-07 6:21

Paul Conrad

4-Nov-07 6:21

Assaf82 wrote:
i want to merge them

I'd probably just create a third project and add the sources of the two others into the third. You then have the third one, being fresh, and the other two as original backups.

"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon

mwholt4-Nov-07 2:48

Re: Connecting to remote MySQL database: cannot open connection

4-Nov-07 2:48

Hey - I'm trying to open a connection to a database hosted on my Unix server remotely:

private static void OpenSqlConnection()<br />
        {<br />
            MySqlConnection oMySqlConn = new MySqlConnection();<br />
<br />
            oMySqlConn.ConnectionString = "server=mydomain.com;database=uname_main;user id=uname_main;pwd=myPwd;pooling=false;port=3306;";<br />
<br />
<br />
<br />
            try<br />
            {<br />
<br />
                oMySqlConn.Open();<br />
<br />
                if (oMySqlConn.State == ConnectionState.Open) MessageBox.Show("Connection to MySQL opened through OLE DB Provider");<br />
<br />
                oMySqlConn.Close();<br />
<br />
            }<br />
            <br />
            catch (MySqlException ex)<br />
            {<br />
<br />
                MessageBox.Show(ex.Number + " - " + ex.Message, "DB-Connection");<br />
<br />
            } <br />
            <br />
<br />
        }

Everything works fine (as in, I'm using all required libraries, such as MySQL.Data/MySQL.Data.MySQLClient) and I get no errors until I run this method. After about 8 seconds, it constantly says:

1042 - Unable to connect to any of the specified MySQL hosts.

I'm positive that my domain name is correct and that all login credentials are correct. In CPanel on my server I've added %, %.%.%.%, and my IP address as access hosts and I still can't seem to open the connection.

I've been working on this for hours but to no avail, and online help has proved not useful so far.

Any suggestions? I'd gladly appreciate some!

-Matt

mwholt4-Nov-07 2:54

Re: Connecting to remote MySQL database: cannot open connection

4-Nov-07 2:54

Perhaps I should mention that actually I'm not 100% sure which port I should be using, but everyone else seems to be using 3306. Is that correct as well? What steps must I take to make this connection possible?

I need my application to work with this database on my remote server directly so that I can keep multiple users synced up with stored data, etc.

Thanks again for any help; I need it!

Guffa4-Nov-07 3:41

Guffa

4-Nov-07 3:41

From what I found on forums.mysql.com the default port is correct. You don't even have to specify it in the connection string.

According to connectionstrings.com you should use the key password instead of pwd.

Do you have a firewall/router between the server and the internet? Is there a port forward specified for the port?

Experience is the sum of all the mistakes you have done.

Re: Connecting to remote MySQL database: cannot open connection

mwholt4-Nov-07 8:28

Re: Connecting to remote MySQL database: cannot open connection

4-Nov-07 8:28

Hey thanks for the reply. I changed pwd to password but it still does not work. I never ordered a firewall with my hosting, but submitted a ticket to my host to see if there was any configuration things that need to be worked out anyway.

Also, what is port forwarding? Do I need to specify one?

mwholt4-Nov-07 8:43