Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kbearhome
Starting Member
36 Posts |
 Posted - 2003-10-15 : 12:29:00
|
| I have a user trying to link tables to SQL server through Access. (note: we have been doing this for years with a different database on the same server without a problem.) He opens one of the tables and it's fine. He opens the next table and gets "ODBC call failed" then next box is "Incorrect syntax near "", error 170" Then he can't open the first table that did open correctly. All the fields say ?Name.We reproduced this on my computer. I changed my ODBC connection so that the Ansi nulls, paddings was checked and relinked the tables - everything was fine. He looked at his ODBC configuration and the Ansi nulls was already checked so I'm back to the drawing board.Any help on why there are occasional problems with linking to SQL besides the fact that Access is not the best way - it is all we have.Thanks |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-10-15 : 12:42:13
|
| Have you tried re linking the tables?Try using the profiler to see what is sent to the server and install the latest mdac on his machine.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
Linking to SQL