CARDEXCHANGE® COMMUNITY

Connecting native to SYBASE

6 years 11 months ago
Mark Vinkx
Senior Boarder
Senior Boarder
Posts: 52
More
Topic Author
Connecting native to SYBASE #6075
In need the "quotable names" otherwise it doesn't work at all

The loginID is numeric

Column_name Type Length Prec Scale Nulls Not_compressed Default_name Rule_name Access_Rule_name Computed_Column_object Identity


----







loginID numeric 8 16 0 0 0 NULL NULL NULL NULL 0
naam varchar 50 NULL NULL 1 0 NULL NULL NULL NULL 0
voornaam varchar 50 NULL NULL 1 0 NULL NULL NULL NULL 0
roepnaam varchar 50 NULL NULL 1 0 NULL NULL NULL NULL 0
loginnaam varchar 50 NULL NULL 0 0 NULL NULL NULL NULL 0
geboortedatum datetime 8 NULL NULL 1 0 NULL NULL NULL NULL 0
personeelsnummer varchar 50 NULL NULL 1 0 NULL NULL NULL NULL 0
externID varchar 200 NULL NULL 1 0 NULL NULL NULL NULL 0
6 years 11 months ago
Rutger Koperdraad
Platinum Boarder
Platinum Boarder
Posts: 1566
More
Connecting native to SYBASE #6074
Hi Mark,

Is the LoginID column of the type VARCHAR or NUMERIC? One thing you could try is to remove the quotes from the query by going into the Advanced options (Configuration menu) and unselect "Quote table and column names". Maybe the database for some reason starts interpreting "LoginID" as a string instead of a column name.

regards,
Rutger.

Rutger Koperdraad
Senior Software Engineer

"A reasonable man adapts himself to the world. The unreasonable man persists in trying to adapt the world to himself. All progress, therefore, depends on the unreasonable man." (Bernard Shaw)
6 years 11 months ago
Mark Vinkx
Senior Boarder
Senior Boarder
Posts: 52
More
Topic Author
Connecting native to SYBASE #6072
If I start cardexchange at first everything is working. But then after a while, usaualy after a period of inactivity, I start getting errors when clicking on a record
The error is Implicit conversion from datatype 'VARCHAR' to 'NUMERIC' is not allowed. Use the CONVERT function to run this query.
See the extract from the dataexchange log

SELECT *
FROM "dbo"."MVItest"
WHERE "loginID" = ?
? = 260000021684

-- isor:
SELECT *
FROM "dbo"."MVItest"
WHERE "loginID" = ?
? = 10864

-- isor:
SELECT *
FROM "dbo"."MVItest"
WHERE "loginID" = ?
? = 140000005260

-- isor:
SELECT *
FROM "dbo"."MVItest"
WHERE "loginID" = ?
? = 10860

-- isor:
SELECT *
FROM "dbo"."MVItest"
WHERE "loginID" = ?
? = 10864

-- An error occurred in Adaptive Server Enterprise:
ERROR [42000] [Sybase][ODBC Driver][Adaptive Server Enterprise]Implicit conversion from datatype 'VARCHAR' to 'NUMERIC' is not allowed. Use the CONVERT function to run this query.


-- isor:
SELECT *
FROM "dbo"."MVItest"
WHERE "loginID" = ?
? = 12658

-- An error occurred in Adaptive Server Enterprise:
ERROR [42000] [Sybase][ODBC Driver][Adaptive Server Enterprise]Implicit conversion from datatype 'VARCHAR' to 'NUMERIC' is not allowed. Use the CONVERT function to run this query.
6 years 11 months ago
Rutger Koperdraad
Platinum Boarder
Platinum Boarder
Posts: 1566
More
Connecting native to SYBASE #6070
Hi Mark,

No, it is not as simple as that, unfortunately. It would require development from our site, but there are no plans to support Sybase in the near future. What problems are you experiencing with ODBC?

regards,
Rutger.

Rutger Koperdraad
Senior Software Engineer

"A reasonable man adapts himself to the world. The unreasonable man persists in trying to adapt the world to himself. All progress, therefore, depends on the unreasonable man." (Bernard Shaw)
6 years 11 months ago
Mark Vinkx
Senior Boarder
Senior Boarder
Posts: 52
More
Topic Author
Connecting native to SYBASE #6069
Hi

I want to connect to a SYBASE database. I see it is currently not supported. Can I make it work with dropping the right sybase ADO dll in the cardexchange installation directory and setting some other configuration parameters or would it require coding ?

The reason I ask is that I now user ODBC with limited succes

Sign In to Post

Welcome back! Login to your account and get access to the CardExchange® Community and start posting today.

Please read our community rules!

Account Registration

Please fill in the fields below and become a member of our CardExchange® Community today!

Please enter the name!
Please provide an username!
Please provide a valid e-mail!
Retype the e-mail!
Please enter a password!
Retype the password!
Invalid Input
After you submit your registration you will receive an email with information about your account

US business only within scope

ISO/IEC 27001:2013 

United States

201 Sand Creek Rd, Suite L-E
Brentwood, CA 94513

Monday – Friday
9am – 5pm (EST)
+1 (925) 529 4999

Netherlands

Smallepad 32
3811 MG Amersfoort

Monday – Friday
9am – 5pm (CET)
+31 (0)20 2251 447

© 2022 CardExchange, Inc.