Problem with ODBC.

viegasp

New member
Local time
Today, 07:18
Joined
Jul 7, 2010
Messages
7
Hi all,

In MS Access 2010 trial version when i try to link a table using ODBC the SQL Server login box appears with the OK button disabled.

This issue happens only in a specific 2005 SQL server.

Other users in my network can sucessfully connect to that SQL server so i'm assuming that this issue is not related with the server itself.

I've tried to update the ODBC drivers but it doesn't fix the problem.

If i manually use the ODBC connect string via pass-through query i can access data.

Anyone can help?

Best regards.
 
How interesting. I can't say off hand I've recalled a incident where the OK button was disabled.

What happen if you delete then re-link the table using a new DSN, for instance? Did it give you an error prior to showing that login dialog? Can you put down the connection string here (do go and omit the server name & user/password if included - I'm just interested in the details other than those).
 
The thing is that i can't create the table because the OK button in the login dialog remains disabled... no errors occur before the login box is show.

But if i use the following DNS in a pass-through query i can sucessfully query the database

ODBC;DSN=«ServerName»;DATABASE=«DatabaseName»

Best Regards.
 
Last edited:
Are you the administrator of your own computer? Can you reach the Data Sources (ODBC) panel (Control Panel -> Administrative Tools -> Data Source (ODBC)? If so, can you create a new DSN?
 
Yes i am admin and i can create new ODBC's. I already try to re-create the DSN and test the connection sucessfully. But the OK button in the login box remais disabled. :confused:
 
Okay, so you can create a new DSN then? And you still get that OK button disabled?

Are you using Windows Authentication (aka Trusted Connection) or SQL Server Authentication? What SQL Server driver are you using? "SQL Server Driver" or "SQL Server Native Client" or "SQL Server Native Client 10.0"... ?
 
Yes the button is still disabled.

No mather what option i use (win auth or sql auth - the server allows both ) the button remains disabled.

I have the following drivers:

SQL Native Client - SQLNCLI.dll
SQL Server - SQLSRV32.dll

Other users can sucessfully connect using the same version of the drivers.

Regards.
 
What about a new blank Access database... Does it still happen there, too?
 
yes it does. and the strange thing is that i connect to other sql servers 2000, 2005 and 2008 using the same odbc drivers and i have no problems at all.

the inverse is already true, other people in my network connect sucessfully to this specific server using the same drivers and the same MS Access version.

it's a mistery... i google it and i can't find similar issues. seems that i have to continue to use pass through querys...

best regards.
 
Could this be a new computer, or was it recently re-configured? If so, does the SQL Server in question authorize you to log in?
 
no it's not new and also no new configurations were made in the computer.

the connectivity with the server exists of course. i can query the databases using a pass-through with DNS specified and i also can log in into sql server management studio or any other query tool.
 
Wow, that's a stumper you've got there, definitely.

The only thing I can think of is to re-install the ODBC driver but I think you said you already did that... I do see you've already tried to update, but maybe re-install is what's needed?
 
Can't say I've ever seen this either.
I remember, back in the day, that Access ODBC admin panel (not ODBCAd32) could be disabled by the AV on the system. Nothing as specific as this springs to mind.

I imagine you've tried every re-install in to be had.

One thing that did raise an eyebrow...
>> No mather what option i use (win auth or sql auth - the server allows both ) the button remains disabled.

You're saying that a table linked specifically stipulated to use integrated security still prompted you for a UN and PW??
That would be pointing to something more going on surely...

Cheers.
 
Just to mention finally, as far as suggestions...
You could look to slowly exclude things.
For example trying an OS restore to a previous point when this prompting didn't occur. If it's OK again then progressively moving on until a point when it fails again.
Or it still doesn't work after the restore then perhaps you're looking for an influence external to the PC.

Just try to eliminate the impossible. ;-)

Cheers.
 
Just to clarify the issue regarding the trusted connection, when i choose the OBDC entry a SQL Server login box is show and i've an option (check box) to select the trusted connection or in alternative two text boxes (Login Id and Password) to use SQL auth, what i said is that no mather what option i choose here the OK button remains disabled.

Regarding the system restore it's not applicable since i never was able to create the linked tables from this server.

Thanks for your help anyway... for now my best option is continue to use pass through querys in order to access database.
 

Users who are viewing this thread

Back
Top Bottom