Problem:-

My Proeblem is i am developing reports in Crystal Report, having
Syabas ASE 12 @ back end.

when i make a report in crystal report it works fine
but when i use this report in vb it gives me the following error
---------------------------------------------------------------
login failed.
Details:HY000:[SYBASE][ODBC Sybase driver][Sybase]ct_connect();
protocol specific layer:external error: The attempt tp connect
to the server failed.

---------------------------------------------------------------
Note 1:- in crystal reports i m using "ODBC (RDO)"

NOTE 2: - I donot have permisinos to have Database Password I only
have the user id and Password.

NOTE 3: - I am new to VB Envoirenment,so it would be nice if u deal
with me like a new user to vb.

At my cleint side the connnection is in "System DSN" and it is "Sybas
ASE odbc Driver"

-------------------------------------------------
Data Source Name ICCM_PREVIEW_DSN
ServerName ICCM_PREVIEW
Database Name blue

Userid uid
password passwd

Database blue

--------------------------------------------
--------------------------------------------
in sql.ini file
---------------
[ICCM_PREVIEW]
$BASE$01=NLNWLINK,ICCM_Server
$BASE$00=NLWNSCK,10.152.0.68,5000
query=$BASE$00;$BASE$01;
---------------------------------------------
---------------------------------------------

Hello,

If you open a DOS command prompt, can you connect
with the "isql" utility? Example:
c:\sybase\ocs-12_5\bin\isql -Usa -P -Syour_ase_here

If you get the same ct_connect() error, I think you might
need to run the "ocscfg.exe" utility and specify the
network driver.
c:\sybase\ocs-12_5\bin\ocscfg

(as long as you are running this utility, make sure that
your SYBASE and SYBASE_OCS environment variables are set
correctly).

If ISQL works but you still get an error with oledb, there
may be some other configuration issue with oledb we need
to look at.

Hi Neal!

there is no network problem as other applications using the same
database are working fine, even i m capable of runnuing my reports on
network really fine, report collects the data from server's database.

so the network is fine.

there is something else wrong.

what i beleive is the error is given by crystal report of
"loginfailure", (when it is combined with vb), so it seems that ther
is some restriction in sybase that few pre-specifed application get
access 2 it only.

is it so?

Hello,

The older Sybase ODBC Drivers (before the Sybase 12.5 release)
relied on Open Client being installed and configured correctly.
Since you are able to connect with ISQL and other client applications
it sounds like Open Client is configured correctly.

I'm not sure what you mean by "report". Probably a Crystal Reports
"report"?

I don't have a copy of Crystal Reports so I am not sure what
you do differently to run the report from within C.R. versus
calling the report from VB.

I assume you are able to do a "test connect" from within the ODBC
administrator?

If that fails, compare the ODBC entry to that of the sql.ini file (if
using 12.0's ODBC).
Just make sure the ODBC entry for the Server name matches up with the
entry in the sql.ini.

If that works can you make even a simple connection to the database
from within a VB application?
Are you using some kind of connection string in your VB program that
uses different username,
password, etc. than what you have configured in the ODBC Driver
itself?

One final thing would be to make sure you run the sycsp11.sql script
against his ASE.
There were problems with Crystal Reports if you hadn't run that
script.
Look in your %SYBASE%\%SYBASE_ASE%\scripts directory for
"syscsp11.sql".
isql -Usa -P -Syour_ASE_here -i syscsp11.sql

If none of this helps, you could try posting your question to this
newsgroup. More Sybase ODBC experts tend to use it:
news://forums.sybase.com:119/sybase....nectivity.odbc

Good luck!