OleDB connection.Open() fails in WebService only - ASP.NET Discussion Boards

Hi friends

First of all I would like to thank people here on codeproject for helping me whenever I need help. I am hopefull that now also all of you will help me. Today I got a special scenario which I am applying in my application.
I have 2 text boxes to enter zipcode, In first text box when ever user enters some data and presses tab and on getting focus on the second textbox, the second textbox must show data based on the values entered in the first textbox like what we see in google suggest.
For example when user enters 5 digit zipcode in 1st textbox & presses tab key the focus will be on 2nd textbox and immediately 2nd textbox must show names of peoples based on the zipcode entered in 1st textbox, like how we see in google suggest.
For further clarification please mail me back. Hope some one will help me. Thanks in advance

Thanks
wajid

Hi,

I have to create a parser that can parse a HL7 Message and load the data result into aSQL Server.

Does any one have any idea about this ?

Hi,

I had written a webservice.Now I need help to accompolish the following goals..

1.How to host the webservice?..since this i have to use in windows application.

2.How to consume this webservcie through the C#.net windows application.

My task is to write the Webservice,using this I will pick some data and that data I have to pass to a windows application/windows service where I will update the database.

please dont crosspost. the original is in the c# forum.

here[^]

Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.

..and the windows forms

Here[^]

The guy is after some idiot to do his homework I think.

Bob
Ashfield Consultants Ltd

wish i coulda gotten that in college..i may have become a computer engineer, though without actually doing any of the work i dont think i would have been one for long. i guess people just think we sit in small fabric covered box all day and get a paycheck and dont actually have to do or know anything. i know thats the opinion around here most of the time (until we put a build out then we do things but what we do is never right)

Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.

I agree with your opinion.

I Love T-SQL
"Don't torture yourself,let the life to do it for you."

I have a simple ASP webservice that performs a SELECT query against a database, and then an INSERT statement on the same database/table. The problem arises at the time when we create the second OleDB connection object and attempt to Open() it. The connection string is exactly the same for both connection objects. Another intersting thing is that this code works fine when it is used in a Windows Form project. I'm using VS2003.

Here's the code used for both attempts:

try
{
cnOleDBSDE = new OleDbConnection();
 
cnOleDBSDE.ConnectionString = "Data Provider=" +DBProvider+ ";"+
   "Provider=" + DBShapeProvider + ";" +
   "Data Source=" + DBName + ";" +
   "Pooling=" + Pooling.ToString() + ";" +
   "User Id=" + UserId + ";" +
   "Password=" + Password;
cnOleDBSDE.Open();
}

Here's the connection object data from the immediate window when .Open() is called succesfully:

cnOleDBSDE
{System.Data.OleDb.OleDbConnection}
base {System.Data.Common.DbConnection}: {System.Data.OleDb.OleDbConnection}
ConnectionString: "Data Provider=MSDAORA.1;Provider=MSDataShape;Data Source=sdeprod;Pooling=False;User Id=ACOUSINS;Password=djhf6li"
ConnectionTimeout: 15
Database: ""
DataSource: "sdeprod"
Provider: "MSDataShape"
ServerVersion: 'cnOleDBSDE.ServerVersion' threw an exception of type 'System.InvalidOperationException'
State: Closed

And the connection object data from the immediate window when .Open() throws an OleDB exception:

cnOleDBSDE 
{System.Data.OleDb.OleDbConnection}
base {System.Data.Common.DbConnection}: {System.Data.OleDb.OleDbConnection}
ConnectionString: "Data Provider=MSDAORA.1;Provider=MSDataShape;Data Source=sdeprod;Pooling=False;User Id=ACOUSINS;Password=djhf6li"
ConnectionTimeout: 15
Database: ""
DataSource: "sdeprod"
Provider: "MSDataShape"
ServerVersion: 'cnOleDBSDE.ServerVersion' threw an exception of type 'System.InvalidOperationException'
State: Closed

I don't see any differences. Finally here's the error:

{"Data provider could not be initialized."}
    [System.Data.OleDb.OleDbException]: {"Data provider could not be initialized."}
    Data: {System.Collections.ListDictionaryInternal}
    HelpLink: null
    InnerException: null
    Message: "Data provider could not be initialized."
    Source: "MSDataShape"
    StackTrace: "   at System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection)\r\n   at System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)\r\n   at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)\r\n   at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)\r\n   at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)\r\n   at System.Data.OleDb.OleDbConnection.Open()\r\n   at GDAC.GDAC.OpenOleDbConnection(String DBName, String DBProvider, String DBShapeProvider, Boolean Pooling, String UserId, String Password) in D:\\ETS\\GDAC\\GDAC.cs:line 471"
    TargetSite: {Void .ctor(System.Data.OleDb.OleDbConnectionString, System.Data.OleDb.OleDbConnection)}

