2. ASPRunnerPro General questions
  3. recordcount not suported by SQL Server?
This topic is locked

recordcount not suported by SQL Server?

 		2/19/2004 13:23:57
ASPRunnerPro General questions
M
 mcrpds author

I can run my asp pages against MS access db, but run into error 3001 "number of arguments not supported..." when I point it to my SQL Server DB it gets an error when trying to determine the number of detail records:

maxRecords = cdbl(setupRs.RecordCount)
Can anyone provide help? Thank you in advance.
Sergey Kornilov admin 2/19/2004

Hi,
what is your connection string when you connect to MS SQL?

Connection string can be found in include/..._dbconnection.asp file.
M
 		mcrpds author 2/19/2004

strConnection = "Provider=sqloledb;server=oakwood9502s;Database=HR_DEV;User ID=mcr;Password=mcr1;"
Sergey Kornilov admin 2/19/2004

Hi,
RecordCount won't work with sqloledb provider.
Why don't you use connection string that ASPRunner generates?

strConnection = "Provider=MSDataShape;DRIVER=SQL Server;SERVER=SERVER;UID=sa;PWD=sa;APP=AspRunner Application;WSID=SERVER;DATABASE=Northwind;Network=DBMSSOCN"
M
 		mcrpds author 2/19/2004

I created it with Access and later moved the backend to SQL. I'll give it a shot. Thanks! <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=1142&image=1&table=forumreplies' class='bbc_emoticon' alt=';)' />