Page 1 of 1
How to connect Sybase ASE
Posted: Thu 10 Sep 2009 02:14
by cxg417
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
Posted: Thu 10 Sep 2009 07:52
by Plash
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.
Posted: Thu 10 Sep 2009 09:14
by cxg417
I Sure install ASE client software (including the ODBC driver) to use ASE provider
And use ODBC Provider connection is successful
________
Glass pipe pictures
Posted: Thu 10 Sep 2009 10:42
by Plash
ASE provider uses ODBC driver named 'Adaptive Server Enterprise'. Please specify what driver name you are using when connecting through ODBC provider.
Posted: Fri 11 Sep 2009 01:14
by cxg417
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
Posted: Mon 14 Sep 2009 11:40
by Plash
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).
Posted: Wed 16 Sep 2009 01:14
by cxg417
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
Posted: Wed 16 Sep 2009 06:36
by cxg417
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
Posted: Wed 16 Sep 2009 12:39
by Plash
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.
Posted: Thu 17 Sep 2009 02:07
by cxg417
File DSN
[ODBC]
DRIVER=Sybase ASE ODBC Driver
UID=sa
DB=master
NA=192.168.1.126,5000
________
Mexico city hotel
Posted: Mon 21 Sep 2009 23:36
by cxg417
Why not answer the problem?
________
DRUG TESTING
Posted: Fri 25 Sep 2009 11:23
by Plash
We have fixed the problems with ASE. I have sent the fixed version to your e-mail.