adodbconnection - property value

[zerbie45]

I don't understand why but If I use vbscript the following code works
fine:

....connection string.....
dbConn.Open
msgbox dbConn.Property

but the corresponding code in asp:

...connection string.....
dbConn.Open
response.write dbConn.Property

returns the error "Arguments are of the wrong type, are out of
acceptable range, or are in conflict with one another" In both cases
connection to sql server is ok. I'm not very proficient with asp so it
may be a stupid question....

Thank you in advance.

 

[Paxton]

I don't understand why but If I use vbscript the following code works
fine:

...connection string.....
dbConn.Open
msgbox dbConn.Property

but the corresponding code in asp:

..connection string.....
dbConn.Open
response.write dbConn.Property

returns the error "Arguments are of the wrong type, are out of
acceptable range, or are in conflict with one another" In both cases
connection to sql server is ok. I'm not very proficient with asp so it
may be a stupid question....

Thank you in advance.

for each objProp in dbconn.Properties
response.write objProp.Name & ": " & objProp.Value & "<br>"
next

To retrieve a specific property value:

response.write dbconn.Properties("[Name]") where [Name] is the property
you want to access

/P.