Solved

Informix Connection from VB.NET

Posted on 2004-04-28
11
468 Views
Last Modified: 2009-12-16
I am using informix7.0 database as my backend.From vb.net i am connecting it through
oledbconnection.But i found its slower that the cionnection of SQL server and
Oracle database.How can i increase the speed of my connection.Please can anyone help me on this.

 
0
Comment
Question by:kshabu
  • 6
  • 3
11 Comments
 
LVL 96

Expert Comment

by:Bob Learned
ID: 11123182
Are you still having a problem with this?

Bob
0
 

Author Comment

by:kshabu
ID: 11123837
YEs i have still the probelm in the efficiency(speed) in informix connection.
0
 
LVL 96

Expert Comment

by:Bob Learned
ID: 11125740
What is the difference between the Informix, SQL Server, and Oracle?

What does your connection string look like?

What provider are you using?

Bob
0
 

Author Comment

by:kshabu
ID: 11125784
Hi Bob,

Thanks for your interest.
I am using oledb connection.My connection string is
"Provider=Ifxoledbc.2;Password=xxxx;Persist Security Info=True;User ID=informix;Data Source=Sample@ol_ntdomain;Extended Properties="""

Regards
Shabu.k


0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
LVL 96

Expert Comment

by:Bob Learned
ID: 11125876
How about the other questions?

Bob
0
 
LVL 96

Expert Comment

by:Bob Learned
ID: 11125902
Also, what is the version of the OleDb provider?

Bob
0
 

Author Comment

by:kshabu
ID: 11125927
Informix 3.80 32 bit is the provider what i am using
0
 
LVL 96

Accepted Solution

by:
Bob Learned earned 125 total points
ID: 11125985
Here is an interesting blog:

IBM Provides Informix ADO.NET Provider
http://weblogs.asp.net/adweigert/archive/2004/03/22/93909.aspx

Bob
0
 
LVL 96

Expert Comment

by:Bob Learned
ID: 11177021
Did this help?

Bob
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
update textboxes with Streamreader 21 42
vb.net 2 37
Change Format on Data when exporting to Excel 4 23
Vb. Net application freezes 9 30
Creating an analog clock UserControl seems fairly straight forward.  It is, after all, essentially just a circle with several lines in it!  Two common approaches for rendering an analog clock typically involve either manually calculating points with…
Parsing a CSV file is a task that we are confronted with regularly, and although there are a vast number of means to do this, as a newbie, the field can be confusing and the tools can seem complex. A simple solution to parsing a customized CSV fi…
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…
Both in life and business – not all partnerships are created equal. As the demand for cloud services increases, so do the number of self-proclaimed cloud partners. Asking the right questions up front in the partnership, will enable both parties …

912 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now