If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > Informix > Dirver options not showing in Visual Studio 2008

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 05-13-11, 16:10
brekehan brekehan is offline
Registered User
 
Join Date: May 2011
Posts: 2
Dirver options not showing in Visual Studio 2008

I want to be able to create a database project in Visual Studio 2008 and have it contain a reference to our Informix 11.5 database.

I've been trying for 8 hours or so to install all manner of client SDKs, play with registry settings, uninstall/reinstall .NET Frameworks and .NET Framework SDKs, along with Windows SDKs.

I cannot for the life of me get anything to show up in the
tools->connect to database...->Data Source Change...button aside from the microsoft drivers.

My only option is to use the ODBC Data Source option with .NET Framework Data Provider for ODBC. If I do this, I cannot run half my scripts because the ODBC driver, evidently times out if something is not returned in 30 seconds.

I've read pages on the net where others are describing a driver option for Informix/DB2, etc.

I made sure everything was checked when I installed the client SDK.
What am I missing?

Keep in mind, I do not want to write .NET code. I want to create a database project and run SQL scripts while viewing the tables and contents.
Reply With Quote
  #2 (permalink)  
Old 05-14-11, 08:51
marymurny marymurny is offline
Registered User
 
Join Date: Sep 2004
Posts: 32
Dirver options not showing in Visual Studio 2008

The CommandTimeout needs to be increased in the VS application.
The following link will show an example:
Increasing query time-outs with TableAdapters - Smart Client Data - Site Home - MSDN Blogs

Informix ClientSDK uses the application timeout and for Visual Studio it is 30 seconds.

I hope this helps.
Reply With Quote
  #3 (permalink)  
Old 05-14-11, 09:50
brekehan brekehan is offline
Registered User
 
Join Date: May 2011
Posts: 2
There is no application.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On