Hey folks, I have a connection string in asp and a asp page which is connected to that connection string asp page, but I got a big problem :
Microsoft OLE DB Provider for SQL Server error '80004005'
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
/en/tope_results.asp, line 31
this error happen when my asp page is try to connect to DB using my connection string file .
admin_sea_tracker.asp (connection string file)
MM_admin_sea_STRING = "Provider=SQLOLEDB.1;Password=***;Persist Security Info=True;User ID=***;Initial Catalog=***;Data Source=18.104.22.168;"
tope_results.asp (Result file which use above connection for connecting to D
<!--#include virtual="/Connections/admin_sea_tracker.asp" -->
Set rs_products_cmd = Server.CreateObject ("ADODB.Command")
[B][COLOR="Red"]rs_products_cmd.ActiveConnection = MM_admin_sea_STRING[/COLOR][/B] ===> [B](Line31)[/B]
rs_products_cmd.CommandText = "SELECT * FROM dbo.VSite WHERE FileNo = ?"
rs_products_cmd.Prepared = true
rs_products_cmd.Parameters.Append rs_products_cmd.CreateParameter("param1", 5, 1, -1, rs_products__MMColParam1) ' adDouble
Set rs_products = rs_products_cmd.Execute
rs_products_numRows = 0
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>:: Search Result ::</title>
Our db is SQL Server 2000. Admin give me user password that only I can access to one certain view in whole DB, I test my connection string in some connection string tester program (shown in attachment) and it said that connection managed to connect to Db successfully but I don't know where is the problem that I can't use that connection string file in my .asp pages, I just need to connect to DB by that connection string then my problem is solved, please give me some solutions.
If you want to test the application please go to thins link and choose a radio button then enter something in shipment tracking text box (its above news frame) then click go and you'll see the error)
Thank you very much folks.