How to use Ole-Db VBO in BP version 5

[RohitDangi]

Hi Team,

I have to use the Ole-DB Vbo in BP version 5. Can anyone please help me in making the connection with the excel. In Bp version 5 , there is no 'connection string' input field. So, how can i make the connection.

 

[sivagelli]

Follow the complete thread on the forum. You should find the answer.

 

[RohitDangi]

Hi sivagelli,

I already go through the post related to the Ole-Db but all are referenced to the version 6.

 

[sivagelli]

I do not think, version will limit you here. I use v5 and connect to excel using ole-db with no issues. Look at the post in specific.

 

[RohitDangi]

Hi Sivageli,
Thank you so much , bu following the thread you suggested i am able to make the connection but getting different error.
"Internal : Missing data : [Attempts_Exception]", Any idea of this error.

 

[sivagelli]

I guess you are using a field, "[Attempts_Exception]" which does not exist. So, BP is throwing error.
Attach a screenshot of what you are trying to do, if you need assistance.

 

[RohitDangi]

Hi Sivagelli,

Thank you so much,successful connection has been made. Thanks alot

 

[sivagelli]

Hi Sivagelli,

Thank you so much,successful connection has been made. Thanks alot

Good to know! Cheers!!