SQL Error 1157 
Author Message
 SQL Error 1157

I am trying to get a connection to a SQL Server database using
VB4 through ODBC. This is the error I get:
Connection failed:
SQLState: 'S1000'
SQL Server Error: 1157
[Microsoft][ODBC SQL Server Driver]Unable to load communication
module.  Driver has not been correctly installed.
Connection falied:
SQLState: '08001'
SQL Server Error: 0
[Microsoft][ODBC SQL Server Driver]Unable to connect to data
I have reinstalled the ODBC Driver and had no luck.
Here is the code that causes the error:
  Public strConnect As String
  Public mrdoEnv As rdoEnvironment
  Public mrdoConn As Object
  Public mbEnvOpen  As Integer
  Public mbConnOpen  As Integer
Sub main()
    rdoEngine.rdoDefaultCursorDriver = rdUseOdbc
    Set mrdoEnv = rdoEngine.rdoCrea{*filter*}vironment("", "sa", "")
    Set mrdoConn = mrdoEnv.OpenConnection("NCHFA",
rdDriverPrompt, False, "") 'This is the line that causes the

David Coulter

Mon, 01 Nov 1999 03:00:00 GMT  
 [ 1 post ] 

 Relevant Pages 

1. SQL Error 1157

2. ERROR Code 0x80004005 : ERROR Code 0xfee670 : ERROR 1157

3. Error Code 1157

4. Visio and general 1157 errors

5. ODBC Error 1157 (Driver could not be loaded)

6. ODBC Error 1157 (Driver could not be loaded)

7. Error 20639: SQL Expression error - Error in creating SQL Expression COM Parser (cpeaut32)

8. Crystal error: error ocurred reading records: error in compiling sql expression

9. RDO error when upgrading from SQL 6.5 to SQL 7.0

10. SQL - Instcat.sql - Error catalog store procedures

11. Error 20527 : SQL Server Error

12. Error 3131 Syntax error in FROM clause - using SQL accessing external ODBC problem


Powered by phpBB® Forum Software