[AccessD] OLEDB connection string

Hi David
Yes I tried that method. I'm sterting to think the connection string is fine
but this "Installable ISAM..." error is preventing me applying it for some
reason. 

Thanks anyway. Appreciate the help.

Andy

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of David McAfee
Sent: 01 June 2012 16:59
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] OLEDB connection string


Right click on your desktop.
Choose New->text document

Rename the file something like test.udl (removing the .txt suffix)

Confirm the change of file extension

Double click the test.udl file you just created.

The connection tab should already be chosen, choose the server in the top
drop down.
Enter the username and password (up to you if you want to check the save
password box)

Choose the database in the bottom drop down.

Test connection.

Press OK.

Open the UDL file in Notepad to see your connection string.


HTH
David


On Fri, Jun 1, 2012 at 12:06 AM, 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