Hy people, i hava a problem with add a SP with a tempory table inside in a
SQLDataAdapter in VS .NET 2003. Is this the point of sintax that occur the
error:
(...)
if object_id('tempdb.dbo.#tempprod') is not null drop table #tempprod
create table #tempprod (seq int, sit varchar(6),Atividade varchar(20),
historico varchar(6))
EXEC SP_FI_ListToTable '#tempprod','atividade','^',@.Atividade
EXEC SP_FI_ListToTable '#tempprod','sit','^', @.SituacaoProposta
EXEC SP_FI_ListToTable '#tempprod','historico','^', @.HistoricoFinanceiro
(...)
The error is "Invalid object name #tempprod" and this occurs 3 times.
Is this the full code of the SP SP_FI_ListToTable:
"ALTER PROC SP_FI_ListToTable
@.table varchar(12),
@.campo varchar(12),
@.sep char,
@.texto varchar(5000)
as
set nocount on
declare @.sub varchar(100)
declare @.posini int
declare @.seq int
select @.seq = 1
while len(@.texto) > 0
begin
select @.posini = charindex(@.sep,@.texto)
if @.posini > 0
begin
select @.sub = LEFT(@.texto,@.posini-1)
select @.texto = substring(@.texto,@.posini+1,len(@.texto))
end
else
begin
select @.sub = @.texto
select @.texto = ''
end
exec (' if exists(select * from ' + @.table + ' where seq = ' + @.seq + ')
'+
' update '+@.table + ' set ' + @.campo + ' = '''+@.sub+''' where seq =
' + @.seq +
' else ' +
' insert into '+@.table + ' (seq,'+@.campo+') values (' + @.seq +
','''+@.sub+''')')
select @.seq = @.seq + 1
End
set nocount off
return "
Tks for help.
Bruno Renato
C# .NET DeveloperHi
It is better if you do not call your stored procedure sp_...
I have not tried this through the adapter, but...
Your temporary table will be dropped when it goes out of scope, so testing
the existance should not be necessary.
You will not need to use dynamic SQL if you only access the same temporary
table from a procedure that creates the temporary table. You may want to put
begin/end around your batch.
This works fine:
DECLARE @.Atividade varchar(5000)
DECLARE @.SituacaoProposta varchar(5000)
DECLARE @.HistoricoFinanceiro varchar(5000)
SELECT @.Atividade = 'Un',
@.SituacaoProposta = 'dos',
@.HistoricoFinanceiro= 'tres'
CREATE TABLE #tempprod (seq int, sit varchar(6),Atividade varchar(20),
historico varchar(6))
EXEC uSP_FI_ListToTable '#tempprod','atividade','^',@.Atividade
EXEC uSP_FI_ListToTable '#tempprod','sit','^', @.SituacaoProposta
EXEC uSP_FI_ListToTable '#tempprod','historico','^', @.HistoricoFinanceiro
SELECT * FROM #tempprod
DROP TABLE #tempprod
You may want to look at:
http://www.sommarskog.se/arrays-in-sql.html
John
"Bruno Renato" wrote:
> Hy people, i hava a problem with add a SP with a tempory table inside in a
> SQLDataAdapter in VS .NET 2003. Is this the point of sintax that occur the
> error:
> (...)
> if object_id('tempdb.dbo.#tempprod') is not null drop table #tempprod
> create table #tempprod (seq int, sit varchar(6),Atividade varchar(20),
> historico varchar(6))
> EXEC SP_FI_ListToTable '#tempprod','atividade','^',@.Atividade
> EXEC SP_FI_ListToTable '#tempprod','sit','^', @.SituacaoProposta
> EXEC SP_FI_ListToTable '#tempprod','historico','^', @.HistoricoFinancei
ro
> (...)
> The error is "Invalid object name #tempprod" and this occurs 3 times.
> Is this the full code of the SP SP_FI_ListToTable:
> "ALTER PROC SP_FI_ListToTable
> @.table varchar(12),
> @.campo varchar(12),
> @.sep char,
> @.texto varchar(5000)
> as
> set nocount on
> declare @.sub varchar(100)
> declare @.posini int
> declare @.seq int
> select @.seq = 1
> while len(@.texto) > 0
> begin
> select @.posini = charindex(@.sep,@.texto)
> if @.posini > 0
> begin
> select @.sub = LEFT(@.texto,@.posini-1)
> select @.texto = substring(@.texto,@.posini+1,len(@.texto))
> end
> else
> begin
> select @.sub = @.texto
> select @.texto = ''
> end
> exec (' if exists(select * from ' + @.table + ' where seq = ' + @.seq + '
)
> '+
> ' update '+@.table + ' set ' + @.campo + ' = '''+@.sub+''' where seq
=
> ' + @.seq +
> ' else ' +
> ' insert into '+@.table + ' (seq,'+@.campo+') values (' + @.seq +
> ','''+@.sub+''')')
> select @.seq = @.seq + 1
> End
> set nocount off
> return "
> Tks for help.
>
> Bruno Renato
> C# .NET Developer
Saturday, February 25, 2012
problems with a script, could not find stored procedure
Hi all:
I am new to SQL and I am having a hard time trying to figure out the
following error:
Msg 2812, Level 16, State 62, Server PANCHO, Line 10
Could not find stored procedure 'deletej'.
My code is as follows:
*****file name: jpak.sq
use spjdatabase;
drop procedure insertj;
drop procedure deletej;
create procedure insertj @.jnum varchar(5), @.jname varchar(20), @.jcity
varchar(20), @.jInsert integer output as declare @.jInSupp integer;
select @.jInSupp = count (*) from J where J# = @.jnum;
if (@.jInSupp = 1)
begin
set @.jInsert = -1;
return 0;
end;
else return -1;
insert into J values(@.jnum, @.jname, @.jcity);
set @.jInsert = 0;
create procedure deletej @.jnum varchar(5), @.jDelete integer output as
declare @.jDelSupp integer;
select @.jDelSupp = count (*) from J where J# = @.jnum;
if (@.jDelSupp = 1)
begin
set @.jDelete = -1;
return 0;
end;
else return -1;
delete from J where J# = @.jnum;
set @.jDelete = 0;
go
*****file name: invokejpak.sql
use spjdatabase;
declare @.eInsert integer;
declare @.eDelete integer;
execute insertj 'J8', 'Wrench', 'Miami', @.eInsert output;
if @.eInsert = -1
print 'Insert Rejected' else
print 'Insert Accepted';
execute deletej 'J8', @.eDelete output;
if @.eDelete = -1
print 'Delete Rejected' else
print 'Delete Accepted';
go
*****file name: go.bat
osql -n -E -i invokejpak.sql
I run this by going to the command prompt and navigating to the
directory whwre I have these files, then just type go.exe. Any help will
be greatly appreciated.
FC
Hi
After a USE database you need to issue a GO statement.
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"FC" wrote:
> Hi all:
> I am new to SQL and I am having a hard time trying to figure out the
> following error:
> Msg 2812, Level 16, State 62, Server PANCHO, Line 10
> Could not find stored procedure 'deletej'.
> My code is as follows:
> *****file name: jpak.sq
> use spjdatabase;
> drop procedure insertj;
> drop procedure deletej;
> create procedure insertj @.jnum varchar(5), @.jname varchar(20), @.jcity
> varchar(20), @.jInsert integer output as declare @.jInSupp integer;
> select @.jInSupp = count (*) from J where J# = @.jnum;
> if (@.jInSupp = 1)
> begin
> set @.jInsert = -1;
> return 0;
> end;
> else return -1;
> insert into J values(@.jnum, @.jname, @.jcity);
> set @.jInsert = 0;
> create procedure deletej @.jnum varchar(5), @.jDelete integer output as
> declare @.jDelSupp integer;
> select @.jDelSupp = count (*) from J where J# = @.jnum;
> if (@.jDelSupp = 1)
> begin
> set @.jDelete = -1;
> return 0;
> end;
> else return -1;
> delete from J where J# = @.jnum;
> set @.jDelete = 0;
> go
> *****file name: invokejpak.sql
> use spjdatabase;
> declare @.eInsert integer;
> declare @.eDelete integer;
> execute insertj 'J8', 'Wrench', 'Miami', @.eInsert output;
> if @.eInsert = -1
> print 'Insert Rejected' else
> print 'Insert Accepted';
> execute deletej 'J8', @.eDelete output;
> if @.eDelete = -1
> print 'Delete Rejected' else
> print 'Delete Accepted';
> go
> *****file name: go.bat
> osql -n -E -i invokejpak.sql
> I run this by going to the command prompt and navigating to the
> directory whwre I have these files, then just type go.exe. Any help will
> be greatly appreciated.
> FC
>
|||hi,
FC wrote:
> Hi all:
> I am new to SQL and I am having a hard time trying to figure out the
> following error:
> Msg 2812, Level 16, State 62, Server PANCHO, Line 10
> Could not find stored procedure 'deletej'.
> ....
> osql -n -E -i invokejpak.sql
> I run this by going to the command prompt and navigating to the
> directory whwre I have these files, then just type go.exe. Any help
> will be greatly appreciated.
>
it can even depends on unresolved object owner...
suppose you executed the "file name: jpak.sq", that creates the [insertj]
and [deletej] procedures with a ddl_admin member... as both procedures are
not qualified with a specific owner name they will be owned by the creator
user, say [L_ddl]... and their full qualified name actually is
[L_ddl].[insertj] and [L_ddl].[deletej]..
then you log in
> osql -n -E -i invokejpak.sql
using WinNT authentication as another user... say (for simplicity I used a
standard SQL Server login associated to) [L_user] user...
executing the script the way you are doing, it try to resolve [insertj] and
[deletej] objects as owned by [L_user] and, if no match is present (and of
course no one will) as owned by [dbo]... here again no match is found and
executing the script will result in something like
Server: Msg 2812, Level 16, State 62, Line 4
Could not find stored procedure 'insertj'.
Insert Accepted
Server: Msg 2812, Level 16, State 62, Line 9
Could not find stored procedure 'deletej'.
Delete Accepted
this way you should learn you always have to reference objects including the
corresponding owner and create them specifying it like
CREATE PROCEDURE dbo.procedure
.....
EXECUTE dbo.insertj 'J8', 'Wrench', 'Miami', @.eInsert output
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.14.0 - DbaMgr ver 0.59.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||I was having that issue also. Not sure if you figured it out. What solved it for me was changing the our connection
provider from Microsoft OLE DB Provider for ODBC Drivers to be Microsoft OLE DB Provider for SQL Server. Hope that helps.
I am new to SQL and I am having a hard time trying to figure out the
following error:
Msg 2812, Level 16, State 62, Server PANCHO, Line 10
Could not find stored procedure 'deletej'.
My code is as follows:
*****file name: jpak.sq
use spjdatabase;
drop procedure insertj;
drop procedure deletej;
create procedure insertj @.jnum varchar(5), @.jname varchar(20), @.jcity
varchar(20), @.jInsert integer output as declare @.jInSupp integer;
select @.jInSupp = count (*) from J where J# = @.jnum;
if (@.jInSupp = 1)
begin
set @.jInsert = -1;
return 0;
end;
else return -1;
insert into J values(@.jnum, @.jname, @.jcity);
set @.jInsert = 0;
create procedure deletej @.jnum varchar(5), @.jDelete integer output as
declare @.jDelSupp integer;
select @.jDelSupp = count (*) from J where J# = @.jnum;
if (@.jDelSupp = 1)
begin
set @.jDelete = -1;
return 0;
end;
else return -1;
delete from J where J# = @.jnum;
set @.jDelete = 0;
go
*****file name: invokejpak.sql
use spjdatabase;
declare @.eInsert integer;
declare @.eDelete integer;
execute insertj 'J8', 'Wrench', 'Miami', @.eInsert output;
if @.eInsert = -1
print 'Insert Rejected' else
print 'Insert Accepted';
execute deletej 'J8', @.eDelete output;
if @.eDelete = -1
print 'Delete Rejected' else
print 'Delete Accepted';
go
*****file name: go.bat
osql -n -E -i invokejpak.sql
I run this by going to the command prompt and navigating to the
directory whwre I have these files, then just type go.exe. Any help will
be greatly appreciated.
FC
Hi
After a USE database you need to issue a GO statement.
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"FC" wrote:
> Hi all:
> I am new to SQL and I am having a hard time trying to figure out the
> following error:
> Msg 2812, Level 16, State 62, Server PANCHO, Line 10
> Could not find stored procedure 'deletej'.
> My code is as follows:
> *****file name: jpak.sq
> use spjdatabase;
> drop procedure insertj;
> drop procedure deletej;
> create procedure insertj @.jnum varchar(5), @.jname varchar(20), @.jcity
> varchar(20), @.jInsert integer output as declare @.jInSupp integer;
> select @.jInSupp = count (*) from J where J# = @.jnum;
> if (@.jInSupp = 1)
> begin
> set @.jInsert = -1;
> return 0;
> end;
> else return -1;
> insert into J values(@.jnum, @.jname, @.jcity);
> set @.jInsert = 0;
> create procedure deletej @.jnum varchar(5), @.jDelete integer output as
> declare @.jDelSupp integer;
> select @.jDelSupp = count (*) from J where J# = @.jnum;
> if (@.jDelSupp = 1)
> begin
> set @.jDelete = -1;
> return 0;
> end;
> else return -1;
> delete from J where J# = @.jnum;
> set @.jDelete = 0;
> go
> *****file name: invokejpak.sql
> use spjdatabase;
> declare @.eInsert integer;
> declare @.eDelete integer;
> execute insertj 'J8', 'Wrench', 'Miami', @.eInsert output;
> if @.eInsert = -1
> print 'Insert Rejected' else
> print 'Insert Accepted';
> execute deletej 'J8', @.eDelete output;
> if @.eDelete = -1
> print 'Delete Rejected' else
> print 'Delete Accepted';
> go
> *****file name: go.bat
> osql -n -E -i invokejpak.sql
> I run this by going to the command prompt and navigating to the
> directory whwre I have these files, then just type go.exe. Any help will
> be greatly appreciated.
> FC
>
|||hi,
FC wrote:
> Hi all:
> I am new to SQL and I am having a hard time trying to figure out the
> following error:
> Msg 2812, Level 16, State 62, Server PANCHO, Line 10
> Could not find stored procedure 'deletej'.
> ....
> osql -n -E -i invokejpak.sql
> I run this by going to the command prompt and navigating to the
> directory whwre I have these files, then just type go.exe. Any help
> will be greatly appreciated.
>
it can even depends on unresolved object owner...
suppose you executed the "file name: jpak.sq", that creates the [insertj]
and [deletej] procedures with a ddl_admin member... as both procedures are
not qualified with a specific owner name they will be owned by the creator
user, say [L_ddl]... and their full qualified name actually is
[L_ddl].[insertj] and [L_ddl].[deletej]..
then you log in
> osql -n -E -i invokejpak.sql
using WinNT authentication as another user... say (for simplicity I used a
standard SQL Server login associated to) [L_user] user...
executing the script the way you are doing, it try to resolve [insertj] and
[deletej] objects as owned by [L_user] and, if no match is present (and of
course no one will) as owned by [dbo]... here again no match is found and
executing the script will result in something like
Server: Msg 2812, Level 16, State 62, Line 4
Could not find stored procedure 'insertj'.
Insert Accepted
Server: Msg 2812, Level 16, State 62, Line 9
Could not find stored procedure 'deletej'.
Delete Accepted
this way you should learn you always have to reference objects including the
corresponding owner and create them specifying it like
CREATE PROCEDURE dbo.procedure
.....
EXECUTE dbo.insertj 'J8', 'Wrench', 'Miami', @.eInsert output
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.14.0 - DbaMgr ver 0.59.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||I was having that issue also. Not sure if you figured it out. What solved it for me was changing the our connection
provider from Microsoft OLE DB Provider for ODBC Drivers to be Microsoft OLE DB Provider for SQL Server. Hope that helps.
Problems with a JET-ODBC-Connection and Access97-Runtime
I have a very strange problem with a JET-ODBC-Connection.
Using Access97-Runtime, we connect the table with a
DSN-less-ODBC-Connection to SQLServer 2000 SP3.
The Application runs on a Windows Server 2003 Terminal-Server with
CITRIX Metaframe.
Office 2003 is also installed (no Access2003)
And now the problem:
When our application is installed anew, the ODBC-Connection works fine.
When I start any Office2003-Application like Winword, the system files
MSJINT35.DLL and MSJTER35.DLL are changed. (I used ashampoo Uninstaller
Suite to check this issue).
Afterwards, our Application doesn't run anymore, the Application quits
without any error.
If I copy the MSJINT35.DLL anew from the install-directory, our
application runs again correctly.
The strange thing is, that the "changed" MSJINT35.DLL is exactly the
same as the original file. Version, Metadata, Language, Filesize, and
even a Hex-based-compare result that the files are identically.
Nevertheless, a copy of the file into system32 is a workaround to fix
the problem for a few hours.
Does anyone has any idea? PLEASE HELP!
How are you installing the app? I use Wise Install Builder, which installs
the Access 97 runtime into it's own folder - C:\Program Files\Access 97
Runtime. It installs the DLLs in question into that folder, too. The reason
being - when an app looks for DLL's it starts with the folder the app
started in, then looks in the folders in the PATH environment variable (e.g.
System32). You could probably solve your problem by having your installer
put the DLLs in question into the Runtime folder.
"Andreas Lauffer" <alweb01@.online.de> wrote in message
news:1132133394.166634.268470@.z14g2000cwz.googlegr oups.com...
> I have a very strange problem with a JET-ODBC-Connection.
> Using Access97-Runtime, we connect the table with a
> DSN-less-ODBC-Connection to SQLServer 2000 SP3.
> The Application runs on a Windows Server 2003 Terminal-Server with
> CITRIX Metaframe.
> Office 2003 is also installed (no Access2003)
> And now the problem:
> ----
> When our application is installed anew, the ODBC-Connection works fine.
> When I start any Office2003-Application like Winword, the system files
> MSJINT35.DLL and MSJTER35.DLL are changed. (I used ashampoo Uninstaller
> Suite to check this issue).
> Afterwards, our Application doesn't run anymore, the Application quits
> without any error.
> If I copy the MSJINT35.DLL anew from the install-directory, our
> application runs again correctly.
> The strange thing is, that the "changed" MSJINT35.DLL is exactly the
> same as the original file. Version, Metadata, Language, Filesize, and
> even a Hex-based-compare result that the files are identically.
> Nevertheless, a copy of the file into system32 is a workaround to fix
> the problem for a few hours.
> ----
> Does anyone has any idea? PLEASE HELP!
>
Using Access97-Runtime, we connect the table with a
DSN-less-ODBC-Connection to SQLServer 2000 SP3.
The Application runs on a Windows Server 2003 Terminal-Server with
CITRIX Metaframe.
Office 2003 is also installed (no Access2003)
And now the problem:
When our application is installed anew, the ODBC-Connection works fine.
When I start any Office2003-Application like Winword, the system files
MSJINT35.DLL and MSJTER35.DLL are changed. (I used ashampoo Uninstaller
Suite to check this issue).
Afterwards, our Application doesn't run anymore, the Application quits
without any error.
If I copy the MSJINT35.DLL anew from the install-directory, our
application runs again correctly.
The strange thing is, that the "changed" MSJINT35.DLL is exactly the
same as the original file. Version, Metadata, Language, Filesize, and
even a Hex-based-compare result that the files are identically.
Nevertheless, a copy of the file into system32 is a workaround to fix
the problem for a few hours.
Does anyone has any idea? PLEASE HELP!
How are you installing the app? I use Wise Install Builder, which installs
the Access 97 runtime into it's own folder - C:\Program Files\Access 97
Runtime. It installs the DLLs in question into that folder, too. The reason
being - when an app looks for DLL's it starts with the folder the app
started in, then looks in the folders in the PATH environment variable (e.g.
System32). You could probably solve your problem by having your installer
put the DLLs in question into the Runtime folder.
"Andreas Lauffer" <alweb01@.online.de> wrote in message
news:1132133394.166634.268470@.z14g2000cwz.googlegr oups.com...
> I have a very strange problem with a JET-ODBC-Connection.
> Using Access97-Runtime, we connect the table with a
> DSN-less-ODBC-Connection to SQLServer 2000 SP3.
> The Application runs on a Windows Server 2003 Terminal-Server with
> CITRIX Metaframe.
> Office 2003 is also installed (no Access2003)
> And now the problem:
> ----
> When our application is installed anew, the ODBC-Connection works fine.
> When I start any Office2003-Application like Winword, the system files
> MSJINT35.DLL and MSJTER35.DLL are changed. (I used ashampoo Uninstaller
> Suite to check this issue).
> Afterwards, our Application doesn't run anymore, the Application quits
> without any error.
> If I copy the MSJINT35.DLL anew from the install-directory, our
> application runs again correctly.
> The strange thing is, that the "changed" MSJINT35.DLL is exactly the
> same as the original file. Version, Metadata, Language, Filesize, and
> even a Hex-based-compare result that the files are identically.
> Nevertheless, a copy of the file into system32 is a workaround to fix
> the problem for a few hours.
> ----
> Does anyone has any idea? PLEASE HELP!
>
Problems with a JET-ODBC-Connection and Access97-Runtime
I have a very strange problem with a JET-ODBC-Connection.
Using Access97-Runtime, we connect the table with a
DSN-less-ODBC-Connection to SQLServer 2000 SP3.
The Application runs on a Windows Server 2003 Terminal-Server with
CITRIX Metaframe.
Office 2003 is also installed (no Access2003)
And now the problem:
----
When our application is installed anew, the ODBC-Connection works fine.
When I start any Office2003-Application like Winword, the system files
MSJINT35.DLL and MSJTER35.DLL are changed. (I used ashampoo Uninstaller
Suite to check this issue).
Afterwards, our Application doesn't run anymore, the Application quits
without any error.
If I copy the MSJINT35.DLL anew from the install-directory, our
application runs again correctly.
The strange thing is, that the "changed" MSJINT35.DLL is exactly the
same as the original file. Version, Metadata, Language, Filesize, and
even a Hex-based-compare result that the files are identically.
Nevertheless, a copy of the file into system32 is a workaround to fix
the problem for a few hours.
----
Does anyone has any idea? PLEASE HELP!How are you installing the app? I use Wise Install Builder, which installs
the Access 97 runtime into it's own folder - C:\Program Files\Access 97
Runtime. It installs the DLLs in question into that folder, too. The reason
being - when an app looks for DLL's it starts with the folder the app
started in, then looks in the folders in the PATH environment variable (e.g.
System32). You could probably solve your problem by having your installer
put the DLLs in question into the Runtime folder.
"Andreas Lauffer" <alweb01@.online.de> wrote in message
news:1132133394.166634.268470@.z14g2000cwz.googlegroups.com...
> I have a very strange problem with a JET-ODBC-Connection.
> Using Access97-Runtime, we connect the table with a
> DSN-less-ODBC-Connection to SQLServer 2000 SP3.
> The Application runs on a Windows Server 2003 Terminal-Server with
> CITRIX Metaframe.
> Office 2003 is also installed (no Access2003)
> And now the problem:
> ----
> When our application is installed anew, the ODBC-Connection works fine.
> When I start any Office2003-Application like Winword, the system files
> MSJINT35.DLL and MSJTER35.DLL are changed. (I used ashampoo Uninstaller
> Suite to check this issue).
> Afterwards, our Application doesn't run anymore, the Application quits
> without any error.
> If I copy the MSJINT35.DLL anew from the install-directory, our
> application runs again correctly.
> The strange thing is, that the "changed" MSJINT35.DLL is exactly the
> same as the original file. Version, Metadata, Language, Filesize, and
> even a Hex-based-compare result that the files are identically.
> Nevertheless, a copy of the file into system32 is a workaround to fix
> the problem for a few hours.
> ----
> Does anyone has any idea? PLEASE HELP!
>
Using Access97-Runtime, we connect the table with a
DSN-less-ODBC-Connection to SQLServer 2000 SP3.
The Application runs on a Windows Server 2003 Terminal-Server with
CITRIX Metaframe.
Office 2003 is also installed (no Access2003)
And now the problem:
----
When our application is installed anew, the ODBC-Connection works fine.
When I start any Office2003-Application like Winword, the system files
MSJINT35.DLL and MSJTER35.DLL are changed. (I used ashampoo Uninstaller
Suite to check this issue).
Afterwards, our Application doesn't run anymore, the Application quits
without any error.
If I copy the MSJINT35.DLL anew from the install-directory, our
application runs again correctly.
The strange thing is, that the "changed" MSJINT35.DLL is exactly the
same as the original file. Version, Metadata, Language, Filesize, and
even a Hex-based-compare result that the files are identically.
Nevertheless, a copy of the file into system32 is a workaround to fix
the problem for a few hours.
----
Does anyone has any idea? PLEASE HELP!How are you installing the app? I use Wise Install Builder, which installs
the Access 97 runtime into it's own folder - C:\Program Files\Access 97
Runtime. It installs the DLLs in question into that folder, too. The reason
being - when an app looks for DLL's it starts with the folder the app
started in, then looks in the folders in the PATH environment variable (e.g.
System32). You could probably solve your problem by having your installer
put the DLLs in question into the Runtime folder.
"Andreas Lauffer" <alweb01@.online.de> wrote in message
news:1132133394.166634.268470@.z14g2000cwz.googlegroups.com...
> I have a very strange problem with a JET-ODBC-Connection.
> Using Access97-Runtime, we connect the table with a
> DSN-less-ODBC-Connection to SQLServer 2000 SP3.
> The Application runs on a Windows Server 2003 Terminal-Server with
> CITRIX Metaframe.
> Office 2003 is also installed (no Access2003)
> And now the problem:
> ----
> When our application is installed anew, the ODBC-Connection works fine.
> When I start any Office2003-Application like Winword, the system files
> MSJINT35.DLL and MSJTER35.DLL are changed. (I used ashampoo Uninstaller
> Suite to check this issue).
> Afterwards, our Application doesn't run anymore, the Application quits
> without any error.
> If I copy the MSJINT35.DLL anew from the install-directory, our
> application runs again correctly.
> The strange thing is, that the "changed" MSJINT35.DLL is exactly the
> same as the original file. Version, Metadata, Language, Filesize, and
> even a Hex-based-compare result that the files are identically.
> Nevertheless, a copy of the file into system32 is a workaround to fix
> the problem for a few hours.
> ----
> Does anyone has any idea? PLEASE HELP!
>
Problems with ~large~ table
Hello everyone,
I have a little problem with a Table im using to store notes on articles:
Design:
id - int - identity (auto)
Title - varchar(50)
currently the table is containing ~12000 datasets (not much if you ask me).
Problem:
If I try to edit/add recordsets, I get a timeout.
In Access:
'ODBC Error adding recordset'
In SQL
- None - Timeout (I Quit after 2.5 minutes of INSERT query)
does anybody know a solution to this problem?
Thanks for helpin'!In Addition to the upper text:
Strangely it works sometimes - I know that this should be that slow, the textfield is indexed - w/o duplicates - but i have used the same structure for other tables (with over 5 times as much data) and there it works..
Is it possible that indexing w/o duplicates causes this problems?|||Have you tried inserting via Enterprise Mgr to see if you get the same error?
Have you seen what's happening through, for instance, SQL Profiler?|||I've tried trough Access, Acced direct table edit, SQL Query Analyzer - all have the same problem (except that QA doesn't have a set timeout)...|||Which type of index are you using ? In your previous instances where you had no problems, did you have the index using the "without duplicates" option ?|||Originally posted by rnealejr
Which type of index are you using ? In your previous instances where you had no problems, did you have the index using the "without duplicates" option ?
In the troubled table i'm using index: w/o duplicates - in the not troubled table the row is indexed but with duplicates...
another problem is - I currently cannot change this, because I dont have enough space for the transaction log to save 15000-50000 rows (indexes) :mad:
I have a little problem with a Table im using to store notes on articles:
Design:
id - int - identity (auto)
Title - varchar(50)
currently the table is containing ~12000 datasets (not much if you ask me).
Problem:
If I try to edit/add recordsets, I get a timeout.
In Access:
'ODBC Error adding recordset'
In SQL
- None - Timeout (I Quit after 2.5 minutes of INSERT query)
does anybody know a solution to this problem?
Thanks for helpin'!In Addition to the upper text:
Strangely it works sometimes - I know that this should be that slow, the textfield is indexed - w/o duplicates - but i have used the same structure for other tables (with over 5 times as much data) and there it works..
Is it possible that indexing w/o duplicates causes this problems?|||Have you tried inserting via Enterprise Mgr to see if you get the same error?
Have you seen what's happening through, for instance, SQL Profiler?|||I've tried trough Access, Acced direct table edit, SQL Query Analyzer - all have the same problem (except that QA doesn't have a set timeout)...|||Which type of index are you using ? In your previous instances where you had no problems, did you have the index using the "without duplicates" option ?|||Originally posted by rnealejr
Which type of index are you using ? In your previous instances where you had no problems, did you have the index using the "without duplicates" option ?
In the troubled table i'm using index: w/o duplicates - in the not troubled table the row is indexed but with duplicates...
another problem is - I currently cannot change this, because I dont have enough space for the transaction log to save 15000-50000 rows (indexes) :mad:
Problems with [Microsoft][ODBC driver for Oracle][Oracle]
Hello all,
I have a VB application that is running fine in prod on a box without
the .net framework installed. The app queries a Oracle 8.1.7 64 bit
database. It uses the Microsoft ODBC Driver for Oracle and it works
like a champ. However I am adding some enhancements to this application
and on my local machine I have the the .NET framework installed of
course. And I am finding that my simple select statement below is
failing.
Select * From is_sec_ipass Where TO_CHAR(start_time,'yyyymm') =
'200505' And type = 'I'
I looked at the driver version on the production box as well as my box
and this is what I have found.
Prd driver = 2.573.7713.00
my box = 2.573.7713.00
Is there something I am missing here? I even stripped down the query to
this SELECT * FROM ISSEC_DB.IS_SEC_IPASS and it still bombs out.
Here is the error I get.
Error (-2147217900): [Microsoft][ODBC driver for
Oracle][Oracle]ORA-00900: invalid SQL statement
This is just killing me. Any insight you have would be great.
Thanks,
Pitdog
Sorry I messed up on the driver version numbers
Prd driver = 2.573.7713.00
my box = 2.573.9030.00
They are different.
|||I had the same problem for the past few days. I think it has to do more
with the Oracle client installed on the machine.
I had installed Orcale 9i client on the user machine and tried to run
the vb application. I was getting the same error. So I uninstalled the
Oracle 9i client and installed Oracle 8.0 client. And as I had guessed,
the application ran perfectly fine. Now I am installing Oracle 8.0
client on each user machine before distributing the application.
Looks like the Microsoft ODBC oracle driver cannot work in sync with
Oracle 9i client. I would recommend you try uninstalling Oracle 9i and
install a previous version.
*** Sent via Developersdex http://www.codecomments.com ***
|||Hey Lucky Thanks for the help. I will check it out tomorrow in the am.
Fingers crossed.
|||Hey Lucky no dice on this. The DB is a 8.1 db and that client I am
using is the correct one. I have opened a ticket with the DBA's here I
am hoping they can shed some light on this issue. I will post back if I
find an answer.
PD
I have a VB application that is running fine in prod on a box without
the .net framework installed. The app queries a Oracle 8.1.7 64 bit
database. It uses the Microsoft ODBC Driver for Oracle and it works
like a champ. However I am adding some enhancements to this application
and on my local machine I have the the .NET framework installed of
course. And I am finding that my simple select statement below is
failing.
Select * From is_sec_ipass Where TO_CHAR(start_time,'yyyymm') =
'200505' And type = 'I'
I looked at the driver version on the production box as well as my box
and this is what I have found.
Prd driver = 2.573.7713.00
my box = 2.573.7713.00
Is there something I am missing here? I even stripped down the query to
this SELECT * FROM ISSEC_DB.IS_SEC_IPASS and it still bombs out.
Here is the error I get.
Error (-2147217900): [Microsoft][ODBC driver for
Oracle][Oracle]ORA-00900: invalid SQL statement
This is just killing me. Any insight you have would be great.
Thanks,
Pitdog
Sorry I messed up on the driver version numbers
Prd driver = 2.573.7713.00
my box = 2.573.9030.00
They are different.
|||I had the same problem for the past few days. I think it has to do more
with the Oracle client installed on the machine.
I had installed Orcale 9i client on the user machine and tried to run
the vb application. I was getting the same error. So I uninstalled the
Oracle 9i client and installed Oracle 8.0 client. And as I had guessed,
the application ran perfectly fine. Now I am installing Oracle 8.0
client on each user machine before distributing the application.
Looks like the Microsoft ODBC oracle driver cannot work in sync with
Oracle 9i client. I would recommend you try uninstalling Oracle 9i and
install a previous version.
*** Sent via Developersdex http://www.codecomments.com ***
|||Hey Lucky Thanks for the help. I will check it out tomorrow in the am.
Fingers crossed.
|||Hey Lucky no dice on this. The DB is a 8.1 db and that client I am
using is the correct one. I have opened a ticket with the DBA's here I
am hoping they can shed some light on this issue. I will post back if I
find an answer.
PD
Problems with [Microsoft][ODBC driver for Oracle][Oracle]
Hello all,
I have a VB application that is running fine in prod on a box without
the .net framework installed. The app queries a Oracle 8.1.7 64 bit
database. It uses the Microsoft ODBC Driver for Oracle and it works
like a champ. However I am adding some enhancements to this application
and on my local machine I have the the .NET framework installed of
course. And I am finding that my simple select statement below is
failing.
Select * From is_sec_ipass Where TO_CHAR(start_time,'yyyymm') =
'200505' And type = 'I'
I looked at the driver version on the production box as well as my box
and this is what I have found.
Prd driver = 2.573.7713.00
my box = 2.573.7713.00
Is there something I am missing here? I even stripped down the query to
this SELECT * FROM ISSEC_DB.IS_SEC_IPASS and it still bombs out.
Here is the error I get.
Error (-2147217900): [Microsoft][ODBC driver for
Oracle][Oracle]ORA-00900: invalid SQL statement
This is just killing me. Any insight you have would be great.
Thanks,
PitdogSorry I messed up on the driver version numbers
Prd driver = 2.573.7713.00
my box = 2.573.9030.00
They are different.|||I had the same problem for the past few days. I think it has to do more
with the Oracle client installed on the machine.
I had installed Orcale 9i client on the user machine and tried to run
the vb application. I was getting the same error. So I uninstalled the
Oracle 9i client and installed Oracle 8.0 client. And as I had guessed,
the application ran perfectly fine. Now I am installing Oracle 8.0
client on each user machine before distributing the application.
Looks like the Microsoft ODBC oracle driver cannot work in sync with
Oracle 9i client. I would recommend you try uninstalling Oracle 9i and
install a previous version.
*** Sent via Developersdex http://www.codecomments.com ***|||Hey Lucky Thanks for the help. I will check it out tomorrow in the am.
Fingers crossed.|||Hey Lucky no dice on this. The DB is a 8.1 db and that client I am
using is the correct one. I have opened a ticket with the DBA's here I
am hoping they can shed some light on this issue. I will post back if I
find an answer.
PD
I have a VB application that is running fine in prod on a box without
the .net framework installed. The app queries a Oracle 8.1.7 64 bit
database. It uses the Microsoft ODBC Driver for Oracle and it works
like a champ. However I am adding some enhancements to this application
and on my local machine I have the the .NET framework installed of
course. And I am finding that my simple select statement below is
failing.
Select * From is_sec_ipass Where TO_CHAR(start_time,'yyyymm') =
'200505' And type = 'I'
I looked at the driver version on the production box as well as my box
and this is what I have found.
Prd driver = 2.573.7713.00
my box = 2.573.7713.00
Is there something I am missing here? I even stripped down the query to
this SELECT * FROM ISSEC_DB.IS_SEC_IPASS and it still bombs out.
Here is the error I get.
Error (-2147217900): [Microsoft][ODBC driver for
Oracle][Oracle]ORA-00900: invalid SQL statement
This is just killing me. Any insight you have would be great.
Thanks,
PitdogSorry I messed up on the driver version numbers
Prd driver = 2.573.7713.00
my box = 2.573.9030.00
They are different.|||I had the same problem for the past few days. I think it has to do more
with the Oracle client installed on the machine.
I had installed Orcale 9i client on the user machine and tried to run
the vb application. I was getting the same error. So I uninstalled the
Oracle 9i client and installed Oracle 8.0 client. And as I had guessed,
the application ran perfectly fine. Now I am installing Oracle 8.0
client on each user machine before distributing the application.
Looks like the Microsoft ODBC oracle driver cannot work in sync with
Oracle 9i client. I would recommend you try uninstalling Oracle 9i and
install a previous version.
*** Sent via Developersdex http://www.codecomments.com ***|||Hey Lucky Thanks for the help. I will check it out tomorrow in the am.
Fingers crossed.|||Hey Lucky no dice on this. The DB is a 8.1 db and that client I am
using is the correct one. I have opened a ticket with the DBA's here I
am hoping they can shed some light on this issue. I will post back if I
find an answer.
PD
Subscribe to:
Posts (Atom)