I don''t understand this serror:

Question

I don''t understand this serror:

Flavio

Right there with Babe

Points: 793
More actions
March 14, 2006 at 3:52 am

#168627

"Object variable or With Block variable not set (x5b, 91)"
What this??

I launch a DTS package from a file .exe build by VB 6
The file .exe run in XP platform and realize a connection with remote SQL Server that run on Windows 2000 server platform....
The return message is
"Object variable or With Block variable not set (x5b, 91)"
Please Help me!
Thanks, thanks!!
Flavio

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Lowell SSC Guru Points: 323518 More actions · Answer 1

you've got to look at the vb6 code; the issue is that you are referencing an object that hasn't been initialized; for example, if you create an ADODB.Connection but forgot to do the connection.Open command, and then use the connection later; if the .Connectionstring is invalid and you try to use the connection, you could et this error too.

the same thing could happen with an ADODB.Recordset or a command object;

without more info, it's really hard to pinpoint, but things to check are:

if you see the command

rs.Open sqlstring,connection

above that ther eneeds to be a command that does SET rs= new ADODB.Recordset.

make sure the the here is a statement that says If not rs.EOF then (do something.

if the recordset is EOF and you reference it, you'll get this kind of error.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Flavio Right there with Babe Points: 793 More actions · Answer 2

thanks Lowell!!

but, this morning I have found the solution of my problem.

My executable file .exe use the method LoadFromSQLServer() to load DTS from remote server

In the PC Client (platform XP), there were not installed the Enterprise manager tools, and its libraries!

I installed the EM, then I launched my .exe ... problem solved! DTS OK!

Thank you very much!!

and execuse me for my English!

Flavio