Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Help !!! ASP and SQLAnywhere

Posted on 1998-07-22
11
Medium Priority
?
471 Views
Last Modified: 2008-02-01
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
0
Comment
Question by:niv070698
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
  • 2
  • +3
11 Comments
 
LVL 2

Expert Comment

by:jbiswas
ID: 1098416
what drivers are you using with SQL Anywhere?
0
 

Author Comment

by:niv070698
ID: 1098417
Edited text of question
0
 
LVL 3

Expert Comment

by:dapperry
ID: 1098418
Does your ODBC connection work from other applications, eg MS Access?

:) D Perry
0
Enroll in October's Free Course of the Month

Do you work with and analyze data? Enroll in October's Course of the Month for 7+ hours of SQL training, allowing you to quickly and efficiently store or retrieve data. It's free for Premium Members, Team Accounts, and Qualified Experts!

 
LVL 2

Expert Comment

by:martyn_bannister
ID: 1098419
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
 

Author Comment

by:niv070698
ID: 1098420
i checked it and its in the path
by the way the prb. occurs only with sys dsn
0
 
LVL 2

Expert Comment

by:martyn_bannister
ID: 1098421
niv,

does this happen on a server connection? if so how is the connection logging in?
0
 

Expert Comment

by:powerwalker
ID: 1098422
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
 

Author Comment

by:niv070698
ID: 1098423
power walker make sure it is asystem dsn.

and please please help me with my asp.
0
 

Expert Comment

by:powerwalker
ID: 1098424
niv,

it's a system dsn.








0
 

Accepted Solution

by:
GERSOFT earned 200 total points
ID: 1098425
you probe using ODBC drivers of SQLAnywhere and not ODBC drivers of Microsoft
0
 

Author Comment

by:niv070698
ID: 1098426
So How Can i change it to use MS Drivers
realy thanks in advance
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If something goes wrong with Exchange, your IT resources are in trouble.All Exchange server migration processes are not designed to be identical and though migrating email from on-premises Exchange mailbox to Cloud’s Office 365 is relatively simple…
Article by: evilrix
Looking for a way to avoid searching through large data sets for data that doesn't exist? A Bloom Filter might be what you need. This data structure is a probabilistic filter that allows you to avoid unnecessary searches when you know the data defin…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…
Suggested Courses

618 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question