Reading a .MDF SQL Server 2005 Express File with Jaba

Chris Ichikawa 0 Newbie Poster

15 Years Ago

Hello, everyone.

Can someone explain to me on how to read a .mdf file (the SQL Server 2005 Express kind)?

I have a Java IDE (JCreator) and the JDBC (SQL Server 2005 Express compatible) installed into this computer. Right now, I'm using this:

Connection c = java.sql.DriverManager.getConnection("jdbc:sqlserver://localhost\\SQLEXPRESS;DatabaseName=qsscsdb;IntegratedSecurity=True");

to read the file, but my Java IDE won't let me. I get this:

com.microsoft.sqlserver.jdbc.SQLServerException: Cannot open database "qsscsdb" requested by the login. The login failed.

My .mdf file path is here, specifically:

C:\Users\WinVistaUser\Documents\qsscsdb.mdf

Where have I gone wrong? Is there a way to directly specify the file's path in full?

java

1 Contributor
0 Replies
68 Views

Be the first to reply

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.