Version of PowerBuilder (ref: Creating database for PowerBuilder)
I'm using PowerBuilder v8.0 and would like to create a
notification system for my practiculum project. I'd like to
use Access to create the database. Please enlighten me on
what should I create (e.g. tables, queries) for the usage of
Don't double post, it's bad etiquette.
Unless you have a very good reason to do so, we recommend you don't use
Access. Use SQL Anywhere instead - it's more stable - and a far better
database in my opinion. PowerBuilder (enterprise) supports just about every
database out there, so if you...How do you deal with making database modifications on remote database?
If I attempt to make a database change to a table in the remote database I
get the message 'Table is part of a synchronization definition' and does
not allow the change. How should this be handled?
I am using ASA 7.02.1480
You must remove the table from the SYNC DEF, modify it, then re-add it.
Replication and Synchronization Guide
PART 2. MobiLink Synchronization
CHAPTER 8. Reference
ALTER SYNCHRONIZATION DEFINITION statement
Certified SQL Anywhere Associate
Sybase - iAnywhere Solutions
Pr...Populate DataGrid from Database, make changes and then update the database
I'm populating a DataGrid from a database in BindData() method and creates a DataSet that is used as datasource for the DataGrid. When I for example adds a row in the datagrid I dont want to update the database directly, I just want to update the DataSet and then when all changes are made (press a save-button on the main form) I want to update the actual database.
The problem is: How do I fill the DataGrid just once and then keep all data in the dataset? I dont want to read from database everytime somethings happens to the DataSet/DataGrid.
Can anyone help me with this? Please!
...Select in Powerbuilder Database painter WORKS but does NOT in Powerbuilder run mode.
I have enclosed the actual information from a debug run. Will apprecaite any
DataWindow.Table.Select="SELECT DISTINCT ~"inv_dtl~".~"inv_id~",
~"inv_dtl~".~"sugg_price~", ~"inv~".~"vend_id~", ~"inv~".~"style~",
~...how to make my own database?
i want make a database owned by myself, (not by dba with password sql)
anyone konws how to make it?
If you don't have your own userid, login as the DBA and create a new user.
Login under your own userid, and issue the create table statement from
Thanks, theoretically i agree with you. every time when i try to connect to
the database i am asked to fill in userid and password then i get through. but
i cannot find where is the administration of the server (SQL anywhere on my
PC). what is the administration inferface look like? How can i get it?
Dale R...I want to make consolidate database out of 30 ASA 10 database:
I want to make consolidate database out of 30 ASA 10 database:
I have 30 ASA 10.0 databases, almost identical, all have some data common in
lookup tables and some are different.
In transaction tables all the data is different.
Please let me know how I can do it. What is best way
1.. Load and Extract ( can i avoid duplicate records?)
2.. BCP IN and OUT (can i avoid duplicate records?)
3.. Mob link. (can i avoid duplicate records?)
Guide me how to do that and what is best solution
If any one has scripts already, i will appreciate if y...Making should be make
Name: Scott Melton
Summary: Making should be make
The opening page for Bugzilla is poorly worded.
The second line:
If you want to help making this application even better, we would
encourage you to take part in the
should be MAKE, not MAKING
Browser Details: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:184.108.40.206) Gecko/20070222 SeaMonkey/1.1.1
...How do i make a database?
I know how to do sql but i dont know how to make the actually database
from where all the information comes from. How is thisdone?
Also whats the benefits of using a master page?
Domal:I know how to do sql but i dont know how to make the actually database from where all the information comes from. How is thisdone?
Hi Domal, sorry, I don't really get the question. Are you asking how you could create a database in SQL Server 2005 Express and how you could populate the database with information?
Domal:Also whats the benefits of using a master page?
This arti...Select in Powerbuilder Database painter WORKS but does NOT in Powerbuilder run mode.
I have enclosed the actual information for a debug run. Will apprecaite any
DataWindow.Table.Select="SELECT DISTINCT ~"inv_dtl~".~"inv_id~",
~"inv_dtl~".~"sugg_price~", ~"inv~".~"vend_id~", ~"inv~".~"style~",...mysqldump to backup Bugzilla database vs. cp (in Unix) to make copy of Bugzilla database?
I am just wondering how different is it between using mysqldump to back
up Bugzilla database and using cp (in Unix) just to copy Bugzilla
database and then transfer the file? Because after I use cp to make a
copy of Bugzilla database, and go inside the database, it looks very
identical, so I am just wondering is it necessary to use mysqldump to
back up Bugzilla database?=20
Thank you very much for your input.=20
...Is there any correction i have to make to the web.config file connectionstring before uploading to the database files for me to be able to assess my database?
I just completed asp.net website created with visual web developer 2005. During development, a database was generated named ASPNETDB.MDF which i took the liberty of adding extra newsletter table. During development, clicking the submit button, collect my data and send it to the database, and to view the data collected, i will have to login to view the newsletter administrative page and my web.config connention string is <connectionStrings> <add name="ASPNETDBConnectionString1" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilen...Database schema could not be retrieved for this conection. Please make sure the connection settings are correct and that the database is online.
I drag a DataView, choose a datasource, new data connection (Data source: Microsoft SQL Server-SqlClient, .NET Framework Data Provider for SQL Server). I test the connection and it's ok. Then a pop up window says: "Database schema could not be retrieved for this conection. Please make sure the connection settings are correct and that the database is online.".
It happens if I choose a datagrid, datalist, etc.
The database is online because i can insert new table in the database, etc. Maybe something is wrong with connection settings but i don't know what.
Can anyone help me?ThanksTo...I find make a multi-column status bar at the bottom of window easy in VB. But how can I make it in PowerBuilder?
I find make a multi-column status bar at the bottom of window easily in VB.
But how can I make it in PowerBuilder?
Any advice is appreciate.
Probably the simplest method would be to create a standard visual user
object based on a text object. Add some object methods to set the text. You
can them write code in the resize event of your window to place the user
object wherever you need it on the screen, and call the object methods to
set the text.
<salad_yfz> wrote in message
> I find make...Accessing the PC database using a web-page and PowerBuilder 5.0 front-end and MS Access Database
I am trying to connect my web page, which is the standard HTML Explorier
applet to my MS Access Database by way of PowerBuilder 5.0. I would like
the steps and PowerBuilder Script to make this work. I was told that this
is possible, but I don't know where to start, where to place the needed
Script, and how to get the link on the web page to call up Powerbuilder to
access the MS Access database. Help!
You create a PB user object that has methods that do the access. You
deploy that as a distributed PB component and then access it using Web.PB.
Read more on distributed PB and...Database 'C:\INETPUB\WWWROOT\HOURSREPORTING\APP_DATA\ASPNETDB.MDF' cannot be upgraded because it is read-only or has read-only files. Make the database or files writeable, and rerun recovery.
I have a website that runs on this computer through IIS. It was working fine until I went into it and added a textbox. Now it gives me this:
Server Error in '/' Application.
Database 'C:\INETPUB\WWWROOT\HOURSREPORTING\APP_DATA\ASPNETDB.MDF' cannot be upgraded because it is read-only or has read-only files. Make the database or files writeable, and rerun recovery.Cannot open user default database. Login failed.Login failed for user 'NT AUTHORITY\NETWORK SERVICE'. Description: An unhandled exception occurred during the execution of the current web request. Please...