_HResult -2147168229 int

I tried Googling and found people with similar issues from years ago, but no resolutions. Any ideas?

I'm guessing that you have the Oracle client installed correctly on your desktop (which would explain why your code is working in a Windows Forms application) but not installed correctly on your web server. Check and make sure you can connect to your database directly from the web server (for example, use SQLPlus or something like that directly from the web server console). If you can't, then you'll have to review your Oracle client installation there.

The thing is, I can connect just fine the first pass. I'm using the Visual Studio development server that starts automatically on my machine when I go into debug so I assume it uses the same credentials as my local user logon info.

I'm not sure if this is possible, but what i want to create is web application that sends notifications to the user via whatever communication medium upon a certain condition.

For example, lets say we have an online form. You don't complete the form, but you can save your current input and come back to finish it later. Now lets say you forget to complete the form. The application will send you an alert or notification after a week or so to remind you to complete the form.

Assuming that I'm using asp.net 3.5 and sql server 2005, how can i have the application on the server send alerts to the user after a time period has passed ?

store th edata in a db and have a seperate process that watches the db and send the notifications, or check the storage medium for old incomplete information every time its run and notifies the people..however this could be slow for the new person trying to use it and having to wait while the server notifies all of the people with incomplete signups.

if i gave up on completeing a form it was probably for a good reason and i wont care about finishing it.

Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.

I'm thinking something like a Windows service application that polls your sql server 2005 database for records requiring notifications, and uses System.Net.Mail objects to send emails would work for you.

the service polling sounds like a good move. it did cross my mind before

I was just wondering if there was a way to do it using just sql server and asp.net
Maybe i can look into notification services

I have a vb.net application that is installed on a machine acting as a webserver. I need to open this application from an asp.net website. I have been told that I should use an ActiveX control. I have read some articles but i'm still not sure how to use active x controls. I am new to programming so I don't understand most of the terms used. Can someone please explain it to me. Thank you in advance Confused | :confused:

ActiveX controls are an old school way running code a client.

What does this application do and where do you want it to run?

I didn't get any requirements for the signature

I want a user to click on a button and the application should run. The application is a tool that the user will use while adding input to the webpage.

Well, usually it is difficult to call a windows application from a browser. The reason for this is because of security. Generally you don't want web applications to run code on the client machine.

Is this application for the internet or on a local network?

If you are running the application in an intranet environment you can deploy the windows application using Click Once Deployment[^] and then simply put a link to the web page of the application on your web page.

Passing arguments to the application is another issue all together...

I didn't get any requirements for the signature

Its running on a local network. Thanks for your response. I will take a look at the article. Smile | :)

I have a website called abc. I created a virtual directory pointing to this folder. This folder also contains a admin folder. I want users to access as follows: abc.com should take them to default.aspx in the main folder. abc.com\admin should take them to the default.aspx folder in admin folder. How can i achieve this?

create a virtual directory admin pointing to your admin folder in the main directory.
Set the default(say default.aspx) page for newly created folder.

first, create virtual directory for abc by right-clicking on the default website in your iis. here in documents tab move default.aspx to top.

Then right-click on the virtual directory abc which you have just created and select new--> virtual directory-->alias name admin-->give tha path and so on.

right click admin VD to select properties in the documents tab move default.aspx to top

this may help u

Regards
sunilwise

Thanks!

I am getting the following error:

there is a master page in admin folder called admin.master. another page called x.aspx is inheriting from the master page which causes this to appear:

modified on Friday, July 25, 2008 11:53 AM]]>

Civic06 wrote:
now there is a problem because the path is this: abc/admin/admin/Admin.master which obviously doesn't exist. i can modify the MasterPageFile but it causes a problem when i want to compile and debug on my local machine.

i think u have created second virtual directory under admin folder.The second VD you should create under VD abc

Regards
sunilwise

Hi All

I want to keep Gridview Header and First column in fixed Position and other rows keep vertical scrolling ... can you help me??

Rose | [Rose]