[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.
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > > Cheers
> > >
> > >
> > >
> > > Andy
> > > --
> > > 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
> --
> 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