[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
>