Results 1 to 3 of 3

Thread: ** TAKE A PEEK AT THIS **

  1. #1
    Join Date
    Dec 1969

    Default ** TAKE A PEEK AT THIS **

    In the process of answering a question, I created this little ASP page:<BR><BR>****** dumpDSNinfo.asp *****<BR>&#060;HTML&#062;&#060;BODY&#062;<BR>Indiv idually named properties of connection object:&#060;P&#062;<BR>&#060;%<BR>Set conn = Server.CreateObject("ADODB.Connection")<BR>conn.Op en "DSN=db1"<BR>props = Array("Attributes","CommandTimeout","ConnectionStr ing","ConnectionTimeout", _<BR> "CursorLocation","DefaultDatabase","IsolationLevel ","Mode", _<BR> "Provider","State","Version")<BR>For i = 0 To UBound(props)<BR> p = props(i)<BR> Response.Write p & ": " & Eval("conn." & p) & "&#060;BR/&#062;"<BR>Next<BR>Response.Write "&#060;HR&#062;Names and values in Properties collection:&#060;P&#062;"<BR>For Each p In conn.Properties<BR> Response.Write p.Name & ": " & p.Value & "&#060;BR/&#062;"<BR>Next <BR>%&#062;<BR>&#060;/BODY&#062;&#060;/HTML&#062;<BR>*****************************<BR><BR >And here&#039;s the output of it from a sample DSN. There&#039;s some *GOOD* stuff in here. For example, look at the property named "ORDER BY Columns in Select List"! For Access, it is False, meaning you can&#039;t do ORDER BY a dynamically created column name (you have to do ORDER BY column *number* instead).<BR><BR>OUTPUT:<BR><BR>Attributes: 0<BR>CommandTimeout: 30<BR>ConnectionString: Provider=MSDASQL.1;Extended Properties="DSN=db1;DBQ=C:InetpubwwwrootDemosdb1.m db;DriverId=25;FIL=MS Access;MaxBufferSize=2048;PageTimeout=5;"<BR>Conne ctionTimeout: 15<BR>CursorLocation: 2<BR>DefaultDatabase: C:InetpubwwwrootDemosdb1<BR>IsolationLevel: 4096<BR>Mode: 0<BR>Provider: MSDASQL.1<BR>State: 1<BR>Version: 2.7<BR><BR>--------------------------------------------------------------------------------<BR>Current Catalog: C:InetpubwwwrootDemosdb1<BR>Reset Datasource: <BR>Active Sessions: 64<BR>Asynchable Commit: False<BR>Catalog Location: 1<BR>Catalog Term: DATABASE<BR>Catalog Usage: 13<BR>Column Definition: 0<BR>NULL Concatenation Behavior: 1<BR>Data Source Name: db1<BR>Read-Only Data Source: False<BR>DBMS Name: ACCESS<BR>DBMS Version: 04.00.0000<BR>GROUP BY Support: 2<BR>Heterogeneous Table Support: 0<BR>Identifier Case Sensitivity: 4<BR>Maximum Index Size: 255<BR>Maximum Row Size: 4052<BR>Maximum Row Size Includes BLOB: False<BR>Maximum Tables in SELECT: 16<BR>Multiple Storage Objects: False<BR>Multi-Table Update: False<BR>NULL Collation Order: 4<BR>OLE Object Support: 1<BR>ORDER BY Columns in Select List: False<BR>Prepare Abort Behavior: 2<BR>Prepare Commit Behavior: 2<BR>Procedure Term: QUERY<BR>Provider Name: MSDASQL.DLL<BR>OLE DB Version: 02.00<BR>Provider Version: 02.70.7713.0<BR>Quoted Identifier Sensitivity: 8<BR>Schema Term: <BR>Schema Usage: 0<BR>SQL Support: 257<BR>Structured Storage: 1<BR>Subquery Support: 31<BR>Isolation Levels: 4096<BR>Isolation Retention: 0<BR>Table Term: TABLE<BR>User Name: admin<BR>Pass By Ref Accessors: True<BR>Transaction DDL: 8<BR>Asynchable Abort: False<BR>Data Source Object Threading Model: 2<BR>Output Parameter Availability: 4<BR>Persistent ID Type: 4<BR>Multiple Parameter Sets: True<BR>Rowset Conversions on Command: True<BR>Multiple Results: 0<BR>Provider Friendly Name: Microsoft OLE DB Provider for ODBC Drivers<BR>Connection Status: 1<BR>Server Name: ACCESS<BR>Open Rowset Support: 0<BR>Accessible Procedures: True<BR>Accessible Tables: True<BR>Integrity Enhancement Facility: False<BR>Outer Join Capabilities: 83<BR>Stored Procedures: True<BR>Driver Name: odbcjt32.dll<BR>Driver Version: 04.00.6019<BR>Driver ODBC Version: 03.51<BR>Like Escape Clause: N<BR>Special Characters: ~@#$%^&*_-+=}{"&#039;;:?/&#062;&#060;,.![]&#124<BR>Max Columns in Group By: 10<BR>Max Columns in Index: 10<BR>Max Columns in Order By: 10<BR>Max Columns in Select: 255<BR>Max Columns in Table: 255<BR>Numeric Functions: 5439337<BR>SQL Grammar Support: 0<BR>Outer Joins: Y<BR>String Functions: 360061<BR>System Functions: 0<BR>Time/Date Functions: 106495<BR>File Usage: 2<BR>Active Statements: 0<BR>Password: <BR>Persist Security Info: <BR>User ID: <BR>Data Source: <BR>Window Handle: <BR>Location: <BR>Mode: <BR>Prompt: 4<BR>Connect Timeout: 15<BR>Extended Properties: DSN=db1;DBQ=C:InetpubwwwrootDemosdb1.mdb;DriverId= 25;FIL=MS Access;MaxBufferSize=2048;PageTimeout=5;<BR>Locale Identifier: 1033<BR>Initial Catalog: <BR>OLE DB Services: -7<BR>General Timeout: <BR>Autocommit Isolation Levels: 4096<BR>

  2. #2
    Join Date
    Dec 1969

    Default Neat (EOF)

    post.EOF = true

  3. #3
    Join Date
    Dec 1969

    Default hey

    never knew you could do this. Really cool !!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts