[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