ASP inconsistent errors, errors changing after run with no debugging done

Hello,

I have an ASP application that generates a word documement with values
taken for a database. It worked perfectly fine on my test server.

I put it on my production server and only changed the DSN to the live
database. Ever since doing that when I run the application it works
strange. For example for one document gets generated consistently
without with only one error after 6 runs.

Another document generates errors once ever 2 - 3 runs.

To clarify
1.Error line 172
2.OK
3.Error line 174
4.OK
5.OK
6.OK
7.Error Line 1978
8.OK
9.OK
10.Error Line 1702

I did not even debug the code and I get errors on lines that the ASP
server did not complain about earlier.

Has anyone experienced this?

My database is connected via ODBC to mysql. If anyone can help me I
would really appreciate it.

Thanks in advance.

Re: ASP inconsistent errors, errors changing after run with no debugging done

"Enrique Rojas" wrote in message
news:1168180416.012435.142240@q40g2000cwq.googlegroups.com.. .
> Hello,
>
> I have an ASP application that generates a word documement with values
> taken for a database. It worked perfectly fine on my test server.
>
> I put it on my production server and only changed the DSN to the live
> database. Ever since doing that when I run the application it works
> strange. For example for one document gets generated consistently
> without with only one error after 6 runs.
>
> Another document generates errors once ever 2 - 3 runs.
>
> To clarify
> 1.Error line 172
> 2.OK
> 3.Error line 174
> 4.OK
> 5.OK
> 6.OK
> 7.Error Line 1978
> 8.OK
> 9.OK
> 10.Error Line 1702
>
> I did not even debug the code and I get errors on lines that the ASP
> server did not complain about earlier.
>
> Has anyone experienced this?
>
> My database is connected via ODBC to mysql. If anyone can help me I
> would really appreciate it.

Have you tried connecting via OLEDB?

oConn.Open "Provider=MySQLProv;" & _
"Data Source=mySQLDB;" & _
"User Id=myUsername;" & _
"Password=myPassword"
http://carlprothman.net/Default.aspx?tabid=87#OLEDBProviderF orMySQL--Roland
Hall