ODBC Connection Issue On Client Site

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

SQL Server 2005 Forums

SQL Server Administration (2005)

ODBC Connection Issue On Client Site

Author

Topic

prince500
Starting Member

21 Posts

Posted - 2007-06-07 : 13:09:26

Hi,
I am not sure if I select right Froum:)
It might be a basic question but could you please help me on that?

Working Environment:

I have developed application on SQL Server 2005 and now wants to Run on Client Site, I am using access as a front end and SQL server 2005 back end through ODBC (System Dsn) which is working good. (user has been added on SQL Server and on Database)

Question:

1) Do I need to create new System Dsn Or other DSN (Keep in mind I have already create System DSN in Server) at each client site to access application from Server?

(If yes then I am trying to do that, it allow me to create (with required database which is on Server) and verify but doesn’t save on ODBC list so I can’t use that name to run appliation on client site)

I am using windows authentication.

Thanks for help in advance

AA

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-06-07 : 13:41:24

If the application runs on the client, then the ODBC data source must also exist on the client.

If you aren't able to save a DSN on the client, then the user that you are using doesn't have proper permissions. Try doing it with a local admin user.

Tara Kizer
http://weblogs.sqlteam.com/tarad/