LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: egiesen

I am connecting to a SYBASE database and i cannot get this node to connect. it doesn't give any errors but the pin coming out is just a green 0 (When i am doing a simple select on a table with a few rows in it).

interesting i have the DBurL set to this
jdbc:jtds:sybase://qa-db.eon.dev.gblxint.com:1430/eon_docs

even if i put in
jdbc:jtds:sybase:

i get the same results. its almost like its not reading the DBURL field.

im pretty sure the driver net.sourceforge.jtds.jdbc.Driver is getting loaded correctly because when i edit that field to something incorrectly i get a driver cant be found error.

Any ideas?

thanks for the help,
Erica

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: stonysmith

The problem could very well be that your query is finding no records to return.
Start with a very simple query such as this:

select name from sysobjects where type="U"

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: egiesen

Originally posted by: stonysmith
					

The problem could very well be that your query is finding no records to return.

Start with a very simple query such as this:


select name from sysobjects where type="U"
			

ive take the query and ran it in sql developer and it returns data so the query does return data