Creating stored-procedures 
Author Message
 Creating stored-procedures

Hi Sybrand,

Quote:
> We are using Access97 in combination with SQL-Server 6.5.
> How can I define a stored-procedure in Access and then execute it on
> SQL-Server?

Normally a stored-procedure is not "defined" within a client tool such as
Access. You would user SQL Server tools to do this.

However, part of the Upsizing Tools for Access 95 is a little utility that
lets you work with SP's and triggers and so forth using Access. The UT for
Access 95 are available on MS's web site. I don't believe the version for
Access 97 is out yet.

To execute the SP you can use a pass-through query. A pass-through query
basically sends whatever you type directly to the server. See the docs for
more info.

--
-- Jim F, FMS
    http://www.*-*-*.com/



Sun, 04 Jul 1999 03:00:00 GMT  
 Creating stored-procedures

Hello,

We are using Access97 in combination with SQL-Server 6.5.
How can I define a stored-procedure in Access and then execute it on
SQL-Server?

Many thanks in advance!!

Sybrand Boonstra,



Sun, 04 Jul 1999 03:00:00 GMT  
 Creating stored-procedures

In addition to Jim's response, you should be taking a *close* look at
ODBC-Direct. This extension to DAO (new in Access 97) allows you a great
deal of flexibility in dealing with server data, stored procedures, views,
cursors and transactions. Search Access on line help for ODBC Direct for
more information.

This new feature is one the top 3 new features in Access 97, and makes
Access as capable (and better in many cases) than Visual Basic for
client/server development.
--
Dan Haught
FMS Inc.
http://www.fmsinc.com



Quote:
> Hello,

> We are using Access97 in combination with SQL-Server 6.5.
> How can I define a stored-procedure in Access and then execute it on
> SQL-Server?

> Many thanks in advance!!

> Sybrand Boonstra,




Mon, 05 Jul 1999 03:00:00 GMT  
 Creating stored-procedures

Quote:
> We are using Access97 in combination with SQL-Server 6.5.
> How can I define a stored-procedure in Access and then execute it on
> SQL-Server?

Well dear Sybrand, just read the report I wrote after migrating the
"activiteitenscherm" to SQL-server. In this report an example of what u're
asking for is included.

Greetings richard steijn



Fri, 09 Jul 1999 03:00:00 GMT  
 
 [ 4 post ] 

 Relevant Pages 

1. Create Stored Procedures in VB.NET

2. Utility to create Stored Procedures

3. How do you create stored procedures in ADO?

4. Creating stored procedures using ADOX

5. Creating Stored Procedures on SQLServer 7 with ADOX

6. To Stored Procedure or not to stored procedure

7. To stored procedure or not to stored procedure

8. sub report changes its source stored procedure to main report's stored procedure

9. To stored procedure or not to stored procedure

10. ado recordsets from stored procedures, stored procedures have input parameters

11. Create a Stored Procedure for MSDE via code?

12. Update: Utility to create VB Class Files and Stored Procedures

 

 
Powered by phpBB® Forum Software