Can't get ASE OLEDB provider to work

Hi:

I am trying to work with the oledb providers for Sybase 12 ( I have to
work with this version). I installed them and it worked just fine.
There was nothing to tell me it succeeded after the reboot through.

If I try to add a server in the Sybase OLEDB administrator it tells me
it can't find any OLE DB providers, and if I try to configure a
connection in the DSEDIT tool it gives me this error:

"Open connection to server at (172.20.13.42,5001) fails. Loaded the
Dynamic Link Library NLWNSCK.dll"

I tried editing the sql.ini different ways, using TCP, using NLWNSCK
etc, different ports as per sql.ini below, computer name, IP address. I
can connect using ODBC with the same sql.ini and information. Does
what's in the sql.ini effect whether DSEDIT works or not? Or does
DSEDIT modify the sql.ini? I am connecting through a VPN connection,
and tried turning off windows firewall to test.

Here is the sql.ini, I used what was on the server:

[SWCP_SQLSRV_BS]
master=NLWNSCK,172.20.13.42,5001
query=NLWNSCK,172.20.13.42,5001


[SWCP_SQLSRV_MS]
master=NLWNSCK,172.20.13.42,5002
query=NLWNSCK,172.20.13.42,5002


[SWCP_SQLSRV]
master=TCP,172.20.13.42,5005
query=TCP,172.20.13.42,5005


[SWCP_SQLSRV_XP]
master=NLWNSCK,172.20.13.42,5009
query=NLWNSCK,172.20.13.42,5009

Any ideas?

Kayda

.

Relevant Pages

  • Re: Sybase DB - Ende nach der 2. Abfrage
    ... > Trotzdem schaffe ich nur grob 2 Abfragen auf die DB bevor einfach nix ... > mehr geht und die Verbindung nicht mehr klappt. ... > die Sybase auf einen MSSQL klappt wunderbar beliebig oft. ... dass Dein Data Provider ein Problem mit dem Connection ...
    (de.comp.datenbanken.misc)
  • Re: connection string causes blank page
    ... > I am developing a website in ASP that connects to a Sybase database. ... nor the connection. ... Further, the Sybase ... > I have also tried using a Data Source .ids file within the connection ...
    (microsoft.public.inetserver.asp.general)
  • connection string causes blank page
    ... I am developing a website in ASP that connects to a Sybase database. ... nor the connection. ... I have also tried using a Data Source .ids file within the connection string ...
    (microsoft.public.inetserver.asp.general)
  • DBD::Sybase 1.05_1 and Perl threads
    ... connecting to Sybase IQ 12.6. ... In my Perl script, I spawn several threads, each making a single ... connection to a separate database. ... Prepare and execute SQL ...
    (perl.dbi.users)
  • Re: Database Connection Management
    ... Hopefully Sybase can provide this for you, but if not you'll need to ... >a app.lock/update count/app.unlock (then use connection if available or wait ... you could use a synchronization object known as a semaphore. ... >> for your scenario you could set n at 3 or 5 depending on the web app. ...
    (microsoft.public.dotnet.framework.aspnet)