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...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...C#.NET WEB APPLICATION
hei guys, i need help on my application, i'm using C#.NET as front-ed and SQL as back-end, aside from a datagrid, i want to display my data using textboxes and not a datagrid, i can do it using Visual Basic 6 but since i'm a newbee at C#.NET i don't know how to do it, specially the codes, can anyone help me with it? thank you in advance!
If you are doing windows development, i would suggest using 'DataForm wizard' (Use Solution Explorer-->Rightclick project-->Add new Item-->New DataForm). It will guide you through steps. If you are doing web apps. Use quickstart to learn them.
h...visual web developer 2005 database cant access database now!!!
I downloaded vwd 2008 and vb2008 amd sql server 2008 and now i cant access the database in my wdv 2005 i get this
This Server version is not supported.
You must have microsoft Sql Server 2005 Beta 2 or later
What do I need to do to get my vwd 2005 working
...Linking Web Form + MS ACCESS Database
I don't know if this is possible, but does anyone know if it's possible to create a web form linked a long with a Microsoft Access database. Say I'm filling out an online application, and if I submit that form, the MS Office database automatically updates itself with my information, so I can just download the database off the server later and read it from MS Acess rather than the web. Is this possible?
Yes, it's certainly possible, and not too difficult. Check out this link:http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnofftalk/html/office12062001.aspHope it helps.My Bl...Please help updatae to database not working... Oracle and web form
I am very frustrated with my code for updating an oracle database it is coming up witht hte error of ORA-01008: not all variables boundI have deleted my other parameters for updating to see if I can pin oint the issue and now I am down to one parameter in the update and it still has the error when trying to executenonquery... Please help I figured it out I used the wrong provider.... in my connection...DataList syntax using VS.NET C# with an Access database
Can someone please point me in the direction of documentation of the correct steps and syntax for use of a datalist to get records from an Access table.
It appears there is a huge amount of information on all of the data controls but I need to understand how to use it from within a code behind page created witih Visual Studio.Net 2003.
I find it interesting that Microsoft, supposedly the creator of Visual Studio.Net 2003 and the C# programming language support ASP.NET very strongly but apparently ignore the users of a core development environment they are pushing on developers, namely ...How to create database and run it in Web Project Setup (VS.NET 2003)
I already create a Web Setup Project by VS.NET 2003. And I have some script files (*.sql) for creating database in SQL Server. How can I use it. I want the Web Setup Project creates for me a new database using script files (*.sql). It's like the Rainbow Portal Setup (sourceforge.net) or the instalation of ASP.NET forums.
Can everyone help me ?
I'm confused. Do you mean you want to create a database using scripts everytime you create a new project in Visual Studio? If that's it, look at this article on altering Enterprise Templates. Even if you don't use Enterprise Templates, it expl...Permission problem with access database using vb.net web service
Hi all,I wrote a simple web service that has two public methods. It uses Access database. As long as the codes are accessing the database read only, it is fine. The methods can query data without having any problem. But when it comes to writing some data to database, I get "use an updatable query" error, which means the database is read only. But it is not read only because aspx pages can write data to it without having any problem. The folder and file permissions for database file is correct. When i googled the issue i found out that web services acce...fail to show report from oracle database using VS.NET 2003
To be precise I want to show reports from the oracle database in Web project. I am using Visual studio 2003 with windows xp sp pack 1 and IExplorer sp. Following is the problem. Kindly respond me soon.
I am facing problem to view the report. Actually the report picks the data from oracle 8i database but it failed to show in browser. The icons and gifs of crystal reports even they are not visible. The report successfully connects to oracle but afterwards it fails to show any results. Only a blank page appears with crosses on the gifs of crystal report logo.
how r you co...Web Form does not accept (single quote character) when saving to Access Database
ASP.net 1.1 with VBDatabase: MS Access
When saving Text to a datbase via web forms I get an error if the text contains the character (single quote)
Syntax error (missing operator) in query expression System.Data.OleDb.OleDbException: Syntax error (missing operator) in query expression '
How can I solve this?
ValidateRequest="false" add this attribute in page register tag of .aspx page. If you still get the problem post the SQL query Watch The true story of internet ||Yet another forum |||I'm big fan of Open source flash chart for .net very very simple I n t e r ...Access forms vs vb.net forms
I have to do an windows application for an access database, which currently had access forms. I am trying to convince doing it in vb.net. I know I can do much better froms or front end with VB.net. I am not sure how to convince my boss or client.
If you want info on Windows Applications try www.windowsforms.net.
Here's how to convince them, if they are tight about money:
vb.net = Only need one license, for you the programmer, which you may already have
access = need an access license for every person that uses the program (shush, don't tell them about access runtime)
I...Writing a Web Application that can use any database. i.e. Access, SQL Server, Oracle
Hello, I am in the beginning phase of converting a large ASP web application to ASP.NET and would like to do it as right the first time, which brings me to the following questions. I was reading the SqlDataSource control would work for any database product for which there is a managed ADO.NET provider. I have never been a fan of data controls and would prefer to dynamically code the SqlDataSource. Our current system uses an Access database. We have talked about migrating to SQL Server but at this time the decision has been made to continue to use the Access database.&nbs...What good is the file system web server in VS.NET 2005 if your database is on a remote box?
What's confusing about the new way of developing ASP .NET 2.0 apps is that if you are developing it on your local filesystem, and while the special local web server lets you run your code as if it were running on an IIS installation, what happens if your app needs to do queries against a database that's on a remote box, one that is not even on your network?In this case, how do you setup your project? Using HTTP and IIS I would imagine? And if doing this, the debugging feature will handle the debugging remotely?
I maintain my own Web site as local file system Web with connection to remote S...