Creating a windows Authentication DSN

Can this code be changed to use the windows Authentication instead of the
SQL Server login?
http://www.mvps.org/access/tables/tbl0014.htm
You need to add the keyword/value of Trusted_Connection=Yes
so you could try modifying the SQLConfigDataSource code by
including:
"Trusted_Connection=Yes" & Chr(0)
You can find the ODBC API reference for SQLConfigDataSource
at:
http://msdn.microsoft.com/library/de...dbc_c_99yd.asp
-Sue
On Mon, 23 Jan 2006 11:24:02 -0000, "Chris" <a@.b.com> wrote:

>Can this code be changed to use the windows Authentication instead of the
>SQL Server login?
>http://www.mvps.org/access/tables/tbl0014.htm
>

Creating a windows Authentication DSN

Can this code be changed to use the windows Authentication instead of the
SQL Server login?
http://www.mvps.org/access/tables/tbl0014.htmYou need to add the keyword/value of Trusted_Connection=Yes
so you could try modifying the SQLConfigDataSource code by
including:
"Trusted_Connection=Yes" & Chr(0)
You can find the ODBC API reference for SQLConfigDataSource
at:
_99yd.asp" target="_blank">http://msdn.microsoft.com/library/d...r />
_99yd.asp
-Sue
On Mon, 23 Jan 2006 11:24:02 -0000, "Chris" <a@.b.com> wrote:

>Can this code be changed to use the windows Authentication instead of the
>SQL Server login?
>http://www.mvps.org/access/tables/tbl0014.htm
>

Creating a user for replication

Anyone have the steps (permissions and etc...) to create a user for use only in replications instead use "sa" login ?we have created a dedicated login for the Replication with sa rights|||but the user need to have sa role ?!|||Yes it needs to have the sa Rights..sql

Create verticle grouping instead of horizontal

Hello,
Generally when using the Report Wizard with MS SQL 2005 it wants to present
the data horizontally, like this:
Item 1 Item2 Item3 Item4 Item5
Value1a Value2a Value3a Value4a Value5a
Value1b Value2b Value3b Value4b Value5b
... and so forth.
Instead of this, I need my report to present the data vertically, like this:
Item1 Value1a Value1b
Item2 Value2a Value2b
Item3 Value3a Value3b
Item4 Value4a Value4b
Item5 Value5a Value5b
I'm actually limiting this query to the Top 4 so it will only show columns
of data. Problem is, I have no idea how change the orientation of the
table. Can someone give me
some guidance on how to accomplish this? I'm using VB.Net 2003 to create
the report.
Thanks,
AlexOn Jul 26, 10:07 am, "Alex" <sama...@.gmail.com> wrote:
> Hello,
> Generally when using the Report Wizard with MS SQL 2005 it wants to present
> the data horizontally, like this:
> Item 1 Item2 Item3 Item4 Item5
> Value1a Value2a Value3a Value4a Value5a
> Value1b Value2b Value3b Value4b Value5b
> ... and so forth.
> Instead of this, I need my report to present the data vertically, like this:
> Item1 Value1a Value1b
> Item2 Value2a Value2b
> Item3 Value3a Value3b
> Item4 Value4a Value4b
> Item5 Value5a Value5b
> I'm actually limiting this query to the Top 4 so it will only show columns
> of data. Problem is, I have no idea how change the orientation of the
> table. Can someone give me
> some guidance on how to accomplish this? I'm using VB.Net 2003 to create
> the report.
> Thanks,
> Alex
You will want to look into using either a matrix report or pivoting
the data in the stored procedure/query that is souring the report.
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant