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 |
|
NMCoderMike
Starting Member
4 Posts |
 Posted - 2006-02-02 : 22:59:21
|
| Okay here's my problem. I have 4 databases on a sql2000 server. I use Dreamweaver on a development machine and have my webserver (IIS5) and SQL server on a Win2k Server box. As I stated in my subject line, 2 of the db's connect thru ASP pages, just as they should while two give me the dreaded "Data source name not found and no default driver specified" error; I connect using connection strings written by Dreamweaver. I created the two databases that are connecting in the beginning of December, and I created the 2 that are not connecting towards the end of December. I create the System ODBC connections the same way for each database and do it the same way on each box. For the two working databases I am able to connect thru Dreamweaver using the SYSTEM DSN, for the two non-conecting databases, Dreamweaver will only connect using the LOCAL DSN. I am also able to connect to the SQL server using Enterprise Manager on my development box with no issues, I can create, drop, add, etc. databases. On my server box, I have added the IUSER_computername user to the www folders, so that is not an issue. And just to complicate things I have Apache, PHP, mySQL running on the server as well. As a sidenote, the Apache,Php,mySQL install works without issues. I have updated the MDAC on both boxes to 2.8 sp1, does anyone have any ideas. I have been racking my brains for days now on this problem. I fear the answer is to rebuild the server, anyone have any better ideas? |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-02-03 : 06:42:34
|
| Sounds like you have user permissions (or permissions for a Role that users are members of) for SOME database, but not the others.Suggest you check what Users and Roles are defined on the databases that work, and compare with the databases that don't work.Kristen |
 |
|
|
|
|
|
|
|
Can connect to 2 of 4 databases