[AccessD] Stored procedures from Access

If you aren't connected to a database, then you have to create a session
object.  What provider are you using?

Charlotte Foust 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Thursday, January 22, 2009 12:47 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Stored procedures from Access

Martin,

As soon as I try to set the cmd.ActiveConnection = cnn I get an error:

Requested operation requires an ole db session object, which is not
supported by the current provider.

That is when modifying Charlotte's code with your modifications.

John W. Colby
www.ColbyConsulting.com


Martin Reid wrote:
> Currentproject.connection will not work. Its to allow you to share a
conenctionalready established with SQL Server and used by Access for
examaple in an ADP.
> 
> conenction here to SQL  Server 2005.
> 
> Dim conn As ADODB.Connection
> Dim cmd As ADODB.Command
> 
> Set conn = New ADODB.Connection
> conn.ConnectionString = "Provider=sqloledb;Data
Source=YOURSERVER;Initial Catalog=NWind;Integrated Security=SSPI;"
> conn.CursorLocation = adUseClient
> 
> Change the server name and the catalog (database)
> 
> And you shoudl be good to go.
> 
> Martin
> 
> 
> 
> 
> Martin WP Reid
> Information Services
> Queen's University
> Riddel Hall
> 185 Stranmillis Road
> Belfast
> BT9 5EE
> Tel : 02890974465
> Email : mwp.reid at qub.ac.uk
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com