FMS7 Advanced - Query through ODBC keeps crashing

[IMIC]

Okay, I've been through the nightmare of getting the SequeLink 5.4 ODBC driver to pass the "Test Connect" but now I am still having problems.

I have my database open with all the ODBC/JDBC file sharing options enabled. I've installed the ODBC driver on a test server. I use an ASP page to query the database that has code like this:

Set rs = Server.CreateObject("ADODB.Recordset")

rs.Open sql, dbConn, 3, 3

recnum = rs.RecordCount

rs.close

On the test server, it's slow, but it works. I then installed the ODBC driver on a production server, and ran the same ASP code. This time it had an error:

Microsoft OLE DB Provider for ODBC Drivers error '80040e21'

ODBC driver does not support the requested properties.

/it/webdev/test/scps/odbc.asp, line 18

It crashed my entire server, including everything else I had running. I can't afford to poke around using this server. One crash was bad enough. Does anyone have any ideas or know what the problem is, please let me know.

-Jason

[The Mad Jammer]

This message is usually associated with trying to insert data into a field that is too small. (i.e.) you'll get this error if you try to insert 30 bytes of data into a field that is defined as less than 30 bytes, or if a number is larger than the data type that defines it. This is MS-SQL so you may have to revisit your SQL tables and their designs to be sure that the fields are defined to handle the largest amount or value of data that could be stored in them.

the Mad Jammer

[The Mad Jammer]

While looking at your SQL code, perhapa the value in rs.RecordCount is larger than the number that recnum variable can hold.

the Mad Jammer