[AccessD] OLEDB connection string - Help please

Thansk michael, will play with that over the weekend

Andy


On 01 June 2012 at 15:43 Michael Mattys <michael at mattysconsulting.com> wrote:

> I don't know, but I've found that sqlncli.msi helps sometimes.
> http://www.microsoft.com/en-us/download/details.aspx?id=16177
>
> Michael R Mattys
> Mattys Consulting, LLC
> www.mattysconsulting.com
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Andrew Lacey
> Sent: Friday, June 01, 2012 10:11 AM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] OLEDB connection string - Help please
>
> Hi Michael
> thanks for responding. Yes I can get the connect string in the immediate
> window.
> It's currently using ODBC but I'm desperately trying to switch to OLEDB in
> order to avoid all of the ODBC setup. It's the .refreshLink after the
> .Connect = which gives the "Could not find installable ISAM" error. I don't
> know how to cure that. Google found an MS rpage which said a registry ntry
> was wrong but the correct one is exactly what I already have.
>
> Andy
>
>
> On 01 June 2012 at 14:11 Michael Mattys <michael at mattysconsulting.com>
> wrote:
>
> > Andy,
> >
> > Can you type in the Immediate Window
> > Currentdb.TableDefs("TableName").Connect?
> >
> > Are you using Management Studio?
> > Someone on the web suggested restarting the service, if that's
> > possible for you.
> >
> > Michael R Mattys
> > Mattys Consulting, LLC
> > www.mattysconsulting.com
> >
> >
> > -----Original Message-----
> > From: accessd-bounces at databaseadvisors.com
> > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Andrew
> > Lacey
> > Sent: Friday, June 01, 2012 8:32 AM
> > To: Access Developers discussion and problem solving
> > Subject: Re: [AccessD] OLEDB connection string - Help please
> >
> > Heeeeellllllpppp please
> >
> >
> > On 01 June 2012 at 08:17 Andrew Lacey <andy at minstersystems.co.uk> wrote:
> >
> > > Sorry, the error I'm getting is actually "Could not find installable
> > ISAM".
> > >
> > > Andy
> > >
> > >
> > > On 01 June 2012 at 08:06 Andrew Lacey <andy at minstersystems.co.uk> wrote:
> > >
> > > > Morning all
> > > >
> > > >
> > > >
> > > > I know I'm late to this but I'm trying to setup an OLEDB
> > > > connection string to SQL Server. I've found info on the web for
> > > > this but I'm not having any joy.
> > > > This
> > > > is a code snippet of what I have.
> > > >
> > > >
> > > >
> > > > strConnect = "Provider=SQLOLEDB;Data Source=FRGRAAPP02;Initial
> > > > Catalog=TALEG_CI;IntegratedSecurity=SSPI;"
> > > >
> > > > tdf.Connect = strConnect
> > > >
> > > >
> > > >
> > > > where tdf is defined as DAO.Tabledef and is sitting on a table
> > > > definition of a table currently linked to an MDB. The code fails,
> > > > however, with "Error Attaching tablename". Can anyone see what I'm
> > > > doing wrong? The Data Source is the server name and TALEG_CI is
> > > > the SQL Database which has no security on it. We're wanting to use
> > > > Windows authentication.
> > > >
> > > >
> > > >
> > > > Help please. I really need this.
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com