Return all tables from a SQL Anywhere dB
Posted on 2000-03-30
I need to return all the tables from a SQL Anywhere dB, I thought this would work;
Dim conn, strConn, rs
Set conn = Server.CreateObject("ADODB.Connection")
strConn = "DSN=SERVER314CBF7B;uid=dba;pwd=dba;"
Set rs = conn.OpenSchema(adSchemaTables)
Do Until rs.EOF
Response.Write "Table name: " & rs.TABLE_NAME & "<br>"
Here is the error;
ADODB.Connection error '800a0cb3'
The operation requested by the application is not supported by the provider.
/test/sqltable.asp, line 24
Does SQL not allow the OpenSchema operation? I have been reading that is does...