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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-09-20 : 13:29:18
|
| Vijay Mehta writes "Hi,I have installed SQL 2005 on a Win XP SP2 laptop which already had SQL 2000 installed and working fine.I have created a new database with SQL 2005 and setup a user with db_owner and public rights to the newly created database.I am now having trouble in setting up a Data Source via Control Panel --> Administrative tools --> Data Source (ODBC).The data source that I already had for my SQL 2000 databases connects ok with the SQL 2000 db.All my attempts to set up a data source against the SQL 2005 are not working and cannot connect to the SQL 2005 database.When in the Data source, System DSN Tab, the list of drives only show SQL Server, so I presume this is the only driver to select irrespective of SQL 2000 or 2005.Please let me know what you think the problem might be. I am running into issue as I have two versions of SQL on same machine or do I need to do something else.For your reference I need the Data Source for connection from Progress Software to SQL 2005 db.Many thanksVijay" |
|
|
|
|
|
SQL 2000 and SQL 2005 - Data Source config