ODBC Connect to SQL server 6.5 
Author Message
 ODBC Connect to SQL server 6.5

i want to make a connection to a sql server 6.5 by useing the following code

DBEngine.DefaultType = dbUseODBC
Dim cConn As Connection
Dim rs as Recordset
    Set cConn = OpenConnection("Cnew", dbDriverNoPrompt, False,
 sql = "select * from adressenstamm"
Set rs = cConn.OpenRecordset(sql, dbOpenDynaset, 0, dbOptimistic)

when the dsn is using nt authentication then it is not possible to make a
recordset. i allways get the error 3124 on row set rs...
i was logged on as administrator so there was no security problem on the sql

with the same code and dsn using sql server authentication there is no
what can i do

Sun, 13 May 2001 03:00:00 GMT  
 [ 1 post ] 

 Relevant Pages 

1. connecting to MS SQL Server 6.5 using VB5

2. Connect to SQL-Server 6.5

3. Connect to 2 different SQL Server 6.5 db

4. Connect to 2 different SQL server 6.5 Dbs

5. How to connect to SQL Server 6.5 using VB 5.0

6. Connecting to SQL Server 6.5 and 7.0

7. ODBC Direct and SQL Server 6.5

8. VB4, SQL Server 6.5, RDO and ODBC

9. ODBC with SQL Server 6.5 in VB 4

10. Problems with ODBC drivers for SQL Server 6.5

11. ODBC and SQL Server 6.5 problem.

12. Creating ODBC connection to SQL Server 6.5 with VB4


Powered by phpBB® Forum Software