• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 526
  • Last Modified:

Informix Connection from VB.NET

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
kshabu
Asked:
kshabu
  • 6
  • 3
1 Solution
 
Bob LearnedCommented:
Are you still having a problem with this?

Bob
0
 
kshabuAuthor Commented:
YEs i have still the probelm in the efficiency(speed) in informix connection.
0
 
Bob LearnedCommented:
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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
kshabuAuthor Commented:
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
 
Bob LearnedCommented:
How about the other questions?

Bob
0
 
Bob LearnedCommented:
Also, what is the version of the OleDb provider?

Bob
0
 
kshabuAuthor Commented:
Informix 3.80 32 bit is the provider what i am using
0
 
Bob LearnedCommented:
Here is an interesting blog:

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

Bob
0
 
Bob LearnedCommented:
Did this help?

Bob
0

Featured Post

Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

  • 6
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now