 |
| SQL Server 2000 General discussion of Microsoft SQL Server -- for topics that don't fit in one of the more specific SQL Server forums. version 2000 only. There's a new forum for SQL Server 2005. |
Welcome to the p2p.wrox.com Forums.
You are currently viewing the SQL Server 2000 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
|
|
|
|
May 29th, 2004, 10:24 PM
|
|
Registered User
|
|
Join Date: Feb 2004
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
ODBC connection
Hi,
Iâm trying to access SQL sever 2000 database from my client machine by using ODBC connection and, the problem is that I âm not able to view all the databases. I have checked the security and I was given full access to all databases.
The DB has a user name and the password.
Note: The OS is Windows 2000.
Best Regards
|
|
May 30th, 2004, 12:02 AM
|
|
Friend of Wrox
|
|
Join Date: Jun 2003
Posts: 996
Thanks: 2
Thanked 11 Times in 11 Posts
|
|
if u have given full access to all databases for user u should see them. check it once more u may have done something wrong.
Can u login from Query Analyzer?!
Always:),
Hovik Melkomian.
|
|
May 30th, 2004, 08:37 AM
|
|
Friend of Wrox
|
|
Join Date: Jun 2003
Posts: 1,998
Thanks: 0
Thanked 3 Times in 3 Posts
|
|
Hello,
If you've been given full access, you should have no problem seeing the databases... Was it you or a SQL Server login given full access. If the SQL Server login, when you connect to a SQL Server machine, you have to provide the login credentials. If you edit your SQL Server registration, you can use the credentials of that user.
Brian
|
|
May 31st, 2004, 12:24 AM
|
|
Registered User
|
|
Join Date: Feb 2004
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Melvik and bmains,
Thank you very much for your replays,
Regarding the access I have check it and, I tried to use admin user name & Password and I can't access buy using Query Analyzer !!!!
Regards
|
|
May 31st, 2004, 02:13 AM
|
|
Friend of Wrox
|
|
Join Date: Jun 2003
Posts: 518
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
ODBC connection normally use for access the one database by the program.
if you view all database install sql server client side and
from the client side go to sql serve group, there will your server
which sql server install, right click your server and click
new sql server register.
register you machine with the server.
regards.
Quote:
quote:Originally posted by mishaq
Hi,
Iâm trying to access SQL sever 2000 database from my client machine by using ODBC connection and, the problem is that I âm not able to view all the databases. I have checked the security and I was given full access to all databases.
The DB has a user name and the password.
Note: The OS is Windows 2000.
Best Regards
|
|
|
May 31st, 2004, 10:18 AM
|
|
Friend of Wrox
|
|
Join Date: Jun 2003
Posts: 996
Thanks: 2
Thanked 11 Times in 11 Posts
|
|
Well if u can not connect from Analyzer insure u can not use this login for App too! so first make it OK from there & then switch to App.
What r u trying to do?! Connect to MS-SQL Server from App by a program u made or just wanna Register new Database in Enterprise Manager I dont think so mateenmohd?!
Keep in touch.
Always:),
Hovik Melkomian.
|
|
June 1st, 2004, 02:33 AM
|
|
Registered User
|
|
Join Date: Feb 2004
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
I am trying to access my DB from the Clint side.
Best regards
|
|
June 1st, 2004, 08:02 AM
|
|
Friend of Wrox
|
|
Join Date: Jun 2003
Posts: 1,998
Thanks: 0
Thanked 3 Times in 3 Posts
|
|
Hello,
You sure it's the correct password?
Brian
|
|
June 1st, 2004, 09:39 AM
|
|
Friend of Wrox
|
|
Join Date: Jun 2003
Posts: 996
Thanks: 2
Thanked 11 Times in 11 Posts
|
|
from Enterprise Manager Open a Query Analyzer using Tools menu!
see what user it shows & use direct connect from Query Analyzer this time. Yes! maybe u use wronge Password.
Always:),
Hovik Melkomian.
|
|
June 7th, 2004, 01:02 AM
|
|
Registered User
|
|
Join Date: Feb 2004
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
I am sure from the password,!!!
|
|
|
