Connecting to SQL database
Hi all, I've got an SQL database that needs to be accessed from my Java code. I have created an ODBC data source that can be used to connect to the database, but I'd rather not use it.
Is there some way to set the URL for the connection such that it can access the database required? At this stage there is an ODBC called SHRLAB that is used in the connection as:
DriverManager.getConnection ("jdbc:odbc:SHRLAB", dbUserName, dbPassword);
I am looking for a way to do this without creating an ODBC data source.
Thanks in advance.
HD