If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Executing SQL Server 2000 Stored Procs
I need to develop a small access mdb (can't be an ADP because there needs to
be local tables). Mostly the application will be a few buttons that a user can click and each button will kick off sql server 2000 stored procedures. The problem is I am not a VBA programmer. I am a SQL Server programmer. Can someone provide me with the following code snipits? 1) a call to sql server (non-odbc dsn connections) that executes a stored procedure and returns a scalar value. The call must have input parameters. 2) a call to sql server (non-odbc dsn connections) that executes a stored procedure and returns a table, I think it's called a recordset in access. The call must have input parameters. Thom |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
SQL Server ODBC Error | Art Saffran | General Discussion | 0 | March 24th, 2005 02:37 PM |
Runtime Error 2046, when I try to delete a record in an SQL Server table (through an Access 2000 Interface) | Nuno Almeida | General Discussion | 0 | July 14th, 2004 11:54 AM |
calling a stored procedure on MS SQL Server within MS Excel 2000 | Witold Domienik | Worksheet Functions | 2 | March 2nd, 2004 05:35 PM |