Link to home
Start Free TrialLog in
Avatar of niv070698
niv070698

asked on

Help !!! ASP and SQLAnywhere

why i cannot get my asp code working with sqlanywhere
and with sybase i do.
also IDC/HTX and ISAPI app. does not work
I think it something to do with system DSN

the error i get is

Database Errors Occured
SQL  
Error # -2147467259
desc. -> [Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle
on SQL_HANDLE_ENV failed

please help i am desperate
Avatar of jbiswas
jbiswas

what drivers are you using with SQL Anywhere?
Avatar of niv070698

ASKER

Edited text of question
Does your ODBC connection work from other applications, eg MS Access?

:) D Perry
NIV,

I would make sure that the SQL anywhere directory (c:\sqlany50\win32 for example) is in the PATH. If not, you can experience this error.

i checked it and its in the path
by the way the prb. occurs only with sys dsn
niv,

does this happen on a server connection? if so how is the connection logging in?
i'm also running ASP with SQLAnywhere. but i get the following error:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

the connection works in VB, just refuse to work in ASP.
power walker make sure it is asystem dsn.

and please please help me with my asp.
niv,

it's a system dsn.








ASKER CERTIFIED SOLUTION
Avatar of GERSOFT
GERSOFT

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
So How Can i change it to use MS Drivers
realy thanks in advance