anyone have linked tables to a sql server 2000 database?

  • Thread starter Thread starter Zodiacal
  • Start date Start date
Z

Zodiacal

anyone have an acces 97 database that has linked tables to a sql server
2000? i get error: 'odbc call failed' when i try to link a table that has
about 30 or more columns. but if i link less than 30 it works.
 
Don't know if this could be your problem, but I had
similar occurrence with ODBC link to fox table. The link
to the table would be successful, but when I tried to
include all columns in a query, got errors. Problem was
that one of the columns was a data type not supported by
Access (dec I think). If I excluded the offending column
from queries etc, the link was OK

HTH Frank H
 
i exported the table from my access database shouldn't it have all the right
datatypes?
 
i did an odbc trace and it comes up with a few errors:
f5c-cc8 EXIT SQLExecute with return code -1 (SQL_ERROR)
HSTMT 02452CA8

DIAG [37000] [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1:
Incorrect syntax near ','. (170)

DIAG [37000] [Microsoft][ODBC SQL Server Driver][SQL Server]Unclosed
quotation mark before the character string ' = ?'. (105)

DIAG [37000] [Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s)
could not be prepared. (8180)

does that mean anything to anyone?
or this one:
f5c-cc8 EXIT SQLExecDirect with return code -1 (SQL_ERROR)
HSTMT 02451FA0
UCHAR * 0x040F13A8 [ -3] "SELECT Config, nValue FROM
MSysConf\ 0"
SDWORD -3

DIAG [S0002] [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object
name 'MSysConf'. (208)
 
Back
Top