[AccessD] OLEDB connection string - Help please

Michael Mattys michael at mattysconsulting.com
Fri Jun 1 09:43:09 CDT 2012


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



More information about the AccessD mailing list