ODBC error - help

  • Thread starter Thread starter thriveni
  • Start date Start date
T

thriveni

I use Access 2000 to connect and link to some tables in
SQL server 2000.
I have some reports in access2000 that display information
from these linked tables. There is no VBA programming here.
The application works fine on my machine but for another
user when she tries to view the reports it gives her the
error :
Connection Failed:
SQL state 28000
SQL server error 18456
[Microsoft][ODBC Sql server driver][SQL server]:Login
failed <domain name/user name>
then a pop up appears where I have to disable trusted
connection and login in with another id.
How can I change this, to login with the second ID always.
Do I have to setup a datasource and If i do how do I link
it to this application without having to program for it.

Any help will be appreciated.

..
 
It is the permission to the SQL Server you need.

The simplest way is to give the other user permission to
the database on the SQL Server. You may need to get your
SQL Server Administrator to do this for you.

You can also set up the DSN with appropriate UserID /
Password on the other user's PC.

HTH
Van T. Dinh
MVP (Access)
 
I already have a DSN with the information need but the
database does not seem to pick up that login/server info.
Is there something I am missing, like linking the DSN to
the database ?
-----Original Message-----
It is the permission to the SQL Server you need.

The simplest way is to give the other user permission to
the database on the SQL Server. You may need to get your
SQL Server Administrator to do this for you.

You can also set up the DSN with appropriate UserID /
Password on the other user's PC.

HTH
Van T. Dinh
MVP (Access)


-----Original Message-----
I use Access 2000 to connect and link to some tables in
SQL server 2000.
I have some reports in access2000 that display information
from these linked tables. There is no VBA programming here.
The application works fine on my machine but for another
user when she tries to view the reports it gives her the
error :
Connection Failed:
SQL state 28000
SQL server error 18456
[Microsoft][ODBC Sql server driver][SQL server]:Login
failed <domain name/user name>
then a pop up appears where I have to disable trusted
connection and login in with another id.
How can I change this, to login with the second ID always.
Do I have to setup a datasource and If i do how do I link
it to this application without having to program for it.

Any help will be appreciated.

..


.
Click to expand...
.
Click to expand...
 
Do you mean you already set up the DSN on the other user's computer with
permitted UserID and password and you have used this DSN to link Tables?

Note that the DSN set up on *your* computer won't be carried over to the
other user's computer.

Personally, I prefer to use DNS-less link. See Douglas J. Steele's Web
site:

http://members.rogers.com/douglas.j.steele/DSNLessLinks.html

--
HTH
Van T. Dinh
MVP (Access)



I already have a DSN with the information need but the
database does not seem to pick up that login/server info.
Is there something I am missing, like linking the DSN to
the database ?
-----Original Message-----
It is the permission to the SQL Server you need.

The simplest way is to give the other user permission to
the database on the SQL Server. You may need to get your
SQL Server Administrator to do this for you.

You can also set up the DSN with appropriate UserID /
Password on the other user's PC.

HTH
Van T. Dinh
MVP (Access)


-----Original Message-----
I use Access 2000 to connect and link to some tables in
SQL server 2000.
I have some reports in access2000 that display information
from these linked tables. There is no VBA programming here.
The application works fine on my machine but for another
user when she tries to view the reports it gives her the
error :
Connection Failed:
SQL state 28000
SQL server error 18456
[Microsoft][ODBC Sql server driver][SQL server]:Login
failed <domain name/user name>
then a pop up appears where I have to disable trusted
connection and login in with another id.
How can I change this, to login with the second ID always.
Do I have to setup a datasource and If i do how do I link
it to this application without having to program for it.

Any help will be appreciated.

..


.
Click to expand...
.
Click to expand...
Click to expand...
 
Thanks for your reposonse.
I did setup the DSN but I did not re-link the tables.
Actually this access DB is accessed off the web, from a
shared directory. There are 3 other users for this
DB. As a temporary fix I can create a DSN on each machine
and then re-link their tbales but would it work since it
is the same application that I will be re-linking to in 3
different machines. ?
After this quick fix I can look at creating a DSN less
connection.
-----Original Message-----
Do you mean you already set up the DSN on the other user's computer with
permitted UserID and password and you have used this DSN to link Tables?

Note that the DSN set up on *your* computer won't be carried over to the
other user's computer.

Personally, I prefer to use DNS-less link. See Douglas J. Steele's Web
site:

http://members.rogers.com/douglas.j.steele/DSNLessLinks.ht ml

--
HTH
Van T. Dinh
MVP (Access)



I already have a DSN with the information need but the
database does not seem to pick up that login/server info.
Is there something I am missing, like linking the DSN to
the database ?
-----Original Message-----
It is the permission to the SQL Server you need.

The simplest way is to give the other user permission to
the database on the SQL Server. You may need to get your
SQL Server Administrator to do this for you.

You can also set up the DSN with appropriate UserID /
Password on the other user's PC.

HTH
Van T. Dinh
MVP (Access)



-----Original Message-----
I use Access 2000 to connect and link to some tables in
SQL server 2000.
I have some reports in access2000 that display
information
from these linked tables. There is no VBA programming
here.
The application works fine on my machine but for another
user when she tries to view the reports it gives her the
error :
Connection Failed:
SQL state 28000
SQL server error 18456
[Microsoft][ODBC Sql server driver][SQL server]:Login
failed <domain name/user name>
then a pop up appears where I have to disable trusted
connection and login in with another id.
How can I change this, to login with the second ID
always.
Do I have to setup a datasource and If i do how do I link
it to this application without having to program for it.

Any help will be appreciated.

..


.

.
Click to expand...
Click to expand...


.
Click to expand...
 
Don't you have a separate Front-End on each machine?

You really should. It is safer to have each user using a separate copy of
the Front-End.
 
Back
Top