I’m unsure

Create New Database connection issue

Edit Subject

I have been having problems trying to determine what needs to go into "create new database connection" window. I've ask our network and dba for help and they seem reluctant to over any insight.

For an MS SQL 2005 database

Name: the server name or database name? (I've tried both to no luck.)
Driver Name: driver on client or server?
URL String:???

2 people have
this question +1

Answered

EMPLOYEE

0

Edit

Delete

Remove

Official

Marek Polasek (Official Rep) October 27, 2009 21:09
When creating a new database connection you specify the connection name and then select driver from the drop-down list. For MS SQL 2005 use MS SQL (jTDS). The URL template will apear:

jdbc:jtds:sqlserver://<host>/<database>

For host type name (or IP address) of your server (example "Houston"), for database type the name of the MS SQL database (example "Northwind"). You may have something like:

jdbc:jtds:sqlserver://Houston/Northwind

The first name in this dialog is the name you are giving to this connection.
Comment

good answer! good answer! (undo)
- Cancel
Edit Your Reply (some HTML allowed)
What's the status of this question?

When creating a new database connection you specify the connection name and then select driver from the drop-down list. For MS SQL 2005 use MS SQL (jTDS). The URL template will apear: <b><code>jdbc:jtds:sqlserver://<host>/<database></code></b> For host type name (or IP address) of your server (example "Houston"), for database type the name of the MS SQL database (example "Northwind"). You may have something like: <b><pre>jdbc:jtds:sqlserver://Houston/Northwind</pre></b> The first name in this dialog is the name you are giving to this connection.

How does this make you feel? Add Image

I'm
e.g. indifferent, undecided, unconcerned sad, anxious, confused, frustrated happy, confident, thankful, excited kidding, amused, unsure, silly
Cancel
0

Edit

Delete

Remove

Official

KJ November 03, 2009 16:59

Gent,

You also need to know if you will be using windows authentication to log into MS SQL Server or using a localhost. You need to confirm that you have access to the database(s) you want to profile.

Check my MS SQL Connection thread for information about my travels on getting connected.

TIP: Check with a developer to see if he/she can aid you.

Comment

good answer! good answer! (undo)
- Cancel
Edit Your Reply (some HTML allowed)
What's the status of this question?

Gent, You also need to know if you will be using windows authentication to log into MS SQL Server or using a localhost. You need to confirm that you have access to the database(s) you want to profile. Check my MS SQL Connection thread for information about my travels on getting connected. TIP: Check with a developer to see if he/she can aid you.

How does this make you feel? Add Image

I'm
e.g. indifferent, undecided, unconcerned sad, anxious, confused, frustrated happy, confident, thankful, excited kidding, amused, unsure, silly
Cancel