ODBC drivers, and perl and dbiproxy not working

From: <danparker276_at_my-deja.com>
Date: 2000/05/10
Message-ID: <8fcnem$523$1@nnrp1.deja.com>#1/1

I can't get connected to a oracle database, I'm using perl dbiproxy, and it's going through the ODBC drivers. I can connect to a different machine on the same NT network, but for some reason this one database won't let me in. The error messages I get say it can't find the source server

my perl error message says:"
Cannot log in to DBI::ProxyServer: Refused by server: User danp is not permitted to connect. at C:/Perl/site/lib/RPC/PlClient.pm line 91. "
which means is found the dbiproxy connection, but doesn't give me permission. Are there any ODBC permissions or something. The SOURCE name is NAPA or napa.kachinanet.com (would '.'s in the name have anything to do with it?)

I did a trace and the error's I get back are

perl -x -S "dbi 176:1ae	ENTER SQLAllocEnv
		HENV *              0x00eb2bd4

perl -x -S "dbi 176:1ae	EXIT  SQLAllocEnv  with return code 0


(SQL_SUCCESS)

		HENV *              0x00eb2bd4 ( 0x01241440)

perl -x -S "dbi 176:1ae	ENTER SQLAllocConnect
		HENV                0x01241440
		HDBC *              0x00eb3158

perl -x -S "dbi 176:1ae	EXIT  SQLAllocConnect  with return code 0


(SQL_SUCCESS)

		HENV                0x01241440
		HDBC *              0x00eb3158 ( 0x012414e8)

perl -x -S "dbi 176:1ae	ENTER SQLDriverConnectW
		HDBC                0x012414e8
		HWND                0x00000000
		WCHAR *             0x1f4be068 [      -3] "******\ 0"
		SWORD                       -3
		WCHAR *             0x1f4be068
		SWORD                        8
		SWORD *             0x00000000
		UWORD                        0 <SQL_DRIVER_NOPROMPT>

perl -x -S "dbi 176:1ae	EXIT  SQLDriverConnectW  with return code -1


(SQL_ERROR)

		HDBC                0x012414e8
		HWND                0x00000000
		WCHAR *             0x1f4be068 [      -3] "******\ 0"
		SWORD                       -3
		WCHAR *             0x1f4be068
		SWORD                        8
		SWORD *             0x00000000
		UWORD                        0 <SQL_DRIVER_NOPROMPT>

		DIAG [IM002] [Microsoft][ODBC Driver Manager] Data

source name not found and no default driver specified (0)

                DIAG [01S00] [Microsoft][ODBC Driver Manager] Invalid connection string attribute (0)

perl -x -S "dbi 176:1ae	ENTER SQLConnectW
		HDBC                0x012414e8
		WCHAR *             0x01242678 [       4] "napa"
		SWORD                        4
		WCHAR *             0x1f4be068 [      -3] "******\ 0"
		SWORD                       -3
		WCHAR *             0x1f4be068 [      -3] "******\ 0"
		SWORD                       -3

perl -x -S "dbi 176:1ae	EXIT  SQLConnectW  with return code -1


(SQL_ERROR)

		HDBC                0x012414e8
		WCHAR *             0x01242678 [       4] "napa"
		SWORD                        4
		WCHAR *             0x1f4be068 [      -3] "******\ 0"
		SWORD                       -3
		WCHAR *             0x1f4be068 [      -3] "******\ 0"
		SWORD                       -3

		DIAG [IM002] [Microsoft][ODBC Driver Manager] Data

source name not found and no default driver specified (0)

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed May 10 2000 - 00:00:00 CDT