Hi All,
I am trying to connect to an SQL SERVER in a remote production server from ASP.net using following code.
Dim conProd As New OleDbConnection ("Provider=SQLO LEDB.1;Data Source=ServerNa me;UID=User Name;PWD=Passwo rd;Initial Catalog=Databas e")
conProd.Open()
I am getting following error while running this script
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server...