[AccessD] OLEDB connection string

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