Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (5)

Resolved insert database error

  1. Advice
0
Votes
Undo
  1. william yau
    william yau
  2. PowerBuilder
  3. Friday, 12 August 2022 04:23 AM UTC

Hi 

 I upgraded pb10 to pb2019 r3 , I did posting database as below message. so i downloaded mssoledbsql driver and installed it.

if program called by powerbuilder IDE. it is ok. but when I deployed it as execute file. it still occured below error when run the execute file

please give me some advice 

 

William

 

 

How to set Webbrowser language?
SQLSPY - capture executed SQL into a variable
Responses (5)
Sivaprakash BKR
Sivaprakash BKR Accepted Answer Pending Moderation
  1. Saturday, 13 August 2022 06:27 AM UTC
  2. PowerBuilder
  3. # 1

Hello,

I have successfully upgraded PB 10.5/ PB 11.5 applications to PB 2019 R3 2703.   Both versions connect SQL Server database (SQL 2012 SP3) through OLE DB only.   My SQLCA parameters are (from my ini file) :

DBMS="OLEDB"
Database=DBName
LogId=logid
LogPassword=pass
ServerName=computername\SQL2012
AUTOCOMMIT=True
Lock="RC"
DBParm = "PROVIDER='SQLOLEDB',DATASOURCE='computername\SQL2012',PBMaxBlobSize='100000',PBMaxTextSize='100000',PROVIDERSTRING='Database=dbname'"

I haven't installed mssoledbsql, connections are through OLE DB alone.  

I used to install 64 bit sql server exe, if the windows is 64 bit else will install 32 bit sql server.   For clients there is no need to install any drivers and OLE DB is available by default in all windows.  

Can you check the connection parameters?

Happiness Always
BKR Sivaprakash

 

Comment
Miguel Leeuwe
  1. Miguel Leeuwe
  2. Saturday, 13 August 2022 07:50 AM UTC
Hi,

Isn't this driver only already available if you have Office installed?

regards,

MiguelL
  1. Helpful
Sivaprakash BKR
  1. Sivaprakash BKR
  2. Saturday, 13 August 2022 11:02 AM UTC
I don't think so, atleast for SQL Server. We have installed our (OLE DB for SQL Server) applications in systems where MS Office is not there.
  1. Helpful 1
Michael Murray
  1. Michael Murray
  2. Saturday, 13 August 2022 12:37 PM UTC
Ok, I thought it was like in the old days with the MDAC drivers :)
  1. Helpful
There are no comments made yet.
william yau
william yau Accepted Answer Pending Moderation
  1. Friday, 12 August 2022 06:33 AM UTC
  2. PowerBuilder
  3. # 2

but ub 64 bits appears '"DBMS OLDEB" is not supported in current installation＂

Comment
There are no comments made yet.
william yau
william yau Accepted Answer Pending Moderation
  1. Friday, 12 August 2022 05:40 AM UTC
  2. PowerBuilder
  3. # 3

my driver 64 bit and exe is 32 bit , can it work ?

Comment
John Fauss
  1. John Fauss
  2. Friday, 12 August 2022 05:47 AM UTC
For a 32-bit app, you need to use the 32-bit driver. For the IDE (because it is a 32-bit app), you need the 32-bit driver. For a 64-bit app, you need the 64-bit driver. The bitness of the driver and the application that utilizes the driver has to match, or it won't work.
  1. Helpful 3
There are no comments made yet.
william yau
william yau Accepted Answer Pending Moderation
  1. Friday, 12 August 2022 05:39 AM UTC
  2. PowerBuilder
  3. # 4

my exe is 32 bit . and driver 64 bit.  can it work ?

Comment
Miguel Leeuwe
  1. Miguel Leeuwe
  2. Friday, 12 August 2022 06:02 AM UTC
No, in that case your driver has to be 32 bit also.
  1. Helpful
There are no comments made yet.
Miguel Leeuwe
Miguel Leeuwe Accepted Answer Pending Moderation
  1. Friday, 12 August 2022 05:24 AM UTC
  2. PowerBuilder
  3. # 5

Hi,

Is your executable 64 bit maybe? If that's the case you'll have to install the 64 bit driver also.

regards

Comment
william yau
  1. william yau
  2. Friday, 12 August 2022 05:41 AM UTC
my driver 64 bit and exe is 32 bit
  1. Helpful 1
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.