[AccessD] OLEDB connection string - Help please

Ok, thanks Jim. Another to try.

Andy

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Lawrence
Sent: 01 June 2012 17:40
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] OLEDB connection string - Help please


Hi Andy:

Your ODBC file component, that you created and connected via your ODBC data
source administrator, should have a UDL extension. To expose the actual
connection string, that can be used, with the subsequent OLEDB connection,
either read the file with Notepad or change the extension to TXT.

Jim 

-----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:06 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] OLEDB connection string - Help please

Oh it's there alright. I'm working with it fine using ODBC. Just want to
switch
to OLEDB.

Andy


On 01 June 2012 at 15:49 Jim Lawrence <accessd at shaw.ca> wrote:

> Hi Andy:
>
> Have you gone through all the basics? Sometimes the connection strings are
> not wrong and it could just be that the connection is not working.
>
> Have you tried to "ping" or "net" the connector via IP address and name,
at
> the command prompt?
>
> ping 24.123.456.5 or ping mydatabase.com
> ...and...
> net view and net use t: \\MyServer\MyShare
> ...and...
> net use s: \\MyServer\MyShare\ MyPassword /user:MyUsername /persistent:no
> ...or...
> net use s: \\192.168.199.210\MyShare\ MyPassword /user:MyUsername
> /persistent:no
>
> To remove test: net use s: /delete
>
> Once you are sure you can see and connect on a basic level then you will
> feel more confident that you know you DB BE is there.
>
> HTH
> Jim
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Andrew Lacey
> Sent: Friday, June 01, 2012 5: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
-- 
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