Database Profile -> Database Profile SetUp -> Provider DropDown List is Blank/Empty
After using PB 10 (currently Version 10.2.1 Build 9637) for several
months now, database connections suddenly stopped working. Opening the
Database Profile SetUp in OLE Microsoft OLE DB, I find that the
Provider list that used to be populated is now completly empty. How can
I populate/install/restore the options in the Database Profile SetUp
Provider List in PB 10? Many, many thanks.
> After using PB 10 (currently Version 10.2.1 Build 9637) for several
> months now, database connections suddenly stopped working. Opening the
> Database Profile SetUp...copy database one database to onther database
hii want to copy one database table to onther database table using script?my database is ms-sql server 2000 Nothing is really over,untill the moment stop trying for it...Amitsp(MCTS,MCP)sqlreporting.blogspot.com
You can use import/export task and DTS package created automatically by Enterprise manager or just try
select * INTO [newdatabase].dbo.[newTable] from [sourceDatabase].dbo.[sourcetable]
no dear i want to this programatticallyiusing c #,source is my database in local machine and target is other computer means server Nothing is really...how to access other database in this database ?
Hi,Everyone,I used to use oracle 8i,but now for some reasons,I must change
to ASE11.5,at the beginning,I don't know how to access tables among
databases,in oracle, if I grant "select" to some user,this user will access
other user's table in username.tablename format,I want to know how to
implement this functions,please help me! thanks!
Very similar in sybase ASE.
grant SELECT on <user>.<tbl> to <newuser>
for new user:
select * from <user>.<tbl>
> Hi,Everyone,I used to use oracle 8i,but now for some rea...database in database solution
i have a database in the database solution. but i want to add the database from database solution to App_data folder in solution explorer.
how to do this ?Jai Ganesh. J , GSD ,IndiaPlease Mark As Answer If my reply helped you.
i am having visual studio express edition and sql management express.
i have opened solution explorer for a asp.net project. I have the database solution and i have the App_data in the solution Explorer.
I have added a existing sql database in the database solution and wanted the newly added sql database in the App_data of solution...How to upgrade database changes in remote databases and consolidated databases
I am Working in a project which uses Sybase Mobilink server as the
replication system. Now I have been given a requirement to automate the
upgrade databases chages in remote databases and consolidated database.
I heard the about "Passthrough" but I don't know how to use it.
I saw below topic in our forum
PASSTHROUGH Question. How do I replicate DML ...
1.- Created a Version_Tracking Table (contains columns
Unique_Record_ID, DB_Remote_ID, DB_Version, DB_Update_Time_Stamp and
2.- The new Version_Tracking table is part of a publication that...Coping Database objects from one database to another blank database.
I want to create a duplicate database in sql 2000 using asp.net from a webform
I created a database using CREATE DATABASE .......
But how to copy tables, views, stored procedures to newly created
database from old using asp.net from webform
Is there any another method to create a duplicate database with another name
from existing database on same server ?
yes you can do have another DB with different name and that has everything the same .....!!!Fadil Alnassar www.fadilalnassar.com | FREE Nodil Tab Controlhttp://www.mefranchising.com
One way it can be done is with...which database does the database refer in "Not connected to a database" of the second paragraph
I. 01/01 02:30:40. Synchronization Started
I. 01/01 02:30:40. Adaptive Server Anywhere MobiLink Synchronization Version
I. 01/01 02:30:40.
I. 01/01 02:30:40. Copyright _ 1989-2002 Sybase, Inc.
Portions Copyright _ 2002, iAnywhere Solutions, Inc.
I. 01/01 02:30:40. All rights reserved. All unpublished rights reserved.
I. 01/01 02:30:40.
I. 01/01 02:30:40. This software contains confidential and trade secret
I. 01/01 02:30:40. iAnywhere Solutions, Inc.
Use, duplication or disclosure of the software and
I. ...two informix server connect to powerbuilder database profile
Please give me some feedback as it is real urgent.
Can I connect to 2 informix database but from the different
I am using Powerbuilder 5.04 and Informix SetNet32.
I got an error when doing so as the INFORMIXSERVER don't allow me
connecting to another database from other INFORMIXSERVER. The error message
that I got
is "cannot connect to database server(server name)..."
informix error code -930
--setnet32 enviroment setting(informix server)
make default server = domeic_oltcp0 <-- powerbuillder database profile
another infor...Replication of consolidated database to remote database; for columns added to a table in the consolidated database.
I want to find out if I add columns to a data table in the consolidated
database and then extract it for a remote database. Will the added columns
appear in the remote database automatically? or do I have to deploy the
extracted remote database by copying it to the remote machine.
Currently the consolidated database and the remote database get replicated
nightly and they have connections already established. Due to established
connections, will the extracted database automatically get deployed to the
remote machine with the updated table?
Try it, that is the best way to check ...Database Workbench, where can I set a Database Restricted so only aliases can use the database?
Now I want a database to be not available unless approached by an alias.
Can't find where I set this, in Database Workbench.
> Now I want a database to be not available unless approached by an alias.
> Can't find where I set this, in Database Workbench.
This is a setting of your Firebird server installation. Check out the
DatabaseAccess configuration parameter in firebird.conf.
Set it to:
DatabaseAccess = None
Professional Tools and Services for Firebird
FB TraceManag...What kind of Database is a .db database
We bought a company's assets and several of their programs use ".db"
extension databases...we're having a devil of a time figuring out whether
their Berkley DB, Oracle,MySql,or what. Any idea about what they are or how
to find out. They are not encrypted.
charles leggette wrote:
>We bought a company's assets and several of their programs use ".db"
>extension databases...we're having a devil of a time figuring out whether
>their Berkley DB, Oracle,MySql,or what. Any idea about what they are or how
>to find out. They are not encr...Delete all databases from Database Explorer
I delete all databases from Database Explorer but when I
open again the instance of VWD2005, the database is still present. Do I have to delete them physically, or Database Explorer
means something when I hit delete? cheers,imperialx
Make sure you have permissions on the account you use to delete databases.
Did you get any error while deleting it?
ASP.NET Grid With Excel Capabilities...detach aspnetdb database database
Iam facing problems to connect to the new database after detach the aspnetdb.Simply the new database disappear (In SQL 2005 Management studio express the database contents disappear ! and I get an error when try to open it).If I try to connectto aspnetdb again I get an error telling me it is used by another process.I don't understand what is going on could any one explain to me?
use this command in the sql query....
sp_detatch_db 'Database name'
Remember To mark as answer if it answered your question.
I have detach th...multiple database Insertions in database
I want to insert multiple records in database. Actually, I have checkbox which have Text and ID behind them, and they are located inside a repeater control. Can anyone send me steps or code to insert these records in database. should I use transaction ?
Thanks in advance.
If the multiple records form a logical whole then you should use a transaction. Transaction are best confined to the scope of a single stored procedure. Transactions in your calling code are a recipe for high complexity.Don't forget to click "Mark as Answer" on the post that help...