Forums  

Go Back   Forums > Acucorp Customer Forum > General
FAQ Members List Calendar Search Today's Posts Mark Forums Read

Reply
 
Thread Tools Display Modes
  #1  
Old 09-08-2003, 09:48 AM
Milk5600 Milk5600 is offline
Registered User
 
Join Date: Nov 2002
Posts: 175
Question Sqlcode = 1

When I link up to a sql server database using an ODBC dsn, and I display the SQLCODE, the value is 1. I can display records from the tables, but I can't seem to update or add records.
Does anyone know where I can get a list of SQLCODE values and their meanings???
Thank You!!
Reply With Quote
  #2  
Old 09-09-2003, 06:18 AM
gforseth gforseth is offline
Super Moderator
 
Join Date: Nov 2002
Location: Norway
Posts: 1,259
Given that you cannot add or modify records, the return status is most likely SQL_MODE_READ_ONLY. Which means your connection has been opened for RO. You may know that the AcuODBC product can be delivered with a RO license? Chances are, this is what you got.
As for future references, your best source of these codes would be the ODBC SDK from Microsoft.
You could look at

http://www.microsoft.com/msdownload/...sdk/sdkupdate/

and MDAC SDK.
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT -7. The time now is 01:02 PM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.