Cannot connect to DB with asp classic and connection string
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)
tope_results.asp (Result file which use above connection for connecting to DB)
MM_admin_sea_STRING = "Provider=SQLOLEDB.1;Password=***;Persist Security Info=True;User ID=***;Initial Catalog=***;Data Source=22.214.171.124;"
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.
<!--#include virtual="/Connections/admin_sea_tracker.asp" -->
Set rs_products_cmd = Server.CreateObject ("ADODB.Command")
rs_products_cmd.ActiveConnection = MM_admin_sea_STRING ===> (Line31)
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>
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.