|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
|
#1
|
|||
|
|||
|
Hello,
I have successfully installed mySQL server and myODBC to use with my ASP application, but I can't find the way to properly configure it to return the "RecordCount" property from a recordset... I read the myODBC manual and it says a flag "return matching rows" should be set, which I think it's done cause the checkbox is selected in the ODBC part of the control panel. When connecting to the DB from my ASP file I use a connection string like: "DRIVER={MySQL ODBC 3.51 Driver};SERVER=localhost;DATABASE=db;UID=uid;PWD=; OPTION=3". I believe the OPTION=3 parameter should do the trick but it's not working. Everything else does, like inserts, etc. Is there something I need to configure elsewhere? Thanks in advance. |
|
#2
|
||||
|
||||
|
Try setting the .cursorlocation of the recordset to 3.
e.g. Code:
rs.open rs.cursorlocation = 3 |
|
#3
|
|||
|
|||
|
Thanks, I'll try. It's driving me nuts because my app was originally written to use SQL Server and some things don't work with mySQL, which is running on the remote server... But what is weirder is that the remote mySQL does return the recordcount property without modifying the code >:-/
|
![]() |
| Viewing: Dev Articles Community Forums > Databases > MySQL Development > Problem with ASP and mySQL |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|