MS SQL Server ODBC - odbc link failed

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

odbc link failed

Ponch

2006-01-18, 7:23 am

Hello,

I have a windows SBS2003 server with msde installed.
I created some odbc datalinks in microsoft acces to one of my sql databases.
The links are ok end i can access the odbc links in microsoft acces on my
server.

Problem :
When i open the access database on my workstation and try to connect to one
of the odbc links, i getr the followin error.

ODBC-connection to 'SQL Server<servername> failed

Microsoft Access can't open the table in Datasheet View

Any suggestions?

Thank you,

Sponsored Links