Re: Upsizing issue

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

"Chris Hohmann" <nospam@xxxxxxxxxxxx> wrote in message
news:uNSRv3rSFHA.1896@xxxxxxxxxxxxxxxxxxxxxxx
> "Mark Schupp" <nospam@xxxxxxxxxx> wrote in message
> news:u8OIFjbSFHA.3144@xxxxxxxxxxxxxxxxxxxxxxx
>> "MIMF" <mimf@xxxxxxxxx> wrote in message
>> news:1114448011.544151.290990@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
>>> Correction, they've BOTH told me what someone SHOULDN'T have done, not
>>> what I CAN do now. Their suggestion is basically to manually recode
>>> half the application because of stupid Recordset problem. Thanks a lot,
>>> that's REALLY helpful. With help like that...
>>>
>>
>> That is the "correct" solution to the problem.
>>
>> Had you not offended everyone by calling them stupid you might have been
>> able to get some ideas for a "work-around" that didn't involve fixing
>> every
>> SQL statement and every recordset field reference. Or you might have
>> gotten
>> some pointers about how to more easily replace the offending code using
>> pattern matching and global search and replace tools. As it stands now
>> you
>> probably could not BUY assistance from anyone who has read this thread.
>>
>> --
>> Mark Schupp
>>
>>
> Agreed. I hesitate to suggest the following work-around lest MIMF berate
> me for my stupidity, but here it goes. You could link the SQL Server
> tables in an Access database and then connect to the Access database from
> ASP. I sincerely hope MIMF apologizes for his treatment of Bob and Ray. It
> was unwarranted.


That occurred to me as well but it would probably negate the advantage of
going to SQL Server in the first place.

His idea of creating a custom object wrapped around the standard recordset
object would probably be doable but the effort might be on the same order of
magnitude as modifying the original ASP pages. You would have to build a
custom "connection" object along with a "recordset" object.

--
--Mark Schupp



.

Relevant Pages

  • Re: Cross Database Join, C++ program set up confusion
    ... Well what kind of data are you returning if it is not in Recordset? ... Recordset is returned (it is fractionally faster as ADO does not waste time ... If the default database is db1 on the ... It is a function of SQL Server. ...
    (microsoft.public.vc.database)
  • Re: Full-Text Results to MS Access
    ... Being new to SQL Server and ADO, ... (My database was started in pre-ADO days so the Access ... like a true/false flag, a value, etc., but if the result is a recordset, I ... based on some full-text search criteria. ...
    (microsoft.public.sqlserver.fulltext)
  • Re: SqlCommand.ExecuteReader does not populate Output Parmeters?
    ... He still thinks it's stupid. ... > SQL Server executes statements and how that information flows between the ... > client and the server. ... > verify that output parameters really come at the end of the results at the ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: type argument in OpenRecordset method
    ... For efficiency reasons you should always open the least-functional recordset ... Since you are using SQL Server linked tables, you have a choice of three: ... dbOpenSnapshot: recordset can't be updated, but you can navigate in it. ... Dim strExec As String ...
    (comp.databases.ms-access)
  • Re: Implementation of full text
    ... There is no documented way of accessing the MSSearch catalogs directly other ... tables in SQL Server to identify the row the hit occurs in. ... table to a client from an extended stored procedure. ... To use the recordset returned from the ESP as a virtual table>. ...
    (microsoft.public.sqlserver.fulltext)