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

   

• Lowell

  SSC Guru

  Points: 323518

  More actions

  March 15, 2006 at 5:50 am

  #626724

  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

  March 15, 2006 at 6:09 am

  #626729

  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