|
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
|
|
|
|
|
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. 
|
|
|
|
|
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]](https://www.codeproject.com/script/Forums/Images/rose.gif)
|
|
|
|
|
hi,
I have one text box, usually user enters some part numbers to add the product to mini cart.
Now i need to develop intellisense using dotnet i.e when user started to enter any part number, that time it need to display all the partnumbers which is started by that letter.
Supper user enter p then it needs to display all the products whose partnumber is started by p.
like google suggest.
Can help anybody on this.
Thanks and Regards
Dayakar D.N
|
|
|
|
|
If you are working on .Net framework 2.0 or later then use AJAX AutoComplete Extender control.
Search in google or you can get it from here. Demo
please don't forget to vote on the post that helped you.
|
|
|
|
|
Hi guys my file name is like this:
man.xls...,
I am getting that file name using fileinfo object...,
f.name like
Suppose if i want to get only the name of the file,
mean only "man" what i have to do?,
Its possible to get like that?
Thanks & Regards,
NeW OnE,
please don't forget to vote on the post
|
|
|
|
|
New one wrote: Suppose if i want to get only the name of the file,
mean only "man" what i have to do?,
Path.GetFileNameWithoutExtension(f.name);
regard
Khan
please don't forget to vote on the post that helped you.
|
|
|
|
|
I have the below code to count the rows selected from the datagrid and stores the selected value.
How can i get the seleted row's and perticular column.
If datagrid displays code and name of employees,how can i store code of employee for the selected rows.
PLease seee my code,i can count the rows but values are not saving.
On a button click event--->
Dim rowCount As Integer = 0
Dim DemoGridItem As DataGridItem
For Each DemoGridItem In DG1.Items
Dim myCheckbox As CheckBox = CType(DemoGridItem.Cells(0).Controls(1), CheckBox)
If myCheckbox.Checked Then
rowCount += 1
End If
Next
Lblstatus.Text = rowCount.ToString())
Plese tell me how to get code values in different selected rows?
kissy
|
|
|
|
|
Here is the problem, okay besides my customer's broken architecture:
Backend DB uses an entity data class. WebSvcA passes entity. WebSvcB also passes entity.
So what we have is: Entity.Class1, WebSvcA.Class1, and WebSvcB.Class1.
Their solution? A Util.dll with convert functions that go every which way. 
I feel ill.
Are there any recommendations? Such as Entity.Class1 impleneting some serialization interface such that the proxy classes are unnecessary? I'm looking in to an automated (non-reflective) way to serialize between the 3 classes as they are all the same. Still, I can't help thinking there is a more clever way (other than changing the architecture which is NOT an option so don't ask).
|
|
|
|
|
Can anyone Pleeeaaassseee tell me how to open a vb.net application from an asp.net 2.0 website. Can I please have the actual steps from start to finish.Thank u in advance 
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
