Indefinite hang after making ODBC connection to sqlserver6.5 using VB5 
Author Message
 Indefinite hang after making ODBC connection to sqlserver6.5 using VB5

I am new to using sql server, and having problems.  My surrent problem
is that after I make an ODBC connection to the sqlserver using the code
below,  the application then either hangs indefinitely or tells me that
I am out of stack space.
If it hangs, it never gets past making the odbc connection; I'm not sure
how far it gets before running out of stack space (it always hangs when
I step thru it using the de{*filter*}).

I don't think that the rest of the code has too many nested function
calls (how many is too
many, anyway?), and there are no recursive calls, so I'm not sure where
to look to fix the stack space thing when I can consistently get there.

Any pointers on what I am doing wrong, or what I should be looking for?
  Dim ssql As String

      Set db = OpenDatabase("thesePubs", False, False, "ODBC")

      ssql = "Select distinctrow titles.*, publishers.* from publishers
inner join titles on publishers.pub_id = titles.pub_id order by
      Set rs = db.OpenRecordset(ssql)

      If rs.EOF And rs.BOF Then
            totrec = 1
            totrec = rs.RecordCount
      End If

Mon, 25 Sep 2000 03:00:00 GMT  
 [ 1 post ] 

 Relevant Pages 

1. VB5 hangs up while making EXE

2. ODBC connections using ODBC

3. DAO 3.51 Workspaces with odbc to excel97 and to sqlserver6.5

4. VB5 ODBCdirect Connection hangs after first use

5. Program using ODBC hangs for awhile...

6. How to determine a network connection(not internet) made using a crossover cable

7. VB5 / Oracle 7 ODBC connection

8. DAO350.DLL page fault error - VB5 odbc connection to local SQL Server7

9. ODBC transition question from VB4 to VB5, the connection object

10. ODBC error for VB5 connection to Oracle

11. I made a project using VB5 having access to MS Sql server through odbc, i configured a data source in control panel, it ODBC disconnected

12. Using ODBC Data Sources in Connection String


Powered by phpBB® Forum Software