MSSQL connectivity for PE

[ricoiii]

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

[Albuquerque]

From google search:

Generally the issue could be caused by the following:

1. The file and file path are not where expected (it seems)

2. The resource DLL (SQLOLEDB.RLL) is not loaded,

3. The versions of SQLOLEDB.DLL and resource DLL don't match.

Please check the <Program Files>\Common Files\System\Ole DB for these two files

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

[ricoiii]

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?

[ricoiii]

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

[mats]

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

[ricoiii]

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.

[Jazkal]

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