Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Bobba Buoy
Starting Member
36 Posts |
 Posted - 2003-08-07 : 06:18:08
|
| This is weird. I have (identical) copies of sql server running on two seperate machines. I have a vb app that accesses the data. It runs with both dbs but I have the following function that I call to show the record count in a particular display: Code:-------------------------------------------------------------------------------- Dim rs As Recordset 'determines number of records in a sql statement Set rs = New ADODB.Recordset rs.Open sql, conn, adOpenStatic, adLockOptimistic RecordCount = rs.RecordCount rs.Close Set rs = Nothing--------------------------------------------------------------------------------With one db it works just fine but with the other it returns a value of -1 even though the data is displayed just fine. Any ideas? |
|
|
Bobba Buoy
Starting Member
36 Posts |
Posted - 2003-08-07 : 06:20:49
|
| PLEASE DISREGARD THIS TOPIC! I INADVERTANTLY TITLED IT INCORRECTLY AND HAVE RESUBMITTED IT WITH THE CORRECT TITLE. I APOLOGIZE FOR THE INCONVENIENCE! |
 |
|
|
|
|
|
Replication/Admin Help