Cant get a DB connnection URL right
Posted on 2006-06-13
I have an application which is connecting to a remote SQL SERVER database.
I originally developed the application and pointed it to my local SQL SERVER database using the following database url:
I had a user set up in SQL server called coretestuser with a password.
In sql server this user was only asssociated with one database (DTTest) so SQL sever somehow worked out which database to use.
Now I have to use a different database on 10.0.0.5 and I cant connect to it.
I cant create a test user as the account I have been given is used on several databases!
I cant seem to get the database name working at all.
I ve tried:
url = "jdbc:microsoft:sqlserver://10.0.0.5:1433;Database=DTTest";
url = "jdbc:microsoft:sqlserver://10.0.0.5:1433/DTTest";
Neither is working I just get "Unable to connect. Invalid URL"
Am i missing something really obvious??