Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
I am using following script,when i am connected to VB it's work,
Sub OpenDB()
Set conDB = Server.CreateOb ject("ADODB.Con nection")
conDB.Connectio nTimeOut=60
If Request.ServerV ariables("HTTP_ HOST")="www.sha n.com" Or Request.ServerV ariables("HTTP_ HOST")="shan.co m" Then
conDB.Open "shan", "shan1", "test"
Else
conDB.Open "shan", "", "test1"
End If
End Sub
Comment