CCMS ASE Driver Version

[Jim257]

So you've previously been able to connect to the Symposium database from another machine?

Also have you ever installed these drivers before? Because installing the drivers is a tricky business.

Cheers,

Jim.

 

[ph74]

Yes, this used to work with the original drivers.
The new drivers are installed and the ODBC test connection works, but can't connect to query db?

Paul

 

[Jim257]

What error message do you get? I remember last time I did this that I could connect but wasn't able to query the DB.

I read the below post about 1,000 times before I finally managed to connect to the DB.

http://www.tek-tips.com/viewthread.cfm?qid=1263747

Also I hate to start at the beginning, but you're querying the Blue database correct?

Cheers,

Jim.

 

[ph74]

Yes, connecting to the Blue database. I am using Excel but have tried Access with the same error message --
Stored procedure 'sp_odbc_tables' not found.

Also with version 15.5 of the odbc drivers there doesn't appear to be anywhere to reference the Interfaces File as with older version of the driver?

Thanks.
Paul

 

[Jim257]

I'd say it is very worth you reading through this post:

http://newsgroupstats.info/article/...0-186-does-not-work-with-Crystal-Reports.html

This might also help:

http://groups.google.com/group/sybase.public.ase.nt/browse_thread/thread/8fee43abd5546952?pli=1

Obviously don't run\install anything unless you're certain it will resolve your issue.

Also have you tried connecting with an SQL Query tool, such as Database Browser?

http://www.dbsoftlab.com/database-editors/database-browser/overview.html

Cheers,

Jim.

 

[ph74]

Thanks Jim.
The Database Browser does not work. It shows as connected but with an error?
The post is useful, however I am in similar position and can not install any new stored procedures onto the DB server?
Looks like this is a brick wall now!!

Thanks .
Paul

 

[Jim257]

Yep, it's unfortunate. Could you perhaps get in touch with the vendor of your Symposium database and see if they know anything about it?

It does look like the only way to get this running is to install the updated stored procedures or go back to using the old drivers.

Cheers,

Jim.