- Features by Edition
- Latest Features
- Licensing/Activation
- Installation
- Getting Started
- Data Sources
- Deployment/Publishing
- Server Topics
- Integration Topics
- Scaling/Performance
- Reference
- Specifications
- Video Tutorials and Reference
- Featured Videos
- Demos and screenshots
- Online Error Report
- Support
- Legal-Small Print
- Why Omniscope?
|
||||||
MS SQL Server JDBCConnecting to MS SQL Server Direct connectons to Microsoft Sequel Server databasesThe Omniscope Database Connection dialog accessible under File > Connect to database guides you through the connection parameters. Connecting to Microsoft SQL Server 2008As with SQL Server 2005, the same configuration applies. You will need to have downloaded and installed the latest Microsoft SQL Server JDBC Driver. The same connection settings for SQL Server 2005 apply. The Driver jar path is different however, you must enter: Use "Connect to database" as usual, specifying a username and password, choosing a table, and optionally customising the SQL query. Connecting to Microsoft SQL Server 2005As with SQL Server 2000, your database server must be configured to use mixed mode authentication. The server must also have the TCP/IP network protocol enabled. You will need to have downloaded and installed the Microsoft SQL Server JDBC Driver. Do not use the "sa" administrative login; instead create a dedicated user for the database(s) you need to connect to. Open the Omniscope Database Connection dialog under File > Connect to database. Choose the generic "JDBC" option on the first page.
Connecting to Microsoft SQL Server 2000There is a specific option for SQL Server 2000. You will need to know the database server details (host name and port) and login details (username and password). At present, due to limitations in the Microsoft JDBC driver, your database must be configured to use Mixed Authentication and not Trusted/Windows Authentication (see here for more information). Frequently Asked QuestionsQ: I am getting an error establishing socket when using JDBC?A: Try the following known solutions:
|