[AccessD] Get an updateable ADODB recordset form SQL Server

Hi,

To get a connection string, I do the following:

1- create a text file
2- Change txt to udl
3- dblclick on the file to open it, which open a connection assistant
4- Use the assistant to perform the connection
5- Test the connection with the button provided by the assistant
6- Close the assistant.
7- Open the file as text file: the connection string is there !

hth,

Philippe


2010/5/25 Mark Simms <marksimms at verizon.net>

> Const strConn = "ODBC;DRIVER=SQL Server;SERVER=BP001;APP=Microsoft Office
> 2003;WSID=PHL0549;DATABASE=WFMREPORT;Trusted_Connection=Yes"
>
> Something like the above ?
>
> > -----Original Message-----
> > From: accessd-bounces at databaseadvisors.com
> > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
> > Sent: Tuesday, May 25, 2010 2:34 PM
> > To: Access Developers discussion and problem solving
> > Subject: [AccessD] Get an updateable ADODB recordset form SQL Server
> >
> > I use a trusted connection (there is no username / password)
> > for my sql server.  I need a connection string to do that
> > from Access, and I am not finding that.
> >
> > Anybody?
> >
> > --
> > John W. Colby
> > www.ColbyConsulting.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
>