Pass-Through Query Help

Please be advised that "Tom Wimpernark" is an alias used by Aaron Kempf.


"Prince" wrote in message
...
Hi,
I got 20 million records in history table and I am using pass through
queries for report writing and doing most of the work on Server, could you
please advise in this senario what should I do And could you please send
some
more details on "Access Data Projects" - thanks

a) Do I need to rewrite my reports??
b) Pass through queries will not work on client ?

Thanks for help


"Tom Wimpernark" wrote:

you shouldn't be using pass-through, it is no longer the reccomended way
to
use SQL Server data.

you should be using Access Data Projects



"Prince" wrote in message
...
Hi,

I had a same issue I am trying to use above string it works on Server
(I
am
working on) but on client computer it's not working please see below
eror:

Connection failed:
SQL State: 28000
SQL Server Error: 18456
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed
fro
user 'AM\bpa..'

Any suggestions??

Regards,


"Douglas J. Steele" wrote:

Assuming you replaced DatabaseName and ServerName with the appropriate
names, is your database set up for Trusted Connection, or are you
using
SQL
Authentication (which requires that you provide a user name and
password)?

If you're using SQL Authentication, you'll need

ODBC;Driver={SQL
Server};Server=MyServerName;Database=myDatabaseNam e;Uid=myUsername;Pwd=myPassword

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"doodle" wrote in message
ups.com...
Doug,

I changed it to:

ODBC;DRIVER={sql
server};DATABASE=DatabaseName;SERVER=ServerName;Tr usted_Connection=Yes;

i am still getting an error that the connection to the server
failed.

ofer,

if i use the build button to select the DSN then my users will need
to
add that DSN as well, right?

-doodle

Is he around OR can anyone else advise on below question please!

"George Hepworth" wrote:

Please be advised that "Tom Wimpernark" is an alias used by Aaron Kempf.


"Prince" wrote in message
...
Hi,
I got 20 million records in history table and I am using pass through
queries for report writing and doing most of the work on Server, could you
please advise in this senario what should I do And could you please send
some
more details on "Access Data Projects" - thanks

a) Do I need to rewrite my reports??
b) Pass through queries will not work on client ?

Thanks for help


"Tom Wimpernark" wrote:

you shouldn't be using pass-through, it is no longer the reccomended way
to
use SQL Server data.

you should be using Access Data Projects



"Prince" wrote in message
...
Hi,

I had a same issue I am trying to use above string it works on Server
(I
am
working on) but on client computer it's not working please see below
eror:

Connection failed:
SQL State: 28000
SQL Server Error: 18456
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed
fro
user 'AM\bpa..'

Any suggestions??

Regards,


"Douglas J. Steele" wrote:

Assuming you replaced DatabaseName and ServerName with the appropriate
names, is your database set up for Trusted Connection, or are you
using
SQL
Authentication (which requires that you provide a user name and
password)?

If you're using SQL Authentication, you'll need

ODBC;Driver={SQL
Server};Server=MyServerName;Database=myDatabaseNam e;Uid=myUsername;Pwd=myPassword

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"doodle" wrote in message
ups.com...
Doug,

I changed it to:

ODBC;DRIVER={sql
server};DATABASE=DatabaseName;SERVER=ServerName;Tr usted_Connection=Yes;

i am still getting an error that the connection to the server
failed.

ofer,

if i use the build button to select the DSN then my users will need
to
add that DSN as well, right?

-doodle

My point is that you don't need to be concerned about these issues.

SQL Pass-Thrus will be around for the foreseeable future.

ADPs and DAPs, while still viable, are NOT particularly high on the list of
approaches Microsoft recommends.

Pay attention to the recommendations from Doug Steele about working with
your data.




"Prince" wrote in message
...
Is he around OR can anyone else advise on below question please!

"George Hepworth" wrote:

Please be advised that "Tom Wimpernark" is an alias used by Aaron Kempf.


"Prince" wrote in message
...
Hi,
I got 20 million records in history table and I am using pass through
queries for report writing and doing most of the work on Server, could
you
please advise in this senario what should I do And could you please
send
some
more details on "Access Data Projects" - thanks

a) Do I need to rewrite my reports??
b) Pass through queries will not work on client ?

Thanks for help


"Tom Wimpernark" wrote:

you shouldn't be using pass-through, it is no longer the reccomended
way
to
use SQL Server data.

you should be using Access Data Projects



"Prince" wrote in message
...
Hi,

I had a same issue I am trying to use above string it works on
Server
(I
am
working on) but on client computer it's not working please see below
eror:

Connection failed:
SQL State: 28000
SQL Server Error: 18456
[Microsoft][ODBC SQL Server Driver][SQL Server]Login
failed
fro
user 'AM\bpa..'

Any suggestions??

Regards,


"Douglas J. Steele" wrote:

Assuming you replaced DatabaseName and ServerName with the
appropriate
names, is your database set up for Trusted Connection, or are you
using
SQL
Authentication (which requires that you provide a user name and
password)?

If you're using SQL Authentication, you'll need

ODBC;Driver={SQL
Server};Server=MyServerName;Database=myDatabaseNam e;Uid=myUsername;Pwd=myPassword

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"doodle" wrote in message
ups.com...
Doug,

I changed it to:

ODBC;DRIVER={sql
server};DATABASE=DatabaseName;SERVER=ServerName;Tr usted_Connection=Yes;

i am still getting an error that the connection to the server
failed.

ofer,

if i use the build button to select the DSN then my users will
need
to
add that DSN as well, right?

-doodle