Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ODBC Call failed Error 3146 only on some PC's
Running SQL 7.0, Win 2000, Excel 2002 and MDAC 2.5 SP 2 or later.
ODBC Call VBA: dbGMS.QueryTimeout = 0 Set rst = dbGMS.OpenRecordset(mstrSQL, dbOpenSnapshot, dbSQLPassThrough) Works on dev p.c.s and one non-key user p.c. Key user p.c.'s get ODBC call Failed: 3146. Have verified is not a SQL 7.0 rights issue. MS Error help suggests it is related to "Select NoCount On" command. Since this is a recordset call, a Select NoCount On is required at some point. VBA is identical to another Excel 97/2000 wb that works with a "Select NoCount On" right at the beginning of the SQL string. I used this file as a template for this new report. Any suggestions? ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ODBC Microsoft Access Driver Login Failed | Excel Discussion (Misc queries) | |||
ODBC Microsoft Access Driver Login Failed | Excel Worksheet Functions | |||
ODBC connection failed. | Excel Discussion (Misc queries) | |||
ODBC connection failed. | Excel Discussion (Misc queries) | |||
ODBC connection failed. | Excel Discussion (Misc queries) |