Hi, using ADODB in ASP pages we have this strange problem. If we create an ADODB connection specifying the DNS server name instead of IP server address, then sometimes, during call to Execute method we get this error: [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied. The code looks simply like: <% Dim cn, rst Set cn = Server.CreateObject("ADODB.Connection") cn.ConnectionString = "Driver={SQL Server};Server=sql.acme.com;Initial Catalog=SomeDB;User Id=...;Password=..." cn.Open Set rst = cn.Execute("SELECT * FROM SomeTableWHERE ...") ... rst.Close Set rst = Nothing cn.Close Set cn = Nothing %> In my opinion, the strange things are: 1) No problem appears if we specify IP Server address 2) The problem is on the Execute and not on the cn.Open() 3) The problema appears sometimes We tried to add a line to hosts file too, to avoid use of resolver (in the hypotesys of name server problems) but nothing changed: the error still happens randomly. Unluckly, now we have to use the server name instead of IPAddress for the cohexistence of web and windows application from inside/outside LAN area. Thank you in advance.
Baba wrote: > Hi, > using ADODB in ASP pages we have this strange problem. > > If we create an ADODB connection specifying the DNS server name > instead of IP server address, then sometimes, during call to Execute > method we get this error: > > [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not > exist or access denied. > > The code looks simply like: > > <% > Dim cn, rst > > Set cn = Server.CreateObject("ADODB.Connection") > cn.ConnectionString = "Driver={SQL Server};Server=sql.acme.com;Initial > Catalog=SomeDB;User Id=...;Password=..." It sounds as if you have some network issues. However, you should use the native OLE DB provider for SQL Server rather than the obsolete ODBC provider. See the section about SQL Server OLE DB connections at www.connectionstrings.com -- Microsoft MVP - ASP/ASP.NET Please reply to the newsgroup. This email account is my spam trap so I don't check it very often. If you must reply off-line, then remove the "NO SPAM"
Baba wrote: > Hi, > using ADODB in ASP pages we have this strange problem. > > If we create an ADODB connection specifying the DNS server name > instead of IP server address, then sometimes, during call to Execute > method we get this error: > > [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not > exist or access denied. Like Bob says, use OLEDB. Then force TCP/IP instead of named pipes by specifying the network library: http://www.connectionstrings.com/article.aspx?article=howtodefinewichnetworkprotocoltouse In general, this is very useful: http://www.connectionstrings.com/?carrier=sqlserver -- Dave Anderson Unsolicited commercial email will be read at a cost of $500 per message. Use of this email address implies consent to these terms.
