Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Can't create SQL Server ODBC Connection

Status
Not open for further replies.

osubb

Programmer
Jan 21, 2004
11
0
0
US
I'm trying to create a SQL Server connection through ODBC manager.

I click on the 'ADD' button in the 'System DSN' tab.
It takes me to the "Create New Data Source" window. I then select the "SQL SERVER" driver and click "FINISH" tab. Instead of getting a window to add properties, it takes me back to the "System DSN" window.

Any idea why it won't let me create a new source?
I'm on a WinXP SP#2 machine.

ldl61
 
Do you have admin privs on that machine? If not, select the user DSN tab instead.

"I think we're all Bozos on this bus!" - Firesign Theatre [jester]
 
Yes, I have admin. I also tried the "User DSN" tab. Both just returned me to the "User/System DSN" window.

This seems to be a problem with only "SQL Server" driver.

I was wondering if it could be MDAC driver. Not really sure what it is, someone at work mentioned it. Trying to get info now.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top