ODBC error: external error, while testing an ODBC connection to an ASE server
"The connection failed because of invalid or missing external configuration data."
Does this have to do with the configuration of OCS-12_0 or the ocscfg.exe? Running ocscfg.exe, I've set the "SYBASE:" directory to "C:\sybase" but it doesn't seem to like it when I set the "Sybase_OCS:" to "C:\sybase\OCS-12_0". I don't know if this is related.
Another idea - on the install I chose "No" to updating the msvcrt.dll (the MS C Runtime) because I've seen that hose a system before. Is this file safe to overwrite and ca...PB : Connection error #4002 with VB6, Crystal Report 11 and ASE 15 (ODBC)
I have an error #4002 when I want to view a report in Visual Basic 6
ActiveX Chrystal Report Viewer.
The reports works in Crystal Report but the conexion fails with VB6.
I think it could be an authentification error but I don't know how to
manage identification from VB.
The problem appears when I use the Crystal Wizard to create a form
automatically AND when I create objects directly in code :
Dim app As CRAXDRT.Application
Dim oReport1 As CRAXDRT.Report
Dim oRptRouter As CrystalActiveXReportViewerLib11.ReportSourceRouter
Dim viewReport As CrystalActiveXR...Dump/Load (from ASE 12.5.4 to ASE 15.x) - VS.
We are in the process of planning the upgrade of our ASE
12.5.4 dataservers to ASE 15.x. What is the most
recommended way to upgrade ASE dataservers from ASE 12.5.4
to ASE 15.x?
1) Install new instances of ASE 15.x and load database
dumps from our ASE 12.5.4 dataservers to the newly installed
ASE 15.x dataservers.
- OR -
2) Use the ASE upgrade utility (sqlupgrade) to upgrade our
existing ASE 12.5.4 dataservers to ASE 15.x.
What are the Pros vs. Cons for loading a 12.5.4 database
into a 15.x ASE dataserver versus performing an ASE
dataserv...HELP: Microsoft Query "General odbc error" connecting to ASE 15.0.3
I'm trying to connect
MSQRY32 - 12.0.6532 SP2 MSO to
ASE15.0.3ESD#1 (8K pages) using
ODBC on XP SP3, using
ASE 15.00.00.325 2008/08/14 ODBC driver
The System ODBC connection was created with defaults.
Checking ASE, I can see
successful login connection
The I get an error on MSQRY32 - "General odbc error"
Any idea how to fix this?
Thanks in Advance.
> I'm trying to connect
> MSQRY32 - 12.0.6532 SP2 MSO to
> A...ASE 15 connection error
I'm using PB 10.5 with ASE15 (PBSYC105.DLL), OPEN client ASE15, direct
connect, NO ODBC, no OLEDB, only dll pbsyc105.dll.
If my application stand-by (example: reduced as icon), after 2 or 3 minutes
if I close the window, or retrive
data or other database operations, appears an error "Select Error:
ct_cmd_alloc(): user api layer: external error: The connection has been
Same others application on PB9 with ASE 12 works fine.
Will I, perhaps, configure some timeout on ASE15 ?
...ASE and ASE
Could it be possible to take scripts from ASA and load them in an ASE
Any information is welcome
ASA supports a fairly large sub-set of Transact-SQL, so if you write your
stored procedures and triggers in ASA using T-SQL, you should be able to
create scripts that will run against both ASE and ASA. If you're planning
to do this though, I would suggest developing your database schema against
ASA, since everything you write in T-SQL in ASA will be supported on ASE,
but the reverse is not true.
Check out the section in the ASA documentation entitled "Tra...ASE to ASE
Is anyone out there doing ASE to ASE replication using SQL remote? If
you are have created your own version of the SSEXTRACT utility to set up
a replicant database in ASE rather than ASA? Or does anyone know if
SYBASE has created a version SSEXTRACT for use with ASE to ASE
Thanks in advance
I thought the SQL Remote Replication support in ASE11.5 was meant for a
consolidate-database only (by design)! At least that was what Sybase
said when they announced support for SQL Remote technology support in
I will be happy to...ASE ODBC Driver 15.x backward compatible with ASE 12.5.x
Can anyone point me to a statement by Sybase that ASE ODBC Driver 15 will
work with ASE 12.5.x databases? I'm under the impression that it is backward
compatible but I will need to install the 15.x cataloging stored procedures
in the 12.5.x servers to allow MS Access / Excel / Query type users to work.
--- Quote of the Minute ---
Dilbert's Words of Wisdom: Tell me what you need, and I'll tell you how to
get along without it.
Scott Kellish, Owner
SoftSystem Solutions, LLC.
18 Ridge Road...Loading ASE 15 beta2 --> ASE 15 fails
Having issues loading a dump from ASE 15 beta2 into ASE 15.
Beta license expired so installed new copy of ASE 15 and the
dumps from beta2 do not load.
Have tried doing remote load into ASE 15 using beta2 backup
server. Issues here because dumps done with level 4
1> load database dbadmin from
Backup Server: 188.8.131.52: Remote DUMP/LOAD is not allowed
when interfacing to a stripe for device
30 10:5...When using MS-ADO to connect to ASE using ASE OLEDB/ODBC driver the record count is -1
VB 6 application connecting to ASE 12.5 (NT) using OLEDB/ODBC drivers. Gets
He retrieve rows from the database - WORKS Fine!!!
But as soon as he wants to see how many rows was returned the recordcount
He gets this problem connecting using ODBC and OLEDB.
He gets the recordcount from the recordset object's recordcount property.
This is what I found on the MSDN online manuals:
RecordCount Property - ADO
Indicates the current number of records in a Recordset object.
Use the RecordCount property to find out how many r...ASA To ASE - VS
What are the differents in terms of configuring SQL Remote Between ASA to
ASE and ASE To ASE ?
You should start with the Help file and then ask specific questions:
Data Replication with SQL Remote
PART 5. Appendix
APPENDIX A. Enterprise and Anywhere: Differences
There are many differences, so begin there.
Please only post to the newsgroup
BH Ong <firstname.lastname@example.org> wrote in message
> What are the differents in terms of configuring SQL Remote Between ASA to
> ASE and ASE To ASE ...Internal Error when connecting to ASE 15.5 with "Encrypt Password" on
Just installed Sybase ASE 15.5 demo on Windows with all
Then connection via ODBC fails if the "Encrypt Password" is
on. Is that expected?
There is a bug logged with Sybase on similar issue.
Could you post the exact ASE version and ASE ODBC Driver version?
This is currently being looked at and we are awaiting the results, such as
how to resolve this issue.
<Martin Rakhmanov> wrote in message
> Just installed Sybase ASE 15.5 demo on Windows with all
> Then...Can't connect to ASE 15.0 because of Open Client errors
I am trying to connect to an ASE 15.0 server from my Windows Vista x64
machine and not succeeding. It seems every method I try fails (except JDBC
which is working) with errors relating to Open Client. When I try to
connect using DSEDIT it comes up with an "Unable to determine Net-Library
error" even though the server is up and I have defined all the necessary
environment variables. When I try to connect through PowerBuilder 10.5 I
get "Error loading client library DLLs".
What could be wrong? Is it that Open Client doesn't work on 64-bit systems?
And...Are there any common errors / issues related to using the dump/load strategy vs. sqlupgrade utility for upgrade/migration to ASE 15.x (from ASE 12.5.x)?
Are there any common errors / issues related to using the
dump/load strategy vs. sqlupgrade utility for
upgrade/migration to ASE 15.x (from ASE 12.5.x)?
I've been reading posts on this discussion thread to try to
see if I can find any disadvantage of using the dump/load
strategy vs. using the sqlupgrade utility (i.e. common
errors / issues).
I noticed that some have run into errors after the
upgrade/migration when using system stored procedure(s). So
this sparked a few questions...
1) Is one upgrade/migration strategy prone to more errors
and issues than ...