No Kaustubh No Fun, Know Kaustubh Know Fun..
David O'Meara wrote:the URL is jdbc:microsoft:sqlserver://host:port not com:etc
the JDBC URL is just a string that gets passed to the driver to say "Do you support this?" and if the Driver doesn't understand the string it says 'No!' otherwise it uses the information to create a database connection.
No Kaustubh No Fun, Know Kaustubh Know Fun..
Did you get an error message?Kaustubh G Sharma wrote:...The below is also not working ...
OCUP UML fundamental and ITIL foundation
OCUP UML fundamental and ITIL foundation
Jan Cumps wrote:
Did you get an error message?Kaustubh G Sharma wrote:...The below is also not working ...
No Kaustubh No Fun, Know Kaustubh Know Fun..
David O'Meara wrote:second rule of JDBC URLs: copy them from somewhere and update with your data. DO NOT write them by hand.
Go here: http://www.petefreitag.com/articles/jdbc_urls/
Copy the JDBC URL that you need and then insert your settings.
Then you'll see where you went wrong.
No Kaustubh No Fun, Know Kaustubh Know Fun..
No Kaustubh No Fun, Know Kaustubh Know Fun..
No Kaustubh No Fun, Know Kaustubh Know Fun..
David O'Meara wrote:"Looking right" obviously isn't right.
I'm asking you to d the same thing I'd do myself to resolve the issue
1) Copy the JDBC URL from that page
2) replace the server, port and database name with your own
3) remove unused data such as username/password
4) compare the pair.
No Kaustubh No Fun, Know Kaustubh Know Fun..
David O'Meara wrote:the code you pasted is not correct. Also, build the JDBC URL in one place, don't add the database later.
What JDBC URL are you using?
No Kaustubh No Fun, Know Kaustubh Know Fun..
David O'Meara wrote:I'm asking about this line where the database is added afterwards.
And have a look at the URL I built above, you didn't follow the steps.
No Kaustubh No Fun, Know Kaustubh Know Fun..
Kaustubh G Sharma wrote:...
Sorry previously I am not getting it correctly but here also every info is coming fine... Even though there's nothing wrong with the drivers ...
OCUP UML fundamental and ITIL foundation
Jan Cumps wrote:
Kaustubh G Sharma wrote:...
Sorry previously I am not getting it correctly but here also every info is coming fine... Even though there's nothing wrong with the drivers ...
Not everything is fine:
Your url:
jdbc:microsoft:sqlserver://192.168.10.110:1433/mcard10
url definition for sql server (from David's url http://www.petefreitag.com/articles/jdbc_urls/ ) :
jdbc:microsoft:sqlserver://host:port;databasename=name
No Kaustubh No Fun, Know Kaustubh Know Fun..
No Kaustubh No Fun, Know Kaustubh Know Fun..
No Kaustubh No Fun, Know Kaustubh Know Fun..
No Kaustubh No Fun, Know Kaustubh Know Fun..
Kaustubh G Sharma wrote:MICROSOFT SUPPORT SAYS:::::
Set your system CLASSPATH variable to include the following entries:
\Your installation path\Lib\Msbase.jar
\Your installation path\Lib\Msutil.jar
\Your installation path\Lib\Mssqlserver.jar
This is an example of a configured CLASSPATH variable:
CLASSPATH=.;c:\program files\Microsoft SQL Server 2000 Driver for JDBC\lib\msbase.jar;c:\program files\Microsoft SQL Server 2000 Driver for JDBC\lib\msutil.jar;c:\program files\Microsoft SQL Server 2000 Driver for JDBC\lib\mssqlserver.jar
But I am not able to find such directories where I can put these jar files...I have a MY SQLSERVER path in C driver Program Files Folder but I am not able to get the mentioned path in it...
and as mentioned in it I also paste the driver in C:\Temp folder but this is also not working...
http://support.microsoft.com/kb/313100
http://msdn.microsoft.com/en-us/library/ms378526.aspx
Kaustubh G Sharma wrote:
OCUP UML fundamental and ITIL foundation