Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  Other SQL Server Topics (2005)  "[Microsoft][SQL Native Client]Invalid cursor stat

Author  Topic  atera Starting Member 3 Posts Posted - 2010-05-17 : 11:41:10 Please help with the following error: If you use the SQL Native Client data source driver, you receive the following error message: MessageText = "[Microsoft][SQL Native Client]Invalid cursor state". This problem occurs if the following conditions are true: The value that you specify in one of the following parameters of the SQLTables function contains a wildcard character: CatalogName, SchemaName, TableName For example, one of these parameters contains an underscore (_) character or a percent (%) character. We are getting this error when using a Vendor software. This could potentially causing other problems for us but since we are not sure how or what to do to resolve it we can't figure out if it is contributing to our other problems. All help is appreciated! Thanks, Angela