On May 4, 10:06 am, Matthew Woodward <[email protected]> wrote:
> twigboy2 wrote:
> > Thanks again. I am trying to connect to SQL Server and Oracle
> > databases, but for now I need SQL Server connections. I did want to
> > use JDBC but even that was not working. I downloaded the files (to
> > try) because the connections were not being made.
>
> We'd need more information to try and help with what's going on here.
> What version of SQL Server? Which driver are you using? What error
> message do you get? Are you sure the database server is accessible over
> JDBC? Are you sure you have the port number correct? Are you sure the
> SQL Server in question is set to the right type of authentication?
>
SQL Server 2005. Driver included in the distribution and also tried
version downloaded from MS (same, right?). Setting up using choice
"Microsoft SQL Server 2005 (Microsoft)". Message: "Could not register
database driver com.microsoft.sqlserver.jdbc.SQLServerDriver. Please
make sure this driver is in your classpath." I gain connection to
database on a Windows setup using the same parameters and credentials
(SQL Server authentication).
> > I am using the OpenBD console. What do I select to create the
> > connection? "Microsoft SQL Server (jTDS)"? "Microsoft SQL Server
> > 2005 (Microsoft)"? "Other JDBC Driver"?
>
> If it's SQL 2005 you can use either SQL Server driver. If it's SQL 2000
> you MUST use the jTDS driver. You do not have to use the "other" driver.
> --
> Matt Woodward
> [email protected]http://www.mattwoodward.com/blog
>
> Please do not send me proprietary file formats such as Word, PowerPoint,
> etc. as attachments.http://www.gnu.org/philosophy/no-word-attachments.html
>
> smime.p7s
> 4KViewDownload
--~--~---------~--~----~------------~-------~--~----~
Open BlueDragon Public Mailing List
http://groups.google.com/group/openbd?hl=en
official site @ http://www.openbluedragon.org/
!! save a network - trim replies before posting !!
-~----------~----~----~----~------~----~------~--~---
