DBI dbiproxy and ODBC connection isn't working 
Author Message
 DBI dbiproxy and ODBC connection isn't working

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.*-*-*.com/
Before you buy.



Sun, 27 Oct 2002 03:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. MS Access, Linux, DBI, DBD::ODBC, Easysoft's ODBC-ODBC Bridge

2. Valid SQL Statement doesn't work in DBI::ODBC

3. Something isn't working, and I can't figure it out

4. Perl isn't intended to be what it isn't (Was: read(THIS) || die)

5. Get a Database connection without DBI or Win32::ODBC

6. DBI+DBD::ODBC+MS Access connection error

7. Web Connection Failure with DBI::ODBC and FileMaker

8. DBI:ODBC connection pooling

9. Chat2.pl isn't working properly

10. Infobot isn't working

11. Comma operator: why isn't this working?

12. chdir isn't working when using a variable for the directory

 

 
Powered by phpBB® Forum Software