Re: Web service in asp.net using c# - C# Discussion Boards

akosidandan14-Apr-11 21:34

14-Apr-11 21:34

Hello,

Thanks for the reply,I tried changing my connection strings now provided in my web hosting site. The connection strings given by my host is in this link
http://www.aspspider.com/tips/Tip18.aspx[^]

I'm not that so much sure but doesn't the ms access database supposed to work since I followed it. I tried commenting the one using sql server connection string just to test the ms access 2003 and I even tried to re add my web reference to be sure but still I got an error.
To give clarification my error is in below

System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections.

I'm also confuse since why does my error state that I have error in sql but I'm using oledb since my database is ms access 2003 and I already comment the block of code using sql.

Any help are kindly appreciated.

Thanks,
DAN

BobJanova15-Apr-11 2:27

BobJanova

15-Apr-11 2:27

Indeed. Both connection strings are absolute paths to things that are on the local machine, and almost certainly won't be in the same place when hosted. Make sure the connection strings in the uploaded version point to where the database actually is (your host should be able to tell you this).

And indeed, connection strings should be in a configuration file, so your code base can be the same for testing and deployment.

akosidandan15-Apr-11 17:29

15-Apr-11 17:29

Hello,

I fix now the problem it seems that one causing the error is the bin file of my webservice. I notice that although I edit the code of my asmx file and even if its a working code but if I did not re upload the the bin file of my webservice.The website still load the past code of my asmx rather than the new one.

Thanks everyone,
DAN

Dave Kreskowiak15-Apr-11 1:57

Dave Kreskowiak

15-Apr-11 1:57

This code shouldn't even compile. You've got the exact same method (getData) defined twice, with no difference between the two method headers. There has to be some way to deifferentiate the two either by name or by the parameter list.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak

akosidandan15-Apr-11 2:05

15-Apr-11 2:05

Hello,

Sorry for the confusing part. I was trying to test only if how it work by commenting other or vice versa in that time thats why I have the two methods. Thanks for the reply.

Any help are kindly appreciated.

Thanks,
DAN

akosidandan15-Apr-11 17:30

15-Apr-11 17:30

Hello,

I fix now the problem it seems that one causing the error is the bin file of my webservice. I notice that although I edit the code of my asmx file and even if its a working but if I did not re upload the the bin file of my webservice.The website still load the past code of my asmx rather than the new one.

Thanks everyone,
DAN

Prasanta_Prince15-Apr-11 8:13

Prasanta_Prince

15-Apr-11 8:13

Have a look on the connection string of the MDB file. or use Server.Mappath to get actual path of the mdb file.

akosidandan15-Apr-11 17:27

15-Apr-11 17:27

database path

arkiboys14-Apr-11 7:27

14-Apr-11 7:27

Hi,
On my local machine, I have developed a c# application which reads from a sql server express database.
Now I want to install these (The application and the sql server express) on the client machine.
On the client machine, with the login I have, I can only have access to the U drive.
Questions:
1- Can I install the appplication on the U drive or does it have to be the C drive?
2- I also have to install the sql server express on the client machine. Can It be installed in the U drive?
3- The application has a config file which is used to access the sql server i.e. ./sqlexpress, etc...
What should the config file path be if both the application and the sql server express are installed in the U drive?

Thank you

Not Active14-Apr-11 10:03

Not Active

14-Apr-11 10:03

You can install the application where ever you would like, however, there may be components, especially with SQL Express that will require administrator rights.

The connection string for SQL Express would be .\SQLExpress, where the dot is shorthand for local.

I know the language. I've read a book. - _Madmatt

arkiboys14-Apr-11 10:50

14-Apr-11 10:50

Yes, the installation of sql server requires the admin rights but does it have to be installed locally into c drive or can I point it to u drive?
Thanks

Not Active14-Apr-11 11:40

Not Active

14-Apr-11 11:40

Once again, you can install the application anywhere. That includes SQL Express, it will default to the c: but you can change that.

I know the language. I've read a book. - _Madmatt

arkiboys14-Apr-11 20:26

14-Apr-11 20:26

Once I install the sql server express on the U drive, then will I be able to access the management studio window from any machine which does not have sql server express installed in it's c drive?
Thanks

Pravin Patil, Mumbai15-Apr-11 0:45

Pravin Patil, Mumbai

15-Apr-11 0:45

Yes, you can...

Dave Kreskowiak15-Apr-11 1:54

Dave Kreskowiak

15-Apr-11 1:54

No.

Every PC that is going to manage that database with the management studio has to have the studio installed. You cannot just install the studio once and run it from anywhere. There are more than a few components that have to be registered on each PC that's going to run the management studio.

Once the studio is installed, you can manage the database on the U: drive.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak

Prasanta_Prince15-Apr-11 8:15

Prasanta_Prince

15-Apr-11 8:15

If you have the administrator right you can instal at any drive.

arkiboys15-Apr-11 10:21