odbc PROBLEM

[TalentedFool]

Hi all

I Have SQL server 2000 sp3a developer on Windows XP pro sp2(Just updated)

I can update and write to my database via query analyzer but when I try to use my app to update which uses the SQLServer ODBC driver to connect I get "invalid cursor position" - I can read the DB no problem but not write/update.

I'm thinking its a permissions problem - the DB is set to use Windows auth -

any ideas?

cheers



~ Remember - Nothing is Fool Proof to a Talented Fool ~

 

[SQLBill]

There are issues with XP SP2. Microsoft has identified around 50 applications that will not work after the service pack has been applied. It's mainly due to the built-in firewall being turned on. Check out this link....

http://support.microsoft.com/default.aspx?kbid=842242

The built-in firewall blocks several ports. Guess what one of them is? Hope you guessed 1433 and 1434. Yep, MS blocks the ports for one of their own products.

-SQLBill

 

[TalentedFool]

SQLBill - yeah I read that - bunch of muppets! I've trawlled right the way through the SP2 release notes for sql server - thats what I'm testing at the mo - I've already created the exception list for 1433/1434 and sqlserver.exe and still no joy!

That's why I was thinking permissions on the db.




~ Remember - Nothing is Fool Proof to a Talented Fool ~

 

[SQLBill]

Shouldn't be a permissions error. You are using QA just fine.

Some things to try (in no particular order):

1. Unregister the SQL Server in Enterprise Manager and re-register it.

2. Uninstall EM and reinstall it.

3. Install the latest MDAC (I think it's 2.8) which is the driver ODBC uses.

-SQLBill