- Apps and Add-ons
- :
- All Apps and Add-ons
- :
- Why is DBConnect for Sybase giving the following e...
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark Topic
- Subscribe to Topic
- Mute Topic
- Printer Friendly Page
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hello Everyone
I am setting up database monitoring using DBconnect, it worked well for MSSQL, Oracle, DB2 however Sybase is not giving up. I am getting the following error:
Connect error: no protocol: :myip:myport/databasename
In drivers section, it got recognised correctly as version 7.0. Any ideas on the issue? I am able to telnet to the host:port so no network issues there.
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Are you using DB Connect 3.1.3 version?
If yes, please try with 3.1.2.
I have had several issues with different DBs with the latest version.
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try this - jdbc:jtds:sybase://hostname:port/database
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Are you using DB Connect 3.1.3 version?
If yes, please try with 3.1.2.
I have had several issues with different DBs with the latest version.
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Now the question, how do you get an older version, cannot seem to find a repo for that. Its either 2.4.1 or 3.1.3 on the splunkbase.
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Not available if you don't have a backup. Write me an email, I'll answer with a private link. andrea.corvini@gmail.com
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you for the package. Now getting a new error:
"JZ00L: Login failed. Examine the SQLWarnings chained to this exception for the reason(s).". I have checked the changes between DBconnect 3.1.3 and 3.1.2, it is stated that there are no changes but it does give different error 🙂 Anyway, are there any specific JVM parameters for Sybase or anything? Or extra jars?
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
See here:
https://community.oracle.com/thread/698380
Which version of jdk are you using?
See here:
https://www.genuitec.com/forums/topic/i-cannot-connect-to-sybase-db-browser/
This is an old version but anoter possible issue.
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Using JRE 1.8, with jdbc version 4.
Perfection! It works, connection string was incorrect, I think it should be a part of setup in official documentation.
So resolution for the problem:
1. downgrade the DBconnect to 3.1.2 as 3.1.3 was causing some issue with protocol identification.
2. Modify connection URL towards sybase to specify charset.
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Yup, I am running 3.1.3. I will give it a try later today if no one comes with a better option.
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
How does your jdbc url look like? Is protocol mentioned in there (tds for Sybase, I assume).
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
jdbc:sybase:Tds:ip:port/dbname
Introducing the 2024 SplunkTrust!
Introducing the 2024 Splunk MVPs!
Splunk Custom Visualizations App End of Life
