ms access+mssql tables - SQL Server Forums

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.

All Forums

Other Forums

MS Access

ms access+mssql tables

Author

Topic

MaSe
Starting Member

8 Posts

Posted - 2005-12-16 : 07:39:15

I have a ms access file whit form's raports, and moduls i linked the tables whit a ms access database that i not have at home.
dit thit whit odbc, but when i open a table the database asks me a 1000 times for the sql server password.
I had the same thing whem i had my ms access file on the same network as the sql server but it only did this when the computer where not in the same domein.

please help

MaSe
Starting Member

8 Posts

Posted - 2005-12-19 : 07:35:22

Here are the errors that i get:

Connection failed
SQLstate: '01s00'
SQL Server Error: 0
[Microsoft][ODBC SQL Server Driver] invalid connection string attribute

Connection failed
SQLstate: '28000'
SQL Server Error: 18456
[Microsoft][ODBC SQL Server Driver][SQL Server] login failed for user 'computername\Gast'

AndrewMurphy
Master Smack Fu Yak Hacker

2916 Posts

Posted - 2005-12-19 : 08:28:47

Please post the connection string....(after obscuring the password).

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources