ms access+mssql tables

This is a discussion on "ms access+mssql tables" within the Databases section. This forum, and the thread "ms access+mssql tables are both part of the Program Your Website category.


 Subscribe in a reader

Go Back   Webforumz.com > Main Forums > Program Your Website > Databases

Notices




Reply
 
LinkBack Thread Tools
  #1  
Old Dec 16th, 2005, 11:41
New Member
Join Date: Dec 2005
Age: 24
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
ms access+mssql tables

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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote

  #2  
Old Dec 19th, 2005, 11:36
New Member
Join Date: Dec 2005
Age: 24
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Re: ms access+mssql tables

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'
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #3  
Old Dec 19th, 2005, 12:13
New Member
Join Date: Dec 2005
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Re: ms access+mssql tables

have you configured your ODBC settings?
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
Reply

Tags
accessmssql, tables

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Prevent injection MSSql server ktsirig Databases 0 Oct 16th, 2007 08:58
ASP - MSSQL date format problem dwair Classic ASP 5 Nov 29th, 2005 23:15
MSSQL & ASP.NET Hosting....Cheapest Trebz Hosting & Domains 3 Aug 30th, 2005 23:37
MS Access and dissapearing tables.... courtjester Databases 11 Jul 29th, 2004 08:08
[SOLVED] MySQL to MSSQL Anonymous User Databases 7 Oct 6th, 2003 07:48


All times are GMT. The time now is 10:22.


Powered by vBulletin®
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.2.0 RC8
© 2003-2008 Webforumz.com : All Rights Reserved

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42