How to connect Sybase ASE

cxg417 · Post by **cxg417** » Thu 10 Sep 2009 02:14

I downloaded and tried UniDAC3.0 Trial Version,
when connecte Sybase ASE , Provider = ASE; Server = IP Address; Port = 5000, click the Connect button,
Prompt the following error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified.

BTW:
When the TUniQuery the Readonly property is True, RefreshRecord is invalid
________
Easy vape

Plash · Post by **Plash** » Thu 10 Sep 2009 07:52

You should install ASE client software (including the ODBC driver) to use ASE provider.

We could not reproduce the problem with RefreshRecord. Please describe the steps required to reproduce the problem.

cxg417 · Post by **cxg417** » Thu 10 Sep 2009 09:14

I Sure install ASE client software (including the ODBC driver) to use ASE provider

And use ODBC Provider connection is successful
________
Glass pipe pictures

Plash · Post by **Plash** » Thu 10 Sep 2009 10:42

ASE provider uses ODBC driver named 'Adaptive Server Enterprise'. Please specify what driver name you are using when connecting through ODBC provider.

cxg417 · Post by **cxg417** » Fri 11 Sep 2009 01:14

I uses ODBC driver named 'Sybase ASE ODBC Drive' when connecting through ODBC provider.

And I not found ODBC driver named 'Adaptive Server Enterprise' In ODBC
DataSource Manager

Thanks
________
CALIFORNIA DISPENSARIES

Plash · Post by **Plash** » Mon 14 Sep 2009 11:40

We have fixed the problem. Now ASE provider can use both ODBC drivers.

Please contact us by e-mail support*devart*com. We'll send you a fix for testing. Specify your Delphi version and license number (if you have a registered version of UniDAC).

cxg417 · Post by **cxg417** » Wed 16 Sep 2009 01:14

I have received UniDAC fixed version

connecte Sybase ASE , Provider = ASE; Server = IP Address; Port = 5000, click the Connect button,

Prompt the following error: [DataDirect][ODBC Sybase write Protocol driver] insufficient information to connect to the data source.

thanks
________
Cheap vaporizers

cxg417 · Post by **cxg417** » Wed 16 Sep 2009 06:36

Now, I connected Sybase with through ODBC.

For Example
UniQuery1.Edit;
UinQuery1.FieldByName('DT').AsDateTime:=Now;
UniQuery1.ApplyUpdate;
UniQuery1.CommitUpdate;

Prompt the following error:
[DataDirect][ODBC Sybase Wire Protocol driver]Timestamp parameters with zero scale must have a precision of 13, 16, or 19. Parameter number: 1, precision: 0.
________
Detroit Assembly

Plash · Post by **Plash** » Wed 16 Sep 2009 12:39

Please create a File DSN for your connection using ODBC Administrator and send us the created file. We need this file to know the property names used by ASE ODBC Driver.

cxg417 · Post by **cxg417** » Thu 17 Sep 2009 02:07

File DSN

[ODBC]
DRIVER=Sybase ASE ODBC Driver
UID=sa
DB=master
NA=192.168.1.126,5000
________
Mexico city hotel

cxg417 · Post by **cxg417** » Mon 21 Sep 2009 23:36

Why not answer the problem?
________
DRUG TESTING

Plash · Post by **Plash** » Fri 25 Sep 2009 11:23

We have fixed the problems with ASE. I have sent the fixed version to your e-mail.