OLE for db does no work

Hans L · Joined: 04 Oct 2007 Posts: 1

I can not get the OLE Provider for DB2 working.

1 The connect to the AS400 is working
2 I succeeded creating SQL packages in the PJPDTA1 library on the AS400
(this is only possible with EBCDIC US/Canada (37). When I use Swedish/Finish
(20278) I do not succeed creating packages. The EBCDIC code for the database
on the AS400 is 278.

3 Trying the Sample Query I get this result:
Could not connect to data source 'AS400_OLE3':
Ett eller flera fel uppstod under bearbetning av kommandot.
SQL error occurred. SQLSTATE: HY000, SQLCODE: -372

The Connection String I am using is this:
Provider=DB2OLEDB;User ID=HE;Initial Catalog=S44L0105;Network Transport
Library=TCP;Host CCSID=37;PC Code Page=1252;Network
Address=THOR.DIREKTKONSULT.SE;Network Port=446;Package
Collection=PJPDTA1;Default Schema=PJPDTA1;Process Binary as
Character=True;Units of Work=RUW;DBMS Platform=DB2/AS400;Defer
Prepare=False;Rowset Cache Size=0;Persist Security Info=False;Connection
Pooling=False;Derive Parameters=False;

Can anywone help me with this?

Archived from group: microsoft>public>vb>ole

Does the VB6 CommonDialog work (compiled on Win98se) work on I have a program that uses a common dialog control that works great on win98/XP but gives this error on Vista: component comdlg32.ocx or one of its dependices is not correct. the file is missing or invalid. Can the common dialog control work on Vista or d

Why does it not work? Why does it not work? ; Private Sub If > 0 And Val(txtRate) > 0 And Val(txtYears) > 0 Then txtFuture = FV(txtRate / 12, txtYears * 12, txtMonthly, 0, 1) * -1 End If End Sub

HELP: getting vb to work with IE Hey is there a way, possibly using dll's to get visual basic to interact with internet explorer, eg. load a page, type text into a txt box, eg. google, press the submit button or refresh the page, pretty much anything along these lines. is this possible a

Why does DDE only work in IDE Hi there, I have a form with some DDE linked text box controls. The text of the controls change exactly as expected when the form is in design mode, but do not work at all when the program actually runs. Does anyone know what the issue is here?

COM+ Component will only work when.... My COM+ Component will only work when the user that the componponent is running under is logged on the server. How can I fix this? I have the component running under a specific user not interactive user.