odbc .net drivers

odbc .net drivers

Post by James Hamad » Fri, 10 Jan 2003 05:55:43

How do I connect to and informix database using the
odbc.net drivers? I want to execute a stored proc in
informix and or is there a better way to connect? I am
trying to write this in vb.net or asp.net.

1. Forcing the ODBC driver to use the Multiprotocol Net Library


I am using the newest version of the SQL Server ODBC driver (version as far as I know) to connect VB to my SQL Server 6.5 database. It
is a requirement of our connection to have encryption enabled and so I am
using the Multiprotocol net libary with encryption enabled. This is working
very well.

I would like to know is if it is possible to force the datasource to use the
Multiprotocol net libary, in case somebody has changed the datasource
definition through the ODBC manager (either accidentally or otherwise).
Please bear in mind I am using ODBC32.DLL, not DAO (in which case, I think
it would have been easy using the Connect string...). As far as I know, I
can use the SQLConfigDataSource for this - is this correct?



Benjamin Abbott
IT Systems Developer
Enron Direct Ltd

Web: http://www.enrondirect.co.uk

2. Showplan....can u help me to understand what is better?

3. Latest Versions: Net-Library, DB-Library, ODBC Driver

4. all the permission items.

5. 32-bit ODBC driver for Oracle via SQL*Net on Windows 95

6. Import an XML (save from Recordset adPersistXML) into SQLserver 2000

7. Q: Do I really need Informix-Net AND Intersolv ODBC-Driver

8. How to retrieve characters from a LONG datatype

9. ODBC (I-net 5.01 for windows) Drivers!!???

10. ODBC DBase driver and ADO.net

11. Net ODBC Driver for Access

12. ODBC driver for Visual Basic 6 or VB.NET