I have a call to a stored procedure that worked fine when connecting
to a SQL 6.5 server, but returns a RDO Error Number 40041 when looking
at the same DB in SQL 7.0.

Here is the portion of code that causes the error:

Two Forms (Main and frmLogin) and a stored procedure

Main:  
  Public g_ucDB As New AtechSP   (Project Designers stored procedures)

frmLogin:
  Dim rs As rdoRecordset
  Dim strServerDate As String

  Set rs = Main.g_ucDB.rdoQueries!ati_get_current_server_date.OpenResultset()
  strServerDate = rs("serverdate")

ati_get_current_server_date:
  select convert(varchar(10), getdate(), 101)  
  serverdate

Stepping through the code I found it dies on the Set rs line.

I know there are other ways to get a date, but this type of code is
used throughout the application, so if there is a way to get this line
to work, it should help on all the others.

Thanks in advance for any help.
Dean Bushy