search for: showsystemt

...ver = PostgreSQL Trace = Yes TraceFile = /tmp/sql.log Database = bedrock Servername = localhost UserName = Password = Port = 5432 Protocol = 6.4 ReadOnly = No RowVersioning = No ShowSystemTables = No ShowOidColumn = No FakeOidIndex = No ConnSettings = *odbcinst.ini* [PostgreSQL] Description = ODBC for PostgreSQL Driver = /usr/lib64/libodbcpsql.so Setup = /usr/lib64/libodbcpsqlS.so FileUsage = 1 * res_odbc.conf* [postgres]...

...e this one out. Hope someone can help me. root@pbx:# cat /etc/odbc.ini [Asterisk] Description=PostgreSQL asterisk Driver=PostgreSQL Trace=No TraceFile=/tmp/odbc.log Database=asterisk ServerName=localhost UserName=XXXX Password=XXXX Port=5432 Protocol=7.4 ReadOnly=No RowVersioning=No ShowSystemTables=Yes ShowOidColumn=Yes FakeOidIndex=Yes ConnSettings= root@pbx:# cat /etc/odbcinst.ini [PostgreSQL] Description=PostgreSQL ODBC driver for Linux and Windows Driver=/usr/local/lib/psqlodbc.so Setup=/usr/lib/odbc/libodbcpsqlS.so Debug = 1 CommLog = 1 root@pbx:# echo "select...

...= 15 write(1, "\n ", 3) = 3 write(1, "LegacySQLTables=0", 17) = 17 write(1, "\n ", 3) = 3 write(1, "NumericAsChar=0", 15) = 15 write(1, "\n ", 3) = 3 write(1, "ShowSystemTables=0", 18) = 18 write(1, "\n ", 3) = 3 write(1, "LoginTimeout=0", 14) = 14 write(1, "\n ", 3) = 3 write(1, "QueryTimeout=200000", 19) = 19 write(1, "\n ", 3) = 3...

Hi, I'm trying to establish a connection to a MySQL database, and am using the rodbc package for it. This is in a GNU/Debian Linux box, with the corresponding Debian unstable packages. I can login to my MySQL databases from any shell and directory, so the problem is probably not there. Here's an example of what I'm doing: R> odbcConnect("test",

svn trunk. I'm trying to get cdr to work with my odbc database. I have followed a checklist that I had previously but still can't get it to work. There are no errors (verbose 40 and debug 40), I get [cdr_odbc.so] => (ODBC CDR Backend) == Parsing '/etc/asterisk/cdr_odbc.conf': Found *CLI> cdr status CDR logging: enabled CDR mode: simple CDR registered backend:

...nel = odbcConnect("crtedb", uid = "uleopold") > channel RODB Connection 1 Details: case=tolower DSN=crtedb DATABASE=valid SERVER=10.3.1.91 PORT=5432 SSLMODE=prefer UID=uleopold PWD=****** ReadOnly=Yes FakeOidIndex=No ShowOidColumn=No RowVersioning=No ShowSystemTables=No ConnSettings= Fetch=100 Socket=8192 UnknownSizes=0 MaxVarcharSize=254 MaxLongVarcharSize=8190 Debug=0 CommLog=0 Optimizer=1 Ksqo=1 UseDeclareFetch=0 TextAsLongVarchar=1 UnknownsAsLongVarchar=0 BoolsAsChar=1 Parse=0 CancelAsFreeStmt=0 ExtraSysTablePrefixes=d...