Vb Script

[eNerGiZer0101]

G'Day to all,
When I try to run my script I get the following message:

Arguments are of the wrong type, are out of acceptable range or are in conflict with one another.

The error message is for the following line:

oRS.Open SqlTxt , Conn


Cheers to all.



Will

 

[PHV]

How are Conn and RS instantiated and SqlTxt populated ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[eNerGiZer0101]

Set oConn = CreateObject("ADODB.Connection")
oConn.Open "DSN=SQL"
Set oRS = CreateObject("ADODB.RecordSet")
oRS.CursorType = 1 'AdOpenKeyset... Gave the good Record Count


what do you mean SQL txt populated?

 

[PHV]

Replace this:
oRS.Open SqlTxt , Conn
By this:
oRS.Open SqlTxt , oConn
And put an Option Explicit instruction at the beginning of your script.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[eNerGiZer0101]

what would i write exactly

 

[zaznet]

Option Explicit

Set oConn = CreateObject("ADODB.Connection")
oConn.Open "DSN=SQL"
Set oRS = CreateObject("ADODB.RecordSet")
oRS.CursorType = 1

oRS.Open SqlTxt , oConn

Granted this doesn't do much, but it is all of the code you've privided with all of the changes PHV suggested.

Nathan aka: zaz (zaznet)
zaz@zaz.net

http://www.zaz.net/