Connecting Tech Pros Worldwide Help | Site Map

C# Executable File Name Length Causing ODBC Exception

Newbie
 
Join Date: Oct 2007
Location: Charlotte, North Carolina, USA
Posts: 5
#1: Oct 2 '08
I have a C# project that connects to an Oracle server using ODBC

Everything works fine if I keep the file name length less than 23 characters (including ".exe")

If the executable file name exceeds 23 characters this I get the following oracle exceptions

ORA-00604: error occurred at recursive SQL level 1
ORA-06502: PL/SQL: numeric or value error
ORA-06512: at line 24

This behaviour is observed only for a particular oracle database server .

I have tried changing the connection string and other such options but nothing works.
Plater's Avatar
Moderator
 
Join Date: Apr 2007
Location: New England
Posts: 7,149
#2: Oct 2 '08

re: C# Executable File Name Length Causing ODBC Exception


You mean the length of the name of your program determines if you can connect to oracle or not?
Newbie
 
Join Date: Oct 2007
Location: Charlotte, North Carolina, USA
Posts: 5
#3: Oct 2 '08

re: C# Executable File Name Length Causing ODBC Exception


Yes .. I know that sounds very wierd...But thats what has been observed
Newbie
 
Join Date: Oct 2007
Location: Charlotte, North Carolina, USA
Posts: 5
#4: Oct 2 '08

re: C# Executable File Name Length Causing ODBC Exception


I beleive it is on the Oracle side, since the same code has no problems in connecting to a different oracle server
Plater's Avatar
Moderator
 
Join Date: Apr 2007
Location: New England
Posts: 7,149
#5: Oct 2 '08

re: C# Executable File Name Length Causing ODBC Exception


Perhaps different versions of oracle are running? Or on a different operating system?
Newbie
 
Join Date: Oct 2007
Location: Charlotte, North Carolina, USA
Posts: 5
#6: Oct 2 '08

re: C# Executable File Name Length Causing ODBC Exception


The app was running for a long time on that server .and suddenly stopped running because of this error.

I am thinkin an update patch or an antivirus patch on the server may have caused this error
Plater's Avatar
Moderator
 
Join Date: Apr 2007
Location: New England
Posts: 7,149
#7: Oct 2 '08

re: C# Executable File Name Length Causing ODBC Exception


Perhaps they restructed some directories on that server causing the full path+filename string length to be outside of oracle capabilities?
Reply