|
And there are also lots of training courses about Oracle licensing. Definitely isn't an easy-to-understand thing.
|
|
|
|
|
dont worry, they wont forget to add 10% on the top for being part of your business.
Common sense is admitting there is cause and effect and that you can exert some control over what you understand.
|
|
|
|
|
I am working in a VB6 Access project in which the DB is password protected. My DB is getting corrupted at the application run time.
Anybody have any solution
|
|
|
|
|
I would upgrade database to MS SQL Server 2005 and project to VS2010 at least
I Love T-SQL
"VB.NET is developed with C#.NET"
If my post helps you kindly save my time by voting my post.
www.cacttus.com
|
|
|
|
|
I suppose you are running Access 95 or something, there was a utility that would allow you to clean and compress the database. If you have not been using that then the database will have been deteriorating of the last decade or so and is probably dead by now.
You have gone well past the use by date for this application.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
sudheesh kumar s wrote: My DB is getting corrupted at the application run time.
What does that mean?
Do you have a database which is now corrupted?
Or you have an uncorrupted database and EVERY time you start the application then it becomes corrupted?
And what application (version) on what OS (version) are you using to determine that it is corrupted?
|
|
|
|
|
Are you accessing the database from multiple machines? Access isn't meant as a database-server, it's a "local" database format.
Do you still have a non-corrupt version around? Backups?
If so, open it in Access, and convert it to Sql-server format. MS Access has a conversion-wizard that can migrate everything in there to Sql Server. Next, you download Sql Server Express 2008, which is a free download. Next, you download Visual Basic Express 2010, which is also a free download.
If the app survived this long, there's bound to be some value in it. That would mean that it's probably worth updating the logic to something more modern. All the tools are available for free.
Happy programming
Bastard Programmer from Hell
|
|
|
|
|
I have been using MS Access as a backend with VB6 for over a decade. Our software works with Access or SQL Server depending on customer size and usage. 95% of the code base is the same. The only time I have seen Access (2000 or better) become corrupted is when more than about 6 or 7 users might hit it at the same time...combine that with a crappy network and it spells trouble. The bottom line is that Access does not perform will with multiple connections over a network. (permissions can also be a bi*ch since Access has to create a lock file)
If the database gets corrupted everytime you start the program, then obviously you will have to solve that issue first.
"Go forth into the source" - Neal Morse
|
|
|
|
|
Hello,
I have installed the MySQL database program on my computer. It came with 2 databases installed and I created another called "Test" for experimentation. I can access all the information from WITHIN the proggram using the internal commands, however, I am looking to be able to access table information from an outside program, so I need to be able to get table information into that program (C#) to create queries. I can successfully list the names of the databases in the program, however, I have an issue getting the table names. I have used both of the following which are supposed to list the tables:
And I have tried several variations of the above. All seem to either return only the names of the 3 installed databases or nothing at all. Can anyone supply me with an SQL statement that will simply return the names of the tables inside a specifically defined database (thisDb) and, as long as I am on the topic, if your know this answer, how about another script to do the same thing for the table columns of each table. Thank you for your input and assistance....Pat
|
|
|
|
|
This works for me:
USE thisDb;
SHOW TABLES;
|
|
|
|
|
Thank You Shameel....once again you have bailed me out. I was actually going to email you with this question as I remember that we used to be able to do that here, but I could no longer find a link for it. In any event, and to help any others that are suffering along and who find this question in a search, I am enclosing the final code that I used for my application. And once again Shameel, I have marked your answer as correct. For other interested parties, the C# code is mine (simple and clean for better or worse), so don't blame Shameel for it...LOL. Best Regards, Pat
string thisDb = listViewDatabases.SelectedItems[0].Text;
string Sql = "Use " + thisDb + ";" + " Show Tables; ";
try
{
MySqlCommand Comm = new MySqlCommand(Sql, Conn);
MySqlDataAdapter da = new MySqlDataAdapter(Comm);
DataSet ds = new DataSet();
da.Fill(ds);
int count = ds.Tables[0].Rows.Count;
string[] tables = new string[count];
for (int i = 0; i < count; i++)
{
tables[i] = ds.Tables[0].Rows[i][0].ToString();
listViewDbTables.Items.Add(tables[i].ToString());
}
}
catch (Exception ex)
{
MessageBox.Show("Error" + ex.Message, "Error");
}
|
|
|
|
|
Anytime, glad to be of help
|
|
|
|
|
With ADO.NET, the DataReader's
GetSchemaTable() method can be used to retrieve column information for a specific table. For example,
DataTable dt = reader.GetSchemaTable();
foreach (DataRow dr in dt.Rows) {
foreach (DataColumn dc in dt.Columns) {
Console.WriteLine(dc.ColumnName + " = " + dr[dc].ToString());
}
Console.WriteLine();
}
|
|
|
|
|
Thank you for your reply Ginger. I will add your code to my snippets for future use. The simple string from Shameel added to my own standard population method solved the problem for me. Thank you for your input and advice....Best Regards, Pat
|
|
|
|
|
Is it a must in star-schema modeling that we have a single fact table?In essence can we have multiple fact tables in a cube and still arrive at a star-schema model.
Thanks
Current
|
|
|
|
|
|
Dear all,
Please advise how to get the record count of Cursor ?
DECLARE @vendor_cursor CURSOR FOR
SELECT BusinessEntityID, Name
FROM Purchasing.Vendor
WHERE PreferredVendorStatus = 1
ORDER BY BusinessEntityID;
OPEN @vendor_cursor;
FETCH NEXT FROM @vendor_cursor
INTO @vendor_id, @vendor_name;
Thanks and best regards
|
|
|
|
|
Do you need the count before, during or after the cursor has run.
Before - use select count(*) with your cursor query
During and After - set up a @Count variable and increment it within your cursor
Set @Count = @Count + 1
This question shows a dramatic lack of thinking, the solution is so simple.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
|
Thank you for the reply
@@CURSOR_ROWS works for me.
|
|
|
|
|
Excellent, there is another potentially useful keyword I have never used (or knew about).
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
HI all, I am new to cursor and i have a doubt... I have one vb code in which few sql statements are written. I need to convert these sql codes into pl/sql sotred procedures. But, in vb, the sql query is dynamic on the basis of values passed like..
If Trim(txtEqpId) <> "" Then
Sql = Sql & vbCrLf & " AND c.eqpid LIKE '" & Trim(txtEqpId) & "%'"
End If
This sql query is first generated and then it is being called from vb code.
Now the problem is while creating pl/sql procedures, I need to make a cursor where the cursor definition has to be created dynamically {not in BEGIN block and it is not fixed}...
So, can we add if condition in cursor definition statement or any other way to achieve it...
csetopper_bhanu
|
|
|
|
|
You are looking for a dynamic where clause, take a look at come of these responses[^]
Most of these will work with a cursor.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
I have a query that returns a table something like this:
102
NULL
101
NULL
the 101 & 102 are FKs into another table, and I need to "expand" those... so what I want to end up with is:
102 b
102 a
<some kind="" of="" marker="" to="" indicate="" the="" null="">
101 b
101 a
<some kind="" of="" marker="" to="" indicate="" the="" null="">
so I figured I'd create a cursor on the first table and loop through the 102, 101, etc. and then do an inner select to "expand" the 101 and 102... this works fine... I end up with 4 result sets though. One for the 102, one for the first null, one of the 101 and one for the second null.
The empty result sets are significant to the query... I figured I could insert a dummy record in there with a special ID... unless there is a better way, but not sure how to combine the 4 result sets into a single one with out losing the empty ones?
|
|
|
|
|
I would as a default try and avoid cursors, they really are a last resort tool.
Have you tried UNION or UNION ALL on the 2 queries.
Select This, null That
from SomeTable
Union
Select This, That
from SomeTable
left join ThatTable on ...
Never underestimate the power of human stupidity
RAH
|
|
|
|