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 > ASP connection to Informix

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 10-03-02, 16:08
Corey Corey is offline
Registered User
 
Join Date: Oct 2002
Posts: 6
ASP connection to Informix

I'm having problems connecting to informix using ASP. Can anyone help?
Reply With Quote
  #2 (permalink)  
Old 10-03-02, 17:46
rnealejr rnealejr is offline
Registered User
 
Join Date: Feb 2002
Posts: 2,232
What are the problems ? Which driver are you using for your connection string ? Can you post your connection string ? Which version of client sdk are you using ? Make sure you have version 2.8.
Reply With Quote
  #3 (permalink)  
Old 10-03-02, 17:54
Corey Corey is offline
Registered User
 
Join Date: Oct 2002
Posts: 6
I'm using version 2.5. Where do I get version 2.8?

Here is the error:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[INTERSOLV][ODBC Informix driver][Informix]Unable to load locale categories.
/leo/testing.asp, line 28



I have created ODBC connection DSN and am able to connect to it from Access, but not ASP.

Set dbcon = Server.CreateObject("ADODB.Connection") 'setting up connection to database
dbcon.Open "DSN=SEA-LEO-P;PWD=leo123"
Set dbrec = Server.CreateObject("ADODB.Recordset") 'setting up connection to recordset of database
dbsql ="select emp_nr,fname, lname from informix.employee;"
dbrec.Open dbsql, dbcon 'run sql statement
Reply With Quote
  #4 (permalink)  
Old 10-03-02, 18:04
rnealejr rnealejr is offline
Registered User
 
Join Date: Feb 2002
Posts: 2,232
The 2.5 you are referring to is the mdac - Informix has a client sdk with their oledb drivers (I believe the latest version is 2.8). Is the code listed from your asp page or from access ? Also, have you tried connecting through vb ? Where is it failing in the code ?
Reply With Quote
  #5 (permalink)  
Old 10-03-02, 18:15
rnealejr rnealejr is offline
Registered User
 
Join Date: Feb 2002
Posts: 2,232
This seems to be an intersolv/registry problem (once you install the informix client sdk you will be ok). But I have found some documentation that may be helpful - you will have to use setnet32 and regcopy:

link

Last edited by rnealejr; 10-03-02 at 18:18.
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