[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 472
  • Last Modified:

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
0
niv070698
Asked:
niv070698
  • 4
  • 2
  • 2
  • +3
1 Solution
 
jbiswasCommented:
what drivers are you using with SQL Anywhere?
0
 
niv070698Author Commented:
Edited text of question
0
 
dapperryCommented:
Does your ODBC connection work from other applications, eg MS Access?

:) D Perry
0
Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

 
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
 
GERSOFTCommented:
you probe using ODBC drivers of SQLAnywhere and not ODBC drivers of Microsoft
0
 
niv070698Author Commented:
So How Can i change it to use MS Drivers
realy thanks in advance
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 4
  • 2
  • 2
  • +3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now