Browse DevX
Sign up for e-mail newsletters from DevX

Search the Tips


1-20 of 65     Previous     Next
Connect to the DB for Multiple .cgi Web Services with PERL
by Cem Aykan
Eliminate the hassle of typing all your DBI information into your Perl .cgi scripts. This function retrieves the information from a .dat file on the server, and parses it for the DBI.
Use CopyFromRecordset With ODBC Recordsets
by Leonid Strakovskiy
ODBC Installation
by DevX Pro
I'm trying to install the of Informix for WinNT and during the process I get error number 126?
Informix Registration Within SQL Server 7
by DevX Pro
How can I view Informix database tables via the SQL Server 7 Enterprise Manager?
Read and write File ODBC data sources
by Francesco Balena
A file DSN is nothing but a text file that contains all the parameters for an ODBC connection. To prove this, just go to the default directory that holds all File DSNs (this is the \Program Files\Common Files\ODBC\Data Sources directory on Windows's boot drive) and load any .dsn file into a ...
Error in Visual Studio Data View with CLI 2.40
by DevX Pro
I have installed the Informix-CLI SDK 2.40 (driver ODBC rev. 3.31) both in Windows 98se and NT 4 sp4, and I've encountered a problem with Visual Studio Data View when try to see tables from an Informix DB running on an AIX 4.3 host. I have problems with numeric data; the view is incorrect (0 when it must be 1). An older version of CLI SDK works correctly.
ODBC drivers for Informix IDS 9.2
by DevX Pro
We are trying to get our application to work with Informix using ODBC, and we are having repeated failures. We cannot seem to access "memo" (large text) fields of any type using the supplied ODBC driver, version 3.31. We are on an NT system, and we have tried both MFC and raw ODBC with CLOBs, CHARs, LVARCHARs, and TEXT field types, but still it fails. Incidentally, we have no problems with SQL Server or Oracle. 1. Are there any other ODBC drivers we could try, and if so, does anybody know where we might find them? 2. Has anyone else had similar problems with memo fields and ODBC and found any solutions?
Using Ports with Informix
by DevX Pro
From a Windows system I am trying to connect to an Informix database running on a Sun Solarix box, which was just moved behind a firewall. The Windows machine is running Access and using ODBC. It appears that the client chooses a random port to connect to the server based on the firewall blocks. Can the database be configured to use set ports rather than what appears to be random?
Win 95/NT Login To Informix
by DevX Pro
I cannot get 6 of 60 units to log in to an Informix application server. The units are all identical and they can ping the server. I get the message "Access Denied 999." Can you help with this?
Connecting Remote Client to Informix Server
by DevX Pro
I have an Informix 7.32 server on a Sun box and I need to connect to it from another Sun box. How do I ensure it's connected?
Informix and ASP Error
by DevX Pro
When I try to connect to an Informix database (via ASP) located on another machine on our LAN, I get the following error: Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed How do I avoid this?
by DevX Pro
Why when I try to run sqlexecd to set up ODBC do I get an error: -25553 unable to load locale categories.
Database Connectivity From Informix on Unix
by DevX Pro
Is there an ODBC driver that can connect our existing Informix database on Unix to SQL Server 7.0 on NT 4.0?
Visual Basic Data Access, ADO, OLE/DB
by DevX Pro
What are the differences between Provider=MSDASQL.1 and Provider=SQLOLEDB.1 in an "Open" "Select" statement? Also, what is the difference (if any) between "ADO" AND "OLE/DB"? And finally, in Visual Basic, what is the difference between the dim statements Dim trs as ADODB.Recordset, cnn as ADODB.Connection and Dim trs as Recordset, cnn AS Connection?
GetODBCDriverInfo - Get information about a specific ODBC driver
by Francesco Balena
Return information about an ODBC driver The 1st argument must be an ODBC driver name, as returned by the GetODBCDrivers function Not all drivers return the Timeout value Requires the GetRegistryValue function
GetODBCDrivers - Read the list of ODBC drivers from the registry
by Francesco Balena
get the list of ODBC drivers through the registry returns a collection of strings, each one holding the name of a driver, e.g. "Microsoft Access Driver (*.mdb)" requires the EnumRegistryValues function
Informix Stored Procedures to VB
by DevX Pro
I am returning a resultset from an Informix Stored Procedure to VB6 via ODBC and ADO. Is there any way of returning the field names? At this point I get the resultset, but the name property of the fields are blank.
Porting from Oracle to Informix
by DevX Pro
We have an existing application, which has been developed using ASP. The database being used is Oracle 8. Now, for a different customer, we want to port this application to Informix. Can we port this application from Oracle to Informix?
Visual InterDev Hangs
by DevX Pro
When connecting to an Informix database using Visual InterDev and SCO Retriever 32 ODBC, I can see tables and column names but when I try to look at data, Visual InterDev hangs. (I'm using Windows NT 4 Service Pack 4, IIS 4). Any approaches to this?
Web Databases and Connectivity
by DevX Pro
Define a Web database, please. What are the advantages and disadvantages? How do I connect different software to the Web?
1-20 of 65     Previous     Next
Thanks for your registration, follow us on our social networks to keep up-to-date