Yes and do not think that information will not leak and be misused. It has happened in Great Britain recently.If the govt has a DNA database and if the govt controls healthcare, can they decide who gets what treatment?
I would rather the government be in charge of who gets what treatment than continue to let insurance companies make the decision...
their decisions are based on profit, at least the government would base it on feasibility.
(for all the clamor against universal medicine, all of the same problems are attributed to insurance companies)
Thats great, Blue Cross and Blue Shield, Aetna, etc all deny transplants for CHILDREN if they feel (the ins co's) that there is a cheaper alternative....
This is no different than what happens here, we just pay 20% in profit to get the same and we also have 40,000,000 uninsured in the process.If the govt has a DNA database and if the govt controls healthcare, can they decide who gets what treatment?
Of course they could. The right question would be whether or not they would. But, considering that we already provide those that don't pay into the system and those in prison with quality healthcare, I would say they wouldn't discriminate.
Yes and they will , it all ready happens in countries with socialized medicine. If you are above a certain age and get certain cancers , they will not treat you , because its not worth it cost wise.
Well, private insurance already decides if you get treatment or not.
I would check into HIPPA.
Saturday, January 16, 2010
How can i display my query result fron a mysql database into a vb 6?do i have to use some controls?
You can Databound Grid Control for that. You can also use DataBase and Recordset Objects to do it programaticaly
What position typically controls an organization database?
What position typically controls an organization database?
Is it the Database Administrator? the Department Directors? The Executive Director? The CEO? The Board?
I need some input here, I just started a new job as The Database Admin. with a company whose database is very large and has had many hands in it with zero consistency. It is going to be a huge job to clean it up. I have been told it is my job to clean up the data base but I do not have the authority to change the way things are being done. Hence, one of the problems the way things are currently being done is why the data is not reliable. I have informed the Directories of this situation, their response was, the way things are being done is working, so let's not fix anything that's not broken.
I cannot quit I need a job and in this economy I.T. jobs are hard to find. Any suggestion on how to handle this situation?What position typically controls an organization database?
Dave,
You are correct that the DBA (Database Administrator) is the primary controller for the organization database. That includes how the database is structured, performance, and so on. The data, however, is controlled by the users and the adding, editing, and removal of data should be in the hands of the community.
In your situation, you are trying to cross the boundaries into the data. I would suggest producing some suggested changed and include a value proposition to the end user. There is no use saying that their data problems make your job difficult. Instead, attack the problem with a cost saving measure or a profit making measure. This is all VPs care about at the end of the day. If you can show them the value of changing their ways, things will be much easier.
On the database side. Make your life easier by creating better referential integrity between data tables and automated cleanup scripts.
Best of luck!What position typically controls an organization database?
Well, maybe you're in a situation where you have to demonstrate what you want to do. This is a suggestions and nothing more, so my advice is worth what you pay for it. ;-)
Build a new database schema (on ';paper';, first) based on the improvements you want to make. Then, create the new database an tables, and extract some of the existing data from the existing database and import/install it into the new database. Then preview it to management; maybe get the web development guys to gen up some web-based access to show how it works (I'm reaching here, since I don't know the details of your site).
If you demo to them the improvements you can make with small chunks of data, you might be able to sell them on a complete makeover. Also, explain to them that you can do it in parallel to existing operations and test with users are go build it out.
Good luck. Sounds like you have a real challenge. Don't get discouraged.
I don't mean any offense by this, and I apologize if I'm wrong...but you sound like you are relatively new to the IT professional world, am I right?
The only reason I say this is because everyone deals with this kind of thing. My first IT job was as a systems developer, I showed up with a million and one great ideas for how everything should work (all learned dutifully in college). I was set to optimize, normalize and standardize everything I could get my hands on.
It took me a few days to come to the reality of things:
1st, NOTHING is as it ';should'; be, according to what you've learned in regards to best practices.
2nd, that is the main reason why you have a job.
3rd, If 3 out of 5 people you work with are certifiably competent in their job function, you are one of the lucky ones.
And finally, if it's working, management will hesitate to change it. Larger companies usually have so much that is just plain broken, or crippled, they don't have the time or money to send their talent chasing after issues that ';work';, even if they do so with all the elegance of a drunken elephant.
All I can say is: You get used to it.
You're right not to go searching for another job...you'll likely find this type of environment nearly anywhere you go.eye color
Is it the Database Administrator? the Department Directors? The Executive Director? The CEO? The Board?
I need some input here, I just started a new job as The Database Admin. with a company whose database is very large and has had many hands in it with zero consistency. It is going to be a huge job to clean it up. I have been told it is my job to clean up the data base but I do not have the authority to change the way things are being done. Hence, one of the problems the way things are currently being done is why the data is not reliable. I have informed the Directories of this situation, their response was, the way things are being done is working, so let's not fix anything that's not broken.
I cannot quit I need a job and in this economy I.T. jobs are hard to find. Any suggestion on how to handle this situation?What position typically controls an organization database?
Dave,
You are correct that the DBA (Database Administrator) is the primary controller for the organization database. That includes how the database is structured, performance, and so on. The data, however, is controlled by the users and the adding, editing, and removal of data should be in the hands of the community.
In your situation, you are trying to cross the boundaries into the data. I would suggest producing some suggested changed and include a value proposition to the end user. There is no use saying that their data problems make your job difficult. Instead, attack the problem with a cost saving measure or a profit making measure. This is all VPs care about at the end of the day. If you can show them the value of changing their ways, things will be much easier.
On the database side. Make your life easier by creating better referential integrity between data tables and automated cleanup scripts.
Best of luck!What position typically controls an organization database?
Well, maybe you're in a situation where you have to demonstrate what you want to do. This is a suggestions and nothing more, so my advice is worth what you pay for it. ;-)
Build a new database schema (on ';paper';, first) based on the improvements you want to make. Then, create the new database an tables, and extract some of the existing data from the existing database and import/install it into the new database. Then preview it to management; maybe get the web development guys to gen up some web-based access to show how it works (I'm reaching here, since I don't know the details of your site).
If you demo to them the improvements you can make with small chunks of data, you might be able to sell them on a complete makeover. Also, explain to them that you can do it in parallel to existing operations and test with users are go build it out.
Good luck. Sounds like you have a real challenge. Don't get discouraged.
I don't mean any offense by this, and I apologize if I'm wrong...but you sound like you are relatively new to the IT professional world, am I right?
The only reason I say this is because everyone deals with this kind of thing. My first IT job was as a systems developer, I showed up with a million and one great ideas for how everything should work (all learned dutifully in college). I was set to optimize, normalize and standardize everything I could get my hands on.
It took me a few days to come to the reality of things:
1st, NOTHING is as it ';should'; be, according to what you've learned in regards to best practices.
2nd, that is the main reason why you have a job.
3rd, If 3 out of 5 people you work with are certifiably competent in their job function, you are one of the lucky ones.
And finally, if it's working, management will hesitate to change it. Larger companies usually have so much that is just plain broken, or crippled, they don't have the time or money to send their talent chasing after issues that ';work';, even if they do so with all the elegance of a drunken elephant.
All I can say is: You get used to it.
You're right not to go searching for another job...you'll likely find this type of environment nearly anywhere you go.
Problems running Access Databases! Locking/inability to control and maintain, and manage users, the growth?
Can I migrate to SQL 2000 or 2005?Problems running Access Databases! Locking/inability to control and maintain, and manage users, the growth?
You can migrate to SQL 2000 or 2005. You can even start using Oracle, as a vamp yahoo user told you to. But the question is, do you really need to migrate?
The locking/inability problems are solved in the Access Startup Menu, where you can set things like refresh time interval between a change in a record made by a user and the time need to the change to be seen across all access database users. Have you explored all the Access database features?
Speaking of my experience, I have a small Access database with about 20 000 entries, and no such problems are happening with me.Problems running Access Databases! Locking/inability to control and maintain, and manage users, the growth?
Note that you can migrate the *data* to SQL 2005, even the free version, and continue to use Access as a front end for queries and to develop applications.
If you are developing applications, you should look at the free version of Visual Basic 2005. It's an easy way to write simple database applications.
Dear, I'd suggest Oracle ;)
MS-SQL 2000/2005 is your easiest migration path.
for other options:
Oracle or Postgres would outperform and MS-SQL Solution
MySQL is ok for quick projects but won't scale as reaily as Oracle of PG
Obviously you should go to a more heavy duty database. You will get suggestions based on preferance but SQL 2005 or Oracle should resolve your problems as Access is not a good choice for multi-user scalable databases.
You can migrate to SQL 2000 or 2005. You can even start using Oracle, as a vamp yahoo user told you to. But the question is, do you really need to migrate?
The locking/inability problems are solved in the Access Startup Menu, where you can set things like refresh time interval between a change in a record made by a user and the time need to the change to be seen across all access database users. Have you explored all the Access database features?
Speaking of my experience, I have a small Access database with about 20 000 entries, and no such problems are happening with me.Problems running Access Databases! Locking/inability to control and maintain, and manage users, the growth?
Note that you can migrate the *data* to SQL 2005, even the free version, and continue to use Access as a front end for queries and to develop applications.
If you are developing applications, you should look at the free version of Visual Basic 2005. It's an easy way to write simple database applications.
Dear, I'd suggest Oracle ;)
MS-SQL 2000/2005 is your easiest migration path.
for other options:
Oracle or Postgres would outperform and MS-SQL Solution
MySQL is ok for quick projects but won't scale as reaily as Oracle of PG
Obviously you should go to a more heavy duty database. You will get suggestions based on preferance but SQL 2005 or Oracle should resolve your problems as Access is not a good choice for multi-user scalable databases.
1.write a suitable VBprogramming using data control with add,save,edit,delete,options through database cont.op
2.If any body know about the calculator programing in foxpro and the programing of salery distribution of a particuler dipartment or the bank in the visual Basic,then please send me to my email ID before 31st january as soon as possible. my ID is asilawat@yahoo.com1.write a suitable VBprogramming using data control with add,save,edit,delete,options through database cont.op
May be you can contact a foxpro expert at website like http://askexpert.info/
May be you can contact a foxpro expert at website like http://askexpert.info/
Solution to gun control: Bullet Database?
Before a gun can be sold, it first has to be fired the bullet collected and entered into a national database.
We have a national fingerprint database why not a bullet database?Solution to gun control: Bullet Database?
But my fingerprints are not put into that database until I commit a crime and processed for charges or become a civil servant of sorts.
So leave me, my guns, and my ammo to ourselves.
What part of shall not be infringed do people not understand.
Gun Control Defined.......
A theory espoused by some people; who claim to believe, against all logic and
common sense, that a violent predator who ignores the laws prohibiting them from robbing, raping, kidnapping, torturing and killing their fellow human beings will obey a law telling them that they cannot own a gun.
http://www.youtube.com/user/DOUGandFRIEN鈥?/a>Solution to gun control: Bullet Database?
It's been tried in New York and Maryland. After a few years, the police departments were begging the state legislators to repeal the law. It was costing them millions of dollars to maintain the database and not one single crime had ever been solved by it. They have much better uses for the money.
The reason it doesn't work is there's no such thing as a ballistic fingerprint. The patterns on your fingers are built into your body and they don't change. Guns are just pieces of metal. They wear and change every time they're fired. Two bullets fired from the same gun with five hundred rounds between them won't match. If you're in a hurry, running a piece of sandpaper down the barrel a few times will have the same effect.
Further, criminals buy their guns on the black market, not from gun shops. So, even if the gun is in the database, its information won't point to the criminal, only the last legal owner.
Barrels are easily changed, in many pistols, removing the barrel is part of the cleaning process. I can change the barrel in a Colt 1911 in under one minute, and replacement barrels can be had for as little as $30. In fact, I know people that keep spare barrels around so that if they shoot someone they can dispose of the used barrel.
From a more practical point, a match of a bullet to one in the database would prove only one thing, that the barrel in the gun at the time of the shooting was from a particular lot of barrels. A barrel is made by drilling a hole through the barrel blank, and then drawing a tool known as a broach to cut the rifling. These tools will cut hundreds of barrels without substantial wear, so the only thing that could be said about that bullet is that it came from manufacturer X, and was made between date Y and date Z. In other words, it is one of about 1000 to 3000 barrels.
As to your database, several states in the union have a law requiring a fired case to be sent to the state police when a new gun is sold. These fired cases are then supposed to be used to allow a trace of the gun in case of a crime. This has been going on for over a decade, and to my knowledge, no crime had ever been solved by matching one of these cases. This system has had an impact on crime in one way, it has taken money and manpower off the street, undoubtedly increasing crime. It has also worked as a tax on all honest law abiding citizens, which in my eyes is criminal.
If you want to effect a reduction in crime, call your local DA and insist that he apply all laws relating to the criminal using a gun. In most cases these laws are the first that are plea bargained out.
Unless someone commits a crime or goes into the military or works for the government they aren't in the national fingerprint database. Your proposal makes the assumption that all guns are potential crime tools. Seems like unreasonable search and seizure to me, yet another attack on the Bill of Rights.
Unfortunately the criminals don't buy their guns from legitimate gun shops and they're the people who need their guns taken away, not the average hard working, tax paying, law abiding citizen. So the billions that would go into that program would be a waste of money because probably 99% of those bullets tested will never surface in a crime.
The states nor general government needs a database on gun owners.
Why not a database of freedom hating liberals.
That's been tried in New York at the state level, with no useful results.
That would be too easy to get around.
Although a gun database would help.
Do you know how easy it is to change out a barrel?
We have a national fingerprint database why not a bullet database?Solution to gun control: Bullet Database?
But my fingerprints are not put into that database until I commit a crime and processed for charges or become a civil servant of sorts.
So leave me, my guns, and my ammo to ourselves.
What part of shall not be infringed do people not understand.
Gun Control Defined.......
A theory espoused by some people; who claim to believe, against all logic and
common sense, that a violent predator who ignores the laws prohibiting them from robbing, raping, kidnapping, torturing and killing their fellow human beings will obey a law telling them that they cannot own a gun.
http://www.youtube.com/user/DOUGandFRIEN鈥?/a>Solution to gun control: Bullet Database?
It's been tried in New York and Maryland. After a few years, the police departments were begging the state legislators to repeal the law. It was costing them millions of dollars to maintain the database and not one single crime had ever been solved by it. They have much better uses for the money.
The reason it doesn't work is there's no such thing as a ballistic fingerprint. The patterns on your fingers are built into your body and they don't change. Guns are just pieces of metal. They wear and change every time they're fired. Two bullets fired from the same gun with five hundred rounds between them won't match. If you're in a hurry, running a piece of sandpaper down the barrel a few times will have the same effect.
Further, criminals buy their guns on the black market, not from gun shops. So, even if the gun is in the database, its information won't point to the criminal, only the last legal owner.
Barrels are easily changed, in many pistols, removing the barrel is part of the cleaning process. I can change the barrel in a Colt 1911 in under one minute, and replacement barrels can be had for as little as $30. In fact, I know people that keep spare barrels around so that if they shoot someone they can dispose of the used barrel.
From a more practical point, a match of a bullet to one in the database would prove only one thing, that the barrel in the gun at the time of the shooting was from a particular lot of barrels. A barrel is made by drilling a hole through the barrel blank, and then drawing a tool known as a broach to cut the rifling. These tools will cut hundreds of barrels without substantial wear, so the only thing that could be said about that bullet is that it came from manufacturer X, and was made between date Y and date Z. In other words, it is one of about 1000 to 3000 barrels.
As to your database, several states in the union have a law requiring a fired case to be sent to the state police when a new gun is sold. These fired cases are then supposed to be used to allow a trace of the gun in case of a crime. This has been going on for over a decade, and to my knowledge, no crime had ever been solved by matching one of these cases. This system has had an impact on crime in one way, it has taken money and manpower off the street, undoubtedly increasing crime. It has also worked as a tax on all honest law abiding citizens, which in my eyes is criminal.
If you want to effect a reduction in crime, call your local DA and insist that he apply all laws relating to the criminal using a gun. In most cases these laws are the first that are plea bargained out.
Unless someone commits a crime or goes into the military or works for the government they aren't in the national fingerprint database. Your proposal makes the assumption that all guns are potential crime tools. Seems like unreasonable search and seizure to me, yet another attack on the Bill of Rights.
Unfortunately the criminals don't buy their guns from legitimate gun shops and they're the people who need their guns taken away, not the average hard working, tax paying, law abiding citizen. So the billions that would go into that program would be a waste of money because probably 99% of those bullets tested will never surface in a crime.
The states nor general government needs a database on gun owners.
Why not a database of freedom hating liberals.
That's been tried in New York at the state level, with no useful results.
That would be too easy to get around.
Although a gun database would help.
Do you know how easy it is to change out a barrel?
Can anyone direct me to a site where i can get access database templates for inventory controls?
I was searched answer for ur question that Inventory Control in Microsoft Access. Finally i got the answer for ur question. Below their is a link. It is Microsoft Site only so don't worry about spams.
In that site their is free Inventory Control Templete.
I hope this will be very much useful for u.
http://office.microsoft.com/en-us/results.aspx?Scope=TC%26amp;Query=inventory+control
Thanks %26amp; Regards
Siva...Can anyone direct me to a site where i can get access database templates for inventory controls?
go to microsoft support for access, they have a lot of templates for everythingCan anyone direct me to a site where i can get access database templates for inventory controls?
You can try microsoft templates, it maybe something there that can help you.
In that site their is free Inventory Control Templete.
I hope this will be very much useful for u.
http://office.microsoft.com/en-us/results.aspx?Scope=TC%26amp;Query=inventory+control
Thanks %26amp; Regards
Siva...Can anyone direct me to a site where i can get access database templates for inventory controls?
go to microsoft support for access, they have a lot of templates for everythingCan anyone direct me to a site where i can get access database templates for inventory controls?
You can try microsoft templates, it maybe something there that can help you.
Did Chertoff use 'criminal databases' to mind/thought control entire family and friends in US?
That permise seems a bit odd to me.Did Chertoff use 'criminal databases' to mind/thought control entire family and friends in US?
Okay, 24-hour X-Files marathons are clearly not healthy for you. That, and the dope.Did Chertoff use 'criminal databases' to mind/thought control entire family and friends in US?
He's only half jewish, hence he only controls half your brain, dtop taking Xanax
Okay, 24-hour X-Files marathons are clearly not healthy for you. That, and the dope.Did Chertoff use 'criminal databases' to mind/thought control entire family and friends in US?
He's only half jewish, hence he only controls half your brain, dtop taking Xanax
I have a research about security and access control in web databases.I want some free ebooks and pdf about it?
Where can I find them? please help me.I have a research about security and access control in web databases.I want some free ebooks and pdf about it?
Do an advanced google search (click here):
http://www.google.com/advanced_search?hl鈥?/a>
Where it says ';file type'; on the right side, click on the down arrow and select: pdf
Then type what you are looking for. Your results will only be .pdf files which will narrow your results down for you. As far as ebooks are concerned, the only thing I can suggest is use the advanced search again.
1. Type ebooks
2. Click on search
3. Scroll down to bottom of page of the google search result then click on ';search within results';.
After that, enter your search terms. This will narrow down your results to only include those which have ebook in the title.
I hope this helps!eye color
Do an advanced google search (click here):
http://www.google.com/advanced_search?hl鈥?/a>
Where it says ';file type'; on the right side, click on the down arrow and select: pdf
Then type what you are looking for. Your results will only be .pdf files which will narrow your results down for you. As far as ebooks are concerned, the only thing I can suggest is use the advanced search again.
1. Type ebooks
2. Click on search
3. Scroll down to bottom of page of the google search result then click on ';search within results';.
After that, enter your search terms. This will narrow down your results to only include those which have ebook in the title.
I hope this helps!
Do sites with usernames and passwords such as yahoo and myspace use php and mysql to control their databases?
or javascript or whattttttt. i just bought a book on PHP mysql and apache, because i want to start a site where users can log in and access information about a club. and i want them to be able to have profiles. how!
i have the cd which has PHP, my SQL, and apache starter kit.
i'll give you 10 points for a wonderful answer.
or at least not a crappy one. :)Do sites with usernames and passwords such as yahoo and myspace use php and mysql to control their databases?
The short answer is Maybe. It is difficult to tell exactly what each site is running with respect to user management, as it is easy to hide the information that would tell us what they are using. Alot of the big commercial sites, such as yahoo, google, etc, are using more customized, and proprietary technology to manage their userbase. However, if you are a modest developer, who does not have a few million to spend on creating a redundant database structure, clustering a few boxes (or few hundred in google's case) then stick to PHP and MySQL, as you will be able to get the results you want, at a price point that is very attractive ($0!) and you will get near enterprise performance :) Hope this was helpful!Do sites with usernames and passwords such as yahoo and myspace use php and mysql to control their databases?
yes, well, basically. I'm not sure exactly what they use but I can guarantee they use a server scripting language and SQL of some form.
Might not be php and mysql specifically, could be another language and another database, but the basic principles are the same.
However if you have never done any web programming before take your time working through things, security and user management are not simple things.
i have the cd which has PHP, my SQL, and apache starter kit.
i'll give you 10 points for a wonderful answer.
or at least not a crappy one. :)Do sites with usernames and passwords such as yahoo and myspace use php and mysql to control their databases?
The short answer is Maybe. It is difficult to tell exactly what each site is running with respect to user management, as it is easy to hide the information that would tell us what they are using. Alot of the big commercial sites, such as yahoo, google, etc, are using more customized, and proprietary technology to manage their userbase. However, if you are a modest developer, who does not have a few million to spend on creating a redundant database structure, clustering a few boxes (or few hundred in google's case) then stick to PHP and MySQL, as you will be able to get the results you want, at a price point that is very attractive ($0!) and you will get near enterprise performance :) Hope this was helpful!Do sites with usernames and passwords such as yahoo and myspace use php and mysql to control their databases?
yes, well, basically. I'm not sure exactly what they use but I can guarantee they use a server scripting language and SQL of some form.
Might not be php and mysql specifically, could be another language and another database, but the basic principles are the same.
However if you have never done any web programming before take your time working through things, security and user management are not simple things.
I want to connect oracle 8i database to jsp,i need the code nd wat should b done in control settings.?
actually iam developing a weather portal,where if i click today button-it should display todays temperature,rainfall and humidity. the temp,rainfall and humidity will be stored in oracle database.in need a step by step procedure to connect oracle 8i database to jsp.how to set up a connection in control settings.and the code to be included in jsp page.
i am using tomcat webserver. i actually should complete this project in a month ,if u can give the complete code it would be very useful.plssssssssssssssss,thanks in advance.I want to connect oracle 8i database to jsp,i need the code nd wat should b done in control settings.?
Get Widgets (or whatever you call them) instead. They are already programmed for you. Duh!
i am using tomcat webserver. i actually should complete this project in a month ,if u can give the complete code it would be very useful.plssssssssssssssss,thanks in advance.I want to connect oracle 8i database to jsp,i need the code nd wat should b done in control settings.?
Get Widgets (or whatever you call them) instead. They are already programmed for you. Duh!
How do I use the create user asp.net control and connect it to a SQL Server database?
I had configured my registration page to sql server express. The webhost Daily Razor does not support it. Since this is not my area of expertise, I am trying to find a way to code the already existing page to connect to either a MYSQL database or a SQL Server database and not have to write code all over again
This is the code I have right now
Protected Sub CreateUserWizard1_CreatedUser(ByVal sender As Object, ByVal e As System.EventArgs)
End Sub
%26lt;/script%26gt;
%26lt;asp:Content ID=';Content1'; ContentPlaceHolderID=';ContentPlaceHolder鈥?Runat=';Server';%26gt;
%26lt;asp:CreateUserWizard ID=';CreateUserWizard1'; runat=';server';
FinishDestinationPageUrl=';~/Registration Confirmation1.aspx';
InvalidPasswordErrorMessage=';Password length minimum: {6}. Non-alphanumeric characters required: {1}.';
style=';color: #003399; font-weight: 700';%26gt;
%26lt;WizardSteps%26gt;
%26lt;asp:CreateUserWizardStep runat=';server';%26gt;
HELP!!!!!How do I use the create user asp.net control and connect it to a SQL Server database?
MySQL works best with php
This is the code I have right now
Protected Sub CreateUserWizard1_CreatedUser(ByVal sender As Object, ByVal e As System.EventArgs)
End Sub
%26lt;/script%26gt;
%26lt;asp:Content ID=';Content1'; ContentPlaceHolderID=';ContentPlaceHolder鈥?Runat=';Server';%26gt;
%26lt;asp:CreateUserWizard ID=';CreateUserWizard1'; runat=';server';
FinishDestinationPageUrl=';~/Registration Confirmation1.aspx';
InvalidPasswordErrorMessage=';Password length minimum: {6}. Non-alphanumeric characters required: {1}.';
style=';color: #003399; font-weight: 700';%26gt;
%26lt;WizardSteps%26gt;
%26lt;asp:CreateUserWizardStep runat=';server';%26gt;
HELP!!!!!How do I use the create user asp.net control and connect it to a SQL Server database?
MySQL works best with php
Why I cann't attach my database in Access 2000 to the form using Dara Control in VB6?
In the book of VB6, examples are there to connect the sample databases supplied with the Access/VB using data control which works fine while I practice. But while trying to attach my own database created by Access 2000 by data control, it says ';Unrecognised database format';. How to get the connection?Why I cann't attach my database in Access 2000 to the form using Dara Control in VB6?
You'll need to use ADO to connect to an Access2000 mdb. There's an ADO control or you can do it in code. Here's smple code to get you started:
Dim Db as Connection
Dim SQLStatement as String
Set Db = New Connection
Db.CursorLocation = adUseClient
Db.Open gDSN
SQLStatement = ';Select ...';
Set adoSalesPerson = New Recordset
adoSalesPerson.Open SQLStatement, Db, adOpenStatic, adLockOptimistic
If adoSalesPerson.RecordCount %26gt; 0 ThenWhy I cann't attach my database in Access 2000 to the form using Dara Control in VB6?
I may be wrong, but from memory, youcan only use Access97 database with VB6, I heard of an update or patch for it to work with Access2000, or even using newer ODBC drivers, but never tried.
You'll need to use ADO to connect to an Access2000 mdb. There's an ADO control or you can do it in code. Here's smple code to get you started:
Dim Db as Connection
Dim SQLStatement as String
Set Db = New Connection
Db.CursorLocation = adUseClient
Db.Open gDSN
SQLStatement = ';Select ...';
Set adoSalesPerson = New Recordset
adoSalesPerson.Open SQLStatement, Db, adOpenStatic, adLockOptimistic
If adoSalesPerson.RecordCount %26gt; 0 ThenWhy I cann't attach my database in Access 2000 to the form using Dara Control in VB6?
I may be wrong, but from memory, youcan only use Access97 database with VB6, I heard of an update or patch for it to work with Access2000, or even using newer ODBC drivers, but never tried.
Do American border control have access to British criminal database?
Unfortunately in my misspent youth I got convicted of possession of a class A drug. I was given 100 hours of community service. This was over 5 years ago and to my understanding is now a spent conviction.
I am travelling to the USA in August and the flights are already booked. I have read a lot of info into this and understand that I need an ESTA to fly to the US, and because of my spent conviction I am unable to get this. So I need to apply for a visa. Is this process difficult? And does it cost much money?
If the border control doesn鈥檛 have access to criminal database can I just not declare this spent conviction and use a ESTA form and not apply for a VISA?
Sorry this is several questions. Advice would be greatly appreciated.Do American border control have access to British criminal database?
Yes, drug offenses are accessible. If you lie about it, you will not only be caught., you will be charged under US law with violating their immigration laws, a Federal Felony.
Don't compound one problem with a more serious one. Apply for the proper visa. It's not terribly expensive, but it will take a significant amount of time. Contact the local Embassy for an estimate of how long. For a flight in August, I suspect you should get on it right away.
I am travelling to the USA in August and the flights are already booked. I have read a lot of info into this and understand that I need an ESTA to fly to the US, and because of my spent conviction I am unable to get this. So I need to apply for a visa. Is this process difficult? And does it cost much money?
If the border control doesn鈥檛 have access to criminal database can I just not declare this spent conviction and use a ESTA form and not apply for a VISA?
Sorry this is several questions. Advice would be greatly appreciated.Do American border control have access to British criminal database?
Yes, drug offenses are accessible. If you lie about it, you will not only be caught., you will be charged under US law with violating their immigration laws, a Federal Felony.
Don't compound one problem with a more serious one. Apply for the proper visa. It's not terribly expensive, but it will take a significant amount of time. Contact the local Embassy for an estimate of how long. For a flight in August, I suspect you should get on it right away.
Does hosting services provide control panels usuaully to modify database?
Our clients commercial website is hosted on hosting server which MARKETING PEOPLE CHOSE. Hosting server don't have anything like control panel. I had to do all research from beginning. I connect to website by ftp. To change database I have created php template %26amp; change queries in it like 'alter table add column', or insert values in table. I have linked mysql database to ms access on my computer %26amp; every time I add new column, I had to do link tables process all over again. I can't test sql queries in access because it's linked table %26amp; there is lot of confusion between datatypes or mysql %26amp; MSAccess. I am finding myself wasting lot of time on hosting related issues than actually working to fix website related code. Is it normal? If we chose good hosting plan do they provide control panel where we can view %26amp; MODIFY MYSQL DATABASE DIRECTLY.
THANK YOU.Does hosting services provide control panels usuaully to modify database?
Your webhosting provider sucks,most web hoster provides a control panel to modify database ,etc.
Try web hosting from website like http://aplis.net/ , first month free.eye color
THANK YOU.Does hosting services provide control panels usuaully to modify database?
Your webhosting provider sucks,most web hoster provides a control panel to modify database ,etc.
Try web hosting from website like http://aplis.net/ , first month free.
1.write a suitable VBprogramming using data control with add,save,edit,delete,options through database cont.op
2.If any body know about the calculator programing in foxpro and the programing of salery distribution of a particuler dipartment or the bank in the visual Basic,then please send me to my email ID before 31st january as soon as possible. my ID is asilawat@yahoo.com1.write a suitable VBprogramming using data control with add,save,edit,delete,options through database cont.op
So you think we are here to do your home-works?
Try to do yourself man. Then only you will grow.
So you think we are here to do your home-works?
Try to do yourself man. Then only you will grow.
Can you pl. tell me which is the fast openining control and view in VB6 for searching records from a database?
i think ADO can connect database as fast
http://www.developer-exchange.com
http://www.developer-exchange.com
Is it possible to write vb code to connect to an MSaccess database WITHOUT putting the DB control on the form?
I don't want to put the DB control on any form of the project. Nor do I want to enter the provider details in any form property box.
1. I have seen some projects which achieve this. Can any one provide some sample code / guidelines for this?
2. Is it possible to hide any control once it is in the form, when in design view mode (during run time one can hide it).?
3. Is it possible to enter a property value and then make it invisible to anyone elese who opens the property window of the form?Is it possible to write vb code to connect to an MSaccess database WITHOUT putting the DB control on the form?
Absolutely. You can use DAO to access any/all data in tables or queries saved in a .mdb file. You need not use any forms or whatever in the .mdb file; in fact, there need be only tables. For a tutorial, see ';Using DAO for data access in your VB apps'; at http://articles.techrepublic.com.com/510鈥?/a>
DAO (and other data access methods) don't require any controls per se; you connect to the database file and execute data access functions directly.
1. I have seen some projects which achieve this. Can any one provide some sample code / guidelines for this?
2. Is it possible to hide any control once it is in the form, when in design view mode (during run time one can hide it).?
3. Is it possible to enter a property value and then make it invisible to anyone elese who opens the property window of the form?Is it possible to write vb code to connect to an MSaccess database WITHOUT putting the DB control on the form?
Absolutely. You can use DAO to access any/all data in tables or queries saved in a .mdb file. You need not use any forms or whatever in the .mdb file; in fact, there need be only tables. For a tutorial, see ';Using DAO for data access in your VB apps'; at http://articles.techrepublic.com.com/510鈥?/a>
DAO (and other data access methods) don't require any controls per se; you connect to the database file and execute data access functions directly.
In visual basic 6, how can u bind a datagrid control to the ms access database usng manual coding adodb?
Private Sub Form_Activate()
Set GRID.DataSource = REC
End Sub
that is my code but it wont work. the error is : the rowset is not bookmarkable. pls send me the correct code. thanks a lot.In visual basic 6, how can u bind a datagrid control to the ms access database usng manual coding adodb?
This is an unbound method. It works for me. Hope this helps you too.
Dim Mycon As New ADODB.Connection
Dim M1 As New ADODB.Recordset
Dim S1 As String
S1 = ';Provider=Microsoft.Jet.OLEDB.4.0;'; %26amp; _
';Data Source='; %26amp; _
App.Path %26amp; ';A.mdb';
Mycon.Open S1
M1.Open ';select * from B';, Mycon, adOpenDynamic, adLockOptimistic
Dim c As Integer
Dim r As Integer
Dim col_wid() As Single
Dim field_wid As Single
' Use one fixed row and no fixed columns.
MSFlexGrid1.Rows = 2
MSFlexGrid1.FixedRows = 1
MSFlexGrid1.FixedCols = 0
' Display column headers.
MSFlexGrid1.Rows = 1
MSFlexGrid1.Cols = M1.Fields.Count
ReDim col_wid(0 To M1.Fields.Count - 1)
For c = 0 To M1.Fields.Count - 1
MSFlexGrid1.TextMatrix(0, c) = M1.Fields(c).Name
col_wid(c) = TextWidth(M1.Fields(c).Name)
Next c
' Display the values for each row.
r = 1
Do While Not M1.EOF
MSFlexGrid1.Rows = MSFlexGrid1.Rows + 1
For c = 0 To M1.Fields.Count - 1
MSFlexGrid1.TextMatrix(r, c) = _
M1.Fields(c).Value
' See how big the value is.
field_wid = TextWidth(M1.Fields(c).Value)
If col_wid(c) %26lt; field_wid Then col_wid(c) = _
field_wid
Next c
M1.MoveNext
r = r + 1
Loop
' Set the column widths.
For c = 0 To MSFlexGrid1.Cols - 1
MSFlexGrid1.ColWidth(c) = col_wid(c) + 240
Next c
' Close the recordset and connection.
M1.Close
Mycon.CloseIn visual basic 6, how can u bind a datagrid control to the ms access database usng manual coding adodb?
hello!......he asked for a data grid control and not a flex grid control you DUH!
Set GRID.DataSource = REC
End Sub
that is my code but it wont work. the error is : the rowset is not bookmarkable. pls send me the correct code. thanks a lot.In visual basic 6, how can u bind a datagrid control to the ms access database usng manual coding adodb?
This is an unbound method. It works for me. Hope this helps you too.
Dim Mycon As New ADODB.Connection
Dim M1 As New ADODB.Recordset
Dim S1 As String
S1 = ';Provider=Microsoft.Jet.OLEDB.4.0;'; %26amp; _
';Data Source='; %26amp; _
App.Path %26amp; ';A.mdb';
Mycon.Open S1
M1.Open ';select * from B';, Mycon, adOpenDynamic, adLockOptimistic
Dim c As Integer
Dim r As Integer
Dim col_wid() As Single
Dim field_wid As Single
' Use one fixed row and no fixed columns.
MSFlexGrid1.Rows = 2
MSFlexGrid1.FixedRows = 1
MSFlexGrid1.FixedCols = 0
' Display column headers.
MSFlexGrid1.Rows = 1
MSFlexGrid1.Cols = M1.Fields.Count
ReDim col_wid(0 To M1.Fields.Count - 1)
For c = 0 To M1.Fields.Count - 1
MSFlexGrid1.TextMatrix(0, c) = M1.Fields(c).Name
col_wid(c) = TextWidth(M1.Fields(c).Name)
Next c
' Display the values for each row.
r = 1
Do While Not M1.EOF
MSFlexGrid1.Rows = MSFlexGrid1.Rows + 1
For c = 0 To M1.Fields.Count - 1
MSFlexGrid1.TextMatrix(r, c) = _
M1.Fields(c).Value
' See how big the value is.
field_wid = TextWidth(M1.Fields(c).Value)
If col_wid(c) %26lt; field_wid Then col_wid(c) = _
field_wid
Next c
M1.MoveNext
r = r + 1
Loop
' Set the column widths.
For c = 0 To MSFlexGrid1.Cols - 1
MSFlexGrid1.ColWidth(c) = col_wid(c) + 240
Next c
' Close the recordset and connection.
M1.Close
Mycon.CloseIn visual basic 6, how can u bind a datagrid control to the ms access database usng manual coding adodb?
hello!......he asked for a data grid control and not a flex grid control you DUH!
Report Abuse
Which Logitech Harmony remote models will be able to control ';any'; of their database of codes?
I know some of the Harmony remotes can download newer codes as they become available. Which models can or can not access the full spectrum of codes?
I ask because some older Harmonys are available for a much lower price. Since they are not likely to natively support some devices, will they still be able to download codes for devices when we don't have the original remotes to ';learn'; from?
Also, can Harmony remotes save profiles they ';learn'; to the PC? I ask in case I ever upgrade remotes or otherwise the remote fails and has to be re-programmed. I'm wondering if I could borrow a remote from someone and make a profile from it that I would always have to keep.
There is a lot of information available but it's hard to wade through to just get these basic questions answered.Which Logitech Harmony remote models will be able to control ';any'; of their database of codes?
As long the remote has a USB interface, it can access the whole database through your PC. I think all Harmony remotes support that.
Yes, your profile is saved on your Harmony account and on your PC.
I ask because some older Harmonys are available for a much lower price. Since they are not likely to natively support some devices, will they still be able to download codes for devices when we don't have the original remotes to ';learn'; from?
Also, can Harmony remotes save profiles they ';learn'; to the PC? I ask in case I ever upgrade remotes or otherwise the remote fails and has to be re-programmed. I'm wondering if I could borrow a remote from someone and make a profile from it that I would always have to keep.
There is a lot of information available but it's hard to wade through to just get these basic questions answered.Which Logitech Harmony remote models will be able to control ';any'; of their database of codes?
As long the remote has a USB interface, it can access the whole database through your PC. I think all Harmony remotes support that.
Yes, your profile is saved on your Harmony account and on your PC.
How do you control access to individua; records in yahoo group database?
Management, then Web Tools, and there are option for editing links, database, archives, etc. Just set the database for moderators only if you only want to keep members out. I don't think it can be done individually... either the database is open to members or it is not.eye color
How can we update record in database using Details view control in asp.net?
Hai ! Professional
I am doing one project regarding a elearn course.
i that in i faced one problem is when i click the edit button on the detail view control of asp.net on runtime, it cause some error regarding a update command. Can any one share a code for updating a record to data base by using detail view control in asp.net.
please it more and very urgent i want to finish my project in 2 days.
help plz.How can we update record in database using Details view control in asp.net?
http://quickstarts.asp.net/QuickStartv20鈥?/a>
Let me know if you have any issues !!!
I am doing one project regarding a elearn course.
i that in i faced one problem is when i click the edit button on the detail view control of asp.net on runtime, it cause some error regarding a update command. Can any one share a code for updating a record to data base by using detail view control in asp.net.
please it more and very urgent i want to finish my project in 2 days.
help plz.How can we update record in database using Details view control in asp.net?
http://quickstarts.asp.net/QuickStartv20鈥?/a>
Let me know if you have any issues !!!
What is linux, control unit, registers. eeprom, database, bus, lan, wan, man?
Linux is a computer operating system and its kernel, which also happens to be free and open-source.
Control Unit- part of a CPU or other device that directs its operation.
Hardware register- a placeholder for information about some hardware condition, configuration, or buffer
Processor register- a component inside a central processing unit for storing information, such as a memory address, or the inputs or results of a computation
eeprom- Electrically-Erasable Programmable Read-Only Memory
bus - subsystem that transfers data or power between computer components inside a computer or between computers
LAN - Local Area Network
WAN - Wide Area Network or Wireless Area Network
Control Unit- part of a CPU or other device that directs its operation.
Hardware register- a placeholder for information about some hardware condition, configuration, or buffer
Processor register- a component inside a central processing unit for storing information, such as a memory address, or the inputs or results of a computation
eeprom- Electrically-Erasable Programmable Read-Only Memory
bus - subsystem that transfers data or power between computer components inside a computer or between computers
LAN - Local Area Network
WAN - Wide Area Network or Wireless Area Network
Which databases provide the best concurrency control?
hi,
I am working on a dissertation and i need to know which databases provide the best concurrence control. i am doing a comparison between Oracle, Ms SQL Server, MySQL, PostGre SQL and Ms Access. Please do help
ThanksWhich databases provide the best concurrency control?
MS SQL
I am working on a dissertation and i need to know which databases provide the best concurrence control. i am doing a comparison between Oracle, Ms SQL Server, MySQL, PostGre SQL and Ms Access. Please do help
ThanksWhich databases provide the best concurrency control?
MS SQL
I'm currently doing my vb6 database project. And i need the ADODC control.?
However, it's not in the project components. Where can i download it?I'm currently doing my vb6 database project. And i need the ADODC control.?
It's ADODB not ADOBC, and its already installed with VB6.I'm currently doing my vb6 database project. And i need the ADODC control.?
Go to project (from the main menu at the top) then
Choose Components
Scroll through the components and find
Microsoft ADO data control 6.0 and select it
It has to be there..look carefully
Or reinstall VB 6.0
It's ADODB not ADOBC, and its already installed with VB6.I'm currently doing my vb6 database project. And i need the ADODC control.?
Go to project (from the main menu at the top) then
Choose Components
Scroll through the components and find
Microsoft ADO data control 6.0 and select it
It has to be there..look carefully
Or reinstall VB 6.0
I need help setting up a the database in the host's control panel. i am tryin to setup a forum with pbphh2....
Click the mysql databases icon on the cpanel main page. there you will find the tools you need to create databases and database users.
Subscribe to:
Posts (Atom)