Hi,

i need MSSQL-connectivity for my PE-Boot-CD.
All dll-files where registered fine during the Startup of PE. Then i try to connect to a MS-SQL Server
via vb script:
##################################################
Dim Con : Set Con = CreateObject("Adodb.Connection")
Dim Rst : Set Rst = CreateObject("Adodb.Recordset")
Rst.CursorLocation = 3
Con.Open "PROVIDER=SQLOLEDB;SERVER=xxxxxx;DATABASE=osd;UID=xxxxxxx;PWD=xxxxxx;Integrated Security=SSPI;"

Rst.Open "SELECT * FROM installations where mac='00-30-05-5D-37-C0'", Con, 3, 4

Do While Not Rst.EOF

wscript.echo Rst("xres")

Rst.MoveNext
Loop

Set Rst.ActiveConnection = Nothing
Con.Close
Rst.Close
###################################################

This errormessage appears:
Unable to load SQL Server OLEDB provider resource DLL. The application cannot continue.


In Windows XP the script works fine.

Does anyone know, how to fix the problem?
Thanks

From google search:


You also need MDAC installed on your PE image to make it work...

Thanks for the help, the rll-file was missing.
Now i have a new error.

Windows Scripting Host
Class not registered. Source:Provider

Anyone know whats wrong?

I found that the registration of imgutil.dll is failed,
I removed the commandline-switch "/S" and get the message:

DLLRegisterServer in X:\i386\System32\imgutil.dll failed
Errorcode: 0x80004005

I´ve tried it with a newer version of this file, but the same error.

Any ideas?

Thx

You cant use Integrated security from winpe.

Integrated security means that it should log on with the current user and domain from PE

try with this instead
PROVIDER=SQLOLEDB;DATA SOURCE=XXXXXX;DATABASE=osd;UID=xxxxxxx;PWD=xxxxxx
/Mats

My mistake.
The new connectionstring is:

Con.Open "PROVIDER=SQLOLEDB;SERVER=SADBS016086;DATABASE=osd;UID=xxxxxxx;PWD=xxxxxxx;"

But the error:

Windows Scripting Host
Class not registered. Source:Provider


still appears.

I know this might be a stupid question, but when you built the PE image, did you do it with the /ADO switch?