Bob:
Sorry, you are right, I had the "On Error Resume Next", which I have now
commented out. Here are the various error messages - I am printing the
connection string at the top of each page.
*****************************
Provider=SQLOLEDB;Integrated Security=True;Initial Catalog=MEDIA;Data
Source=.\SQLEXPRESS
Provider error '80040e21'
Multiple-step OLE DB operation generated errors. Check each OLE DB status
value, if available. No work was done.
*****************************
DSN=Media
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database "iMedia"
requested by the login. The login failed.
*****************************
Provider=SQLNCLI.1;Integrated Security=SSPI;Persist Security
Info=False;Initial Catalog=iMedia;Data Source=MEDIA/SQLEXPRESS
Microsoft SQL Native Client error '80004005'
Named Pipes Provider: Could not open a connection to SQL Server [51].
*****************************
BTW, with the DSN above I tried both Windows Authentication and SQL User
Authentication. I also did the "Test Data Source" in both instances and it
works. I know it is some syntax problem because I am using this last
connection string succesfully with ASP.Net/C# and a VB.Net service both of
which I wrote and are on the same machine/same website.
All help is appreciated. Thanx,
--
Anil Gupte
www.keeninc.net www.icinema.com
"Bob Barrows [MVP]" <reb01501@NOyahoo.SPAMcomwrote in message
news:OGufjCgKIHA.6008@TK2MSFTNGP05.phx.gbl...
Quote:
You still have yet to show us the line that produces that error. If the
Connection.Open statement does not throw an error, then there is nothing
wrong with your connection string. I do not blieve the Connection.Open
statement can throw that particular error ... wait ... "Connection" may be
a reserved keyword. Try calling your connection object "cn" or "conn" or
something like that.
>
The only other possibility is that the Connection.Open statement actually
IS throwing an error, but you have an "on error resume next" statement
earlier in your code that is masking te error. Make sure you comment out
that statement so you can see if the Open statement produces an error. If
it does, show us THAT error message.
>
Anil Gupte wrote:
Quote:
>Yes, I have that earlier in the file
>Dim Connection
>Set Connection=Server.CreateObject("ADODB.Connection")
>>
>sConnString = "Provider=SQLNCLI.1;Integrated Security=SSPI;Persist
>Security Info=False;Initial Catalog=iMedia;Data
>Source=IMEDIA/SQLEXPRESS" ' Tried both the above and the below - no
>luck sConnString = "Provider=SQLOLEDB;Integrated Security=True;Initial
>Catalog=IMEDIA;Data Source=.\SQLEXPRESS"
>Connection.Open sConnString
>Dim Recordset 'Here we declare our variable that will hold our new
>object Set Recordset=Server.CreateObject("ADODB.Recordset")
>>
>Thanx for your help
>>
>"Bob Barrows [MVP]" <reb01501@NOyahoo.SPAMcomwrote in message
>news:ejWqWnUKIHA.4752@TK2MSFTNGP05.phx.gbl...
Quote:
>>So the "Connection.Open sConnString" statement didn't raise an
>>error? I don't see any code in which you tried to use the connection
>>object. Neither do I see a
>>>
>>Set Connection = Createobject("adodb.connection")
>>>
>>statement. Does one exist?
>>>
>>Anil Gupte wrote:
>>>0xE7D:The connection cannot be used to perform this operation. It is
>>>either closed or invalid in this context.
>>>>
>>>>
>>>"Bob Barrows [MVP]" <reb01501@NOyahoo.SPAMcomwrote in message
>>>news:OG%230aZTKIHA.4880@TK2MSFTNGP03.phx.gbl. ..
>>>>Anil Gupte wrote:
>>>>>I am using the following to try to connect to the database, but it
>>>>>does not seem to be working.
>>>>>>
>>>>>Dim sConnString
>>>>>sConnString = "Provider=SQLNCLI.1;Integrated Security=SSPI;Persist
>>>>>Security Info=False;Initial Catalog=MediaDB;Data
>>>>>Source=MEDIAMACHINE\SQLEXPRESS" Connection.Open sConnString
>>>>>Dim Recordset
>>>>>Set Recordset=Server.CreateObject("ADODB.Recordset")
>>>>>>
>>>>>Can someone tell me the correct syntax? The original syntax
>>>>>(which worked) for an Access DB was as follows:
>>>>>sConnString="PROVIDER=Microsoft.Jet.OLEDB.4.0 ;" & "Data Source=" &
>>>>>Server.MapPath("/Music/DB/MediaDB.mdb")
>>>>>>
>>>>You really need to show us the error message, but i will say that I
>>>>have had little success connecting to SQL2005 with integrated
>>>>security from ASP. I would suggest creating a sql login on your
>>>>server and using its user id and password in your connection string
>>>>instead of Integrated Security=SSPI
>>>>>
>>>>--
>>>>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"
>>>
>>--
>>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"
>
--
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"
>
