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 > unable connect from window 2003 to informix database.

Reply
 
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 03-13-09, 00:37
web4db web4db is offline
Registered User
 
Join Date: Mar 2009
Posts: 2
unable connect from window 2003 to informix database.

Hi, it is good to found another database forum. I recently update to informix 11.5 and informix client sdk 3.5 but i encounter odbc connectivity problem.

when i open the webpage it's show this error message.
--------------------------------------------------------------------------
Microsoft OLE DB Provider for ODBC Drivers error '80004005'

Specified driver could not be loaded due to system error 127 (IBM INFORMIX ODBC DRIVER).

/mis/test.asp, line 21

I recently installed odbc driver (informix client sdk 3.5) into window 2003 and window xp sp2 pro. I'm able connect it from window xp to informix server but the same asp script is not function in window 2003.
I also set check the path env variables. I didn't found any wrong below.

C:\Windows\System32;C:\Windows\system32\wbem;C:\Pr ogram Files\ibm\gsk7\bin;C:\Program Files\ibm\gsk7\lib;C:\Program Files\IBM\Informix\Client-SDK\bin;C:\Program Files\Informix\Client-SDK\bin;C:\Program Files\Microsoft SQL Server\80\Tools\BINN;

any recommendation?
Reply With Quote
  #2 (permalink)  
Old 03-13-09, 04:01
web4db web4db is offline
Registered User
 
Join Date: Mar 2009
Posts: 2
hi, i has solved it. It jz required reboot the server. I'm try in Window XP pro without restart but Window Server 2003 is required reboot.

By the way, who's know the connectionstrings to connect to Informix database with Informix CSDK 3.5?

i try with this but it is not working. What's wrong in my script?

set cst="Dsn=dataSource.dsn;Driver={IBM INFORMIX ODBC DRIVER};" & _
  "Host=IBASE;Server=190.1.1.35;Service= star4;" & _
  "Protocol=olsoctcp;Database=hrd;Uid=;w eb4db=123456;"

DBConnection.Open  cst 
Reply With Quote
Reply

Thread Tools
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