nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to connect to SQL Server 2005

mstaniloiu

I am having trouble writing the URL for a SQL Server 2005 database when creating a data source for a BIRT report. The URL I have written looks like this: 
 
<pre class='_prettyXprint _lang-auto _linenums:0'>jdbc:microsoft:sqlserver://host:port;databasename=name;user=userName;password=yourPwd</pre>
 
I placed the sqljdbc.jar (jdbc 3.0) in the following location: 
 
<pre class='_prettyXprint _lang-auto _linenums:0'>eclipse/plugins/org.eclipse.birt.report.data.oda.jdbc_2.6.1.v20100909/drivers</pre>
 
When I press the "Test Connection" button in the "Edit Data Source" dialog I get the following error: 
 
<pre class='_prettyXprint _lang-auto _linenums:0'>The selected driver cannot parse the given url.</pre>
 
Can you give me any hints on how to solve this?

Find more posts tagged with

Comments

mwilliams

Are you sure you've got the correct URL for your driver?