Solved

Informix Connection from VB.NET

Posted on 2004-04-28
11
464 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
Comment Utility
Are you still having a problem with this?

Bob
0
 

Author Comment

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

Expert Comment

by:Bob Learned
Comment Utility
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
Comment Utility
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
What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

 
LVL 96

Expert Comment

by:Bob Learned
Comment Utility
How about the other questions?

Bob
0
 
LVL 96

Expert Comment

by:Bob Learned
Comment Utility
Also, what is the version of the OleDb provider?

Bob
0
 

Author Comment

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

Accepted Solution

by:
Bob Learned earned 125 total points
Comment Utility
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
Comment Utility
Did this help?

Bob
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

I think the Typed DataTable and Typed DataSet are very good options when working with data, but I don't like auto-generated code. First, I create an Abstract Class for my DataTables Common Code.  This class Inherits from DataTable. Also, it can …
It’s quite interesting for me as I worked with Excel using vb.net for some time. Here are some topics which I know want to share with others whom this might help. First of all if you are working with Excel then you need to Download the Following …
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

744 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

16 Experts available now in Live!

Get 1:1 Help Now