Converting from Access back end to SQL Server

W

WC Justice

I have a web site that uses an Access 2000 back end. Most of the recordsets
use the rsName.open "qryName"... method. So far, in converting to a SQL
Server back end, I have been changing to the rsName.open "SQL Statement"...
method. Is there a way to create a recordset by calling a stored procedure
or view?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How does a HEAD pointer end up pointing to the first node in a linked list? 3
SessionID length differs between .NET and SQL Server 1
Converting a SQL statment into asp.net (Linq) 0
Open Word Document from SQL Server and Save back again 8
sql 2005 views 1
I'm tempted to quit out of frustration 1
ASP Access to SQL SERVER change 22
Calling SQL Server Stored Procedures: no results from SELECTfollowing INSERT 2

Members online

No members online now.
Total: 32 (members: 0, guests: 32)
Robots: 453

Forum statistics

Threads
473,769
Messages
2,569,580
Members
45,054
Latest member
TrimKetoBoost

Latest Threads

Top