Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Annatar
Starting Member
1 Post |
 Posted - 2012-05-04 : 02:41:37
|
| Hi,My first post here, so greetings.My problem is that I am trying to reach to a database currently stored in MSSQL 2008 R2 server from a Java program. I managed to establish the connection via jTDS JDBC driver, but Netbeans can only see the system databases, not the particular database I want it to.It had been suggested that this problem may be database related and currently I am at my wit's end, so I am posting here. Can anyone help me?Thanks. |
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2012-05-04 : 19:07:40
|
| What is the LOGIN you are using to establish your connection? Which databases does that LOGIN have access to and what USER does it map to in each database? Finally, what rights does that USER have in each database?Also, what is the database used in the connection? If it is the default, it could be using the MASTER database. Have you tried explicitly using the desired database name either through the connection string or by executing a "USE MyDatabase" SQL statement?=================================================There is a foolish corner in the brain of the wisest man. -Aristotle, philosopher (384-322 BCE) |
 |
|
|
|
|
|
Database Connection Problem.