ASP inconsistent errors, errors changing after run with no debugging done -- inetserver asp db

Enrique Rojas
1/7/2007 6:33:36 AM

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.

Roland Hall
1/11/2007 11:48:48 PM

[quoted text, click to view]

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#OLEDBProviderForMySQL--Roland
Hall

inetserver asp db : ASP inconsistent errors, errors changing after run with no debugging done