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
niv070698Asked:
Who is Participating?
 
GERSOFTConnect With a Mentor Commented:
you probe using ODBC drivers of SQLAnywhere and not ODBC drivers of Microsoft
0
 
jbiswasCommented:
what drivers are you using with SQL Anywhere?
0
 
niv070698Author Commented:
Edited text of question
0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
dapperryCommented:
Does your ODBC connection work from other applications, eg MS Access?

:) D Perry
0
 
martyn_bannisterCommented:
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.

0
 
niv070698Author Commented:
i checked it and its in the path
by the way the prb. occurs only with sys dsn
0
 
martyn_bannisterCommented:
niv,

does this happen on a server connection? if so how is the connection logging in?
0
 
powerwalkerCommented:
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.
0
 
niv070698Author Commented:
power walker make sure it is asystem dsn.

and please please help me with my asp.
0
 
powerwalkerCommented:
niv,

it's a system dsn.








0
 
niv070698Author Commented:
So How Can i change it to use MS Drivers
realy thanks in advance
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.