Re: NT ASP/ADO ODBC to SCO UNIX Informix problem

Posted in 1997

Topics: Installation, Setup & Upgrades, Connectivity: ODBC / JDBC / .NET, Networking & sqlhosts Configuration

Kevin Greiner — Fri, 12 Sep 1997 09:32:10 -0400 — source: Informix-list mailing list archive (1991-1998)

Have you tried to read the ODBC data using another client? Like MS Word, Excel, or Access? What "simple SQL tool" are you using to test SCO's ODBC driver? -Kevin mmanning@digev.com wrote: > > VERY BASIC SCENARIO > We're trying to connect to a Unix database from NT, and tie it into an > ASP-based web site. > > SOME DETAIL We're trying to connect to an Informix database on SCO (Santa > Cruz Operation) Unix from IIS (Internet Information Server) on an NT 4.0 > Server via ASP (Active Server Pages) and the ADO (Active Data Object). > We're using SCO's ODBC driver, and have been able to see the database > from the NT machine, using a tool that comes with the driver; this is > good. We get OLE DB error message when we try to connect via ASP/ADO; > this is bad. The machines are off-site; this is also bad. > > SPECIFICS > NT 4.0 (not sure what service pack; assume 3) > IIS 3 > ASP (downloaded from Microsoft and installed on 9/9/97) > ADO > SCO SQL Retriever 4.1 > > SCO Unix Openserver 5.0.4 > Informix DSA (Dynamic Server Architecture) 7.2 > > These machines are correctly configured to talk to each other via TCP/IP. > The SCO SQL Retriever ODBC driver appears to be working, based on positive > signs from a built-in tool (can see the tables in the Informix db from a > simple SQL tool). When we try to connect from an ASP page, we get this: > > Microsoft OLE DB Provider for ODBC Drivers error '80004005' > Specified driver could not be loaded due to system error 1114 > (SCO Vision ODBC). > members/default.asp, line 9 > > HELP! I've scoured the web, usenet, and knowledge bases to no avail; any > help or related experience insights would be much appreciated. > > I'm guessing that we'll just end up needing try a different provider's > ODBC driver.... Suggestions welcome. > > best, > mike > > mike manning >> technical director >> d i g i t a l e v o l u t i > o n mmanning@digev.com >> 310.440.3377 11911 san vicente blvd #225 >> > brentwood, ca 90049 > > -------------------==== Posted via Deja News ====----------------------- > http://www.dejanews.com/ Search, Read, Post to Usenet