| Author |
Topic |
|
tojenise
Starting Member
6 Posts |
 Posted - 2003-10-08 : 18:12:53
|
| Hello,I'm using an dsn-less OLEDB connection to connect my ASP pages to a remote SQL Server 2K DB. The connection and website is working fine on our development environment, which is on a NT system. The structure of our production environment is the same except when I copied my ASP files over to production I can no longer access the database and get the following message.Microsoft OLE DB Provider for SQL Server error '80004005' [DBNMPNTW]Specified SQL server not found. I'm using the following statement to connect to SQL Server:Conn.Open "Provider=SQLOLEDB; Data Source=SJ-ISPI01; Initial Catalog=DBName; User Id=MyUsers; Password=xxxxxx;Does anyone have any suggestions why the connection would not work. No database or code changes, just copy and pasted the file.Thank You,Jenise |
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2003-10-08 : 18:19:19
|
| Is "SJ-ISPI01" the name of your production SQL Server?If you PING SJ-ISPI01, does it give you a result, or host name not found??Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
 |
|
|
tojenise
Starting Member
6 Posts |
Posted - 2003-10-08 : 18:25:11
|
| Yes, that is the server where sql server is located. I am getting records returned. Do you think that an older version of MDAC could be an issue? |
|
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2003-10-08 : 18:40:19
|
| Wait a second, you are getting records returned, but are getting this error? How often are you getting this error?? Can you describe HOW you are getting this error?Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-10-08 : 18:45:21
|
| Yes MDAC could be the issue. Try installing MDAC 2.7 to see if it corrects the problem.Tara |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-10-08 : 18:45:58
|
| I think when he says records returned, I think he means from the ping.Tara |
|
|
|
tojenise
Starting Member
6 Posts |
Posted - 2003-10-08 : 18:52:41
|
| I have one server for SQL Server and I have two web servers...one dev and one production. The development server is currently accessing the SQL Server, so that is returning records fine. When I point the production server to the SQL Server, I receive the error message. So I know that records are being returned, it's just I cannot access the DB from my production web server. Does that make sense? |
|
|
|
tojenise
Starting Member
6 Posts |
Posted - 2003-10-08 : 18:53:47
|
| But I am now looking into updating the MDAC on the production web server to see if that works. |
|
|
|
tojenise
Starting Member
6 Posts |
Posted - 2003-10-13 : 14:50:01
|
| Updating the MDAC and Microsoft Jet files worked! Thanks for the advice. |
|
|
|
|
OLEDB Connection