ASP VB, MYSQL and ODBC error ASP 0115

Status
Not open for further replies.
M

matt-dublin

New Member
Hey guys,

I'm trying to do a Select sum(columname) as newname in asp.vb/mysql and it pops back with this error on my provider:



Active Server Pageserror 'ASP 0115'
Unexpected error
/foler/folder/filename.asp A trappable error (C0000005) occurred in an external object. The script cannot continue running.

It works fine on my own machine, here are the differences:

My machine:
windows vista ultimate
Mysql Ver 5.0.41
ODBC Driver Ver : 5.0 beta
IIS Ver: 7

My Provider:
windows 2003 server
MySQL ver: 5.0.45
ODBC ver: 3.51
IIS ver: 6

Exactly what i'm trying to do is get it to pull in the total value in that column so that i can populate another column in another table with its result if you know what i mean.

it works fine on my machine, but not here.

anyone got any ideas?

thanks
 
M

matt-dublin

New Member
@davidbeehan : yeah i have, but no information i found is relative to my error.

@louie, yeah the connection is fine, i have tested it now using my own odbc driver pointing at my hosting providers mysql server, and it worked fine, so i have come to the conclusion that its an issue with the odbc driver on my hosts server.
(i'm using mysql odbc 5 as 3.51 wouldn't work with vista.)

im trying to get them to resolve as we speak
 
M

matt-dublin

New Member
just to let you know i got it fixed,

it was the odbc driver (3.51.04)

they upgraded to 3.51.19 and the problem was resolved.
 
Status
Not open for further replies.
Top