 | |
Re: Error 3146 - ODBC Call failed
comp.databases.oracle.misc comp.databases.oracle.misc
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
Re: Error 3146 - ODBC Call failed -
12-30-2008
, 02:03 AM
|
We just upsized to SQL server (Access 2003 front end). I am running into error 3146 on a particular table. Part of my code, I have a simple delete SQL statement and I am getting an error on this statement. CurrentDb.Execute "Delete * from [Raw Import Table];", dbSeeChanges Raw Import Table has a PK (ID - Autonumber). Does anyone know how to fix it? |
You have come to the right group!
Yours,
Laurenz Albe
#2
| |||
| |||
|
|
Hi everyone We just upsized to SQL server (Access 2003 front end). I am running into error 3146 on a particular table. Part of my code, I have a simple delete SQL statement and I am getting an error on this statement. CurrentDb.Execute "Delete * from [Raw Import Table];", dbSeeChanges Raw Import Table has a PK (ID - Autonumber). Does anyone know how to fix it? |
your current issue using your existing RDBMS. But if you were
to move to Oracle with a real front-end such as HTML_DB, a substantial
improvement by almost any measure, the issue would not exist.
--
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
#3
| |||
| |||
|
|
Hi everyone We just upsized to SQL server (Access 2003 front end). I am running into error 3146 on a particular table. Part of my code, I have a simple delete SQL statement and I am getting an error on this statement. CurrentDb.Execute "Delete * from [Raw Import Table];", dbSeeChanges Raw Import Table has a PK (ID - Autonumber). Does anyone know how to fix it? |
your current issue using your existing RDBMS. But if you were
to move to Oracle with a real front-end such as HTML_DB, a substantial
improvement by almost any measure, the issue would not exist.
--
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
#4
| |||
| |||
|
|
Hi everyone We just upsized to SQL server (Access 2003 front end). I am running into error 3146 on a particular table. Part of my code, I have a simple delete SQL statement and I am getting an error on this statement. CurrentDb.Execute "Delete * from [Raw Import Table];", dbSeeChanges Raw Import Table has a PK (ID - Autonumber). Does anyone know how to fix it? |
your current issue using your existing RDBMS. But if you were
to move to Oracle with a real front-end such as HTML_DB, a substantial
improvement by almost any measure, the issue would not exist.
--
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
#5
| |||
| |||
|
|
Hi everyone We just upsized to SQL server (Access 2003 front end). I am running into error 3146 on a particular table. Part of my code, I have a simple delete SQL statement and I am getting an error on this statement. CurrentDb.Execute "Delete * from [Raw Import Table];", dbSeeChanges Raw Import Table has a PK (ID - Autonumber). Does anyone know how to fix it? |
your current issue using your existing RDBMS. But if you were
to move to Oracle with a real front-end such as HTML_DB, a substantial
improvement by almost any measure, the issue would not exist.
--
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
#6
| |||
| |||
|
|
Niranjan wrote: Hi everyone We just upsized to SQL server (Access 2003 front end). I am running into error 3146 on a particular table. Part of my code, I have a simple delete SQL statement and I am getting an error on this statement. CurrentDb.Execute "Delete * from [Raw Import Table];", dbSeeChanges Raw Import Table has a PK (ID - Autonumber). Does anyone know how to fix it? SQL Server is not an Oracle product so we can not help you with your current issue using your existing RDBMS. But if you were to move to Oracle with a real front-end such as HTML_DB, a substantial improvement by almost any measure, the issue would not exist. -- Daniel A. Morgan Oracle Ace Director & Instructor University of Washington damor...@x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Groupwww.psoug.org |
always try to be helpful:
The 3146 is a catch all error that masks the real problem. Here is
one known issue where SQL Server database settings can cause the issue
and documents on the error and how to get more information.
PRB: DAO Run-Time Error 3146 When Modifying SQLServer Data
http://support.microsoft.com/kb/195225
How To Get More Information on the ODBC Call Failed Error
http://support.microsoft.com/kb/154510
Trappable Microsoft Jet and DAO Errors
http://msdn.microsoft.com/en-us/library/bb221208.aspx
HTH -- Mark D Powell --
#7
| |||
| |||
|
|
Niranjan wrote: Hi everyone We just upsized to SQL server (Access 2003 front end). I am running into error 3146 on a particular table. Part of my code, I have a simple delete SQL statement and I am getting an error on this statement. CurrentDb.Execute "Delete * from [Raw Import Table];", dbSeeChanges Raw Import Table has a PK (ID - Autonumber). Does anyone know how to fix it? SQL Server is not an Oracle product so we can not help you with your current issue using your existing RDBMS. But if you were to move to Oracle with a real front-end such as HTML_DB, a substantial improvement by almost any measure, the issue would not exist. -- Daniel A. Morgan Oracle Ace Director & Instructor University of Washington damor...@x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Groupwww.psoug.org |
always try to be helpful:
The 3146 is a catch all error that masks the real problem. Here is
one known issue where SQL Server database settings can cause the issue
and documents on the error and how to get more information.
PRB: DAO Run-Time Error 3146 When Modifying SQLServer Data
http://support.microsoft.com/kb/195225
How To Get More Information on the ODBC Call Failed Error
http://support.microsoft.com/kb/154510
Trappable Microsoft Jet and DAO Errors
http://msdn.microsoft.com/en-us/library/bb221208.aspx
HTH -- Mark D Powell --
#8
| |||
| |||
|
|
Niranjan wrote: Hi everyone We just upsized to SQL server (Access 2003 front end). I am running into error 3146 on a particular table. Part of my code, I have a simple delete SQL statement and I am getting an error on this statement. CurrentDb.Execute "Delete * from [Raw Import Table];", dbSeeChanges Raw Import Table has a PK (ID - Autonumber). Does anyone know how to fix it? SQL Server is not an Oracle product so we can not help you with your current issue using your existing RDBMS. But if you were to move to Oracle with a real front-end such as HTML_DB, a substantial improvement by almost any measure, the issue would not exist. -- Daniel A. Morgan Oracle Ace Director & Instructor University of Washington damor...@x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Groupwww.psoug.org |
always try to be helpful:
The 3146 is a catch all error that masks the real problem. Here is
one known issue where SQL Server database settings can cause the issue
and documents on the error and how to get more information.
PRB: DAO Run-Time Error 3146 When Modifying SQLServer Data
http://support.microsoft.com/kb/195225
How To Get More Information on the ODBC Call Failed Error
http://support.microsoft.com/kb/154510
Trappable Microsoft Jet and DAO Errors
http://msdn.microsoft.com/en-us/library/bb221208.aspx
HTH -- Mark D Powell --
#9
| |||
| |||
|
|
Niranjan wrote: Hi everyone We just upsized to SQL server (Access 2003 front end). I am running into error 3146 on a particular table. Part of my code, I have a simple delete SQL statement and I am getting an error on this statement. CurrentDb.Execute "Delete * from [Raw Import Table];", dbSeeChanges Raw Import Table has a PK (ID - Autonumber). Does anyone know how to fix it? SQL Server is not an Oracle product so we can not help you with your current issue using your existing RDBMS. But if you were to move to Oracle with a real front-end such as HTML_DB, a substantial improvement by almost any measure, the issue would not exist. -- Daniel A. Morgan Oracle Ace Director & Instructor University of Washington damor...@x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Groupwww.psoug.org |
always try to be helpful:
The 3146 is a catch all error that masks the real problem. Here is
one known issue where SQL Server database settings can cause the issue
and documents on the error and how to get more information.
PRB: DAO Run-Time Error 3146 When Modifying SQLServer Data
http://support.microsoft.com/kb/195225
How To Get More Information on the ODBC Call Failed Error
http://support.microsoft.com/kb/154510
Trappable Microsoft Jet and DAO Errors
http://msdn.microsoft.com/en-us/library/bb221208.aspx
HTH -- Mark D Powell --
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.