473,765 Members | 1,963 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Regarding Database-Reply early-Urgent #1

95 New Member
In Vb we can connect to all the databases like SQL 2000/SQL 2005,Oracle,Acc ess.
Out of the given databses we can connect to which databases.

Secondly,told me dat if I want to connect to SQL-any version(2000/2005), To connect to the database i go to
Control Panel-->Admintrative Tools-->Data sources(ODBC)-->ODBC Data source Administrator Screen cones,4m which I click on ADD Button--> Now tell me to coonect to SQL,From CREATE NEW DATASOUCE, which option I have to choose.

Plz Reply early,Its urgent.
Apr 7 '08 #1
1 910
debasisdas
8,127 Recognized Expert Expert
You can connect to any of the SQL 2000/SQL 2005,Oracle,Acc ess.

It is not compulsary to use DSN.

Try using the OLEDB providers.
Apr 8 '08 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

4
1819
by: Francis Lavoie | last post by:
Hello I have some questions regarding webframework, I must say that I quite lost and these questions are basicly to help me understand the way it work. I have some knowledge with PHP and JSP. I have looked for a python web framework to build a web site, a site that I had start in php (and quite finish), but for some reason I wont explain, I lost everything. I have started writting app with python 6
4
3920
by: Azhar Bilgrami | last post by:
Dear Hi: Hope to see u in good health. " I want to migrate a database which is currently running Unix as Operating System and Oracle ver 6 as Database, it is also using oracle froms version 3 (text base) as Front End" Now here is what I want to do " I want to migrate that database from Oracle for Unix to Oracle for Linux With retaining all the Forms, in other words all I want
2
1585
by: Rune Lanton | last post by:
Hello! I am developing an application for PPC2003, and I want too put my SQL CE db on a flash card. But I'm a little concerned about flash lifetime! Most flash memory have a limit of 100.000 write/delete cycles, and I'm wondering if this could cause any problems... Is there any kind of 'wear leveling' built into Windows CE which affects the number of effective write/delete cycles, and if there is, how effective is it??
0
3185
by: Bryan Ax | last post by:
Quick question regarding best practices for using the AspState database for storing session variables in .NET web applications. I know I need to configure the web.config file with a database user account that can not only execute stored procedures in the AspState database, but the account needs to be able to create temporary tables, etc. as well. What do others typically do for this? Obviously, I don't want to use my sa account for this...
3
1542
by: meenu_susi | last post by:
doubt regarding shopping cart...in asp i have a page where user purchase the product.. here i have the product as tshirt.. and for ex..i have shirt sizes as follows s m l xl xxl and for each sizes there will be a text box for the user input
5
2943
by: Ted | last post by:
I am working on two versions of an application, one of which will be a windows forms application (which will need to be redistributable) and the other will be a web application. I have MS Visual Studio 2005 (along with the developer's edition of MS SQL Server), but not MS Access. I also have MySQL, PostgreSQL, Sun's application server, Tomcat and Apache web server. I am working on Windows XP Pro, and have installed the .NET 3 SDK and...
0
1346
by: Splinter | last post by:
If i want to find the creation date of the database is it possible to get the information regarding this from ibdata1 file? Secondly is there any tool or reader that can read ibdata file? Help required. Kind regards
0
984
by: granjith3 | last post by:
hi, There are some questions in database like, what is servlet? how session implemented in servlet? brief RMI? what are the important JSP tags? And the user enters Servlet in the search box, then how to retrieve specific questions regarding servlet from database.
1
1526
by: Dave | last post by:
Hi guys, i have a small question regarding register_globals I have managed to change the way my forms work so they will process with register_globals turned off. However i have one page which enables staff to "browse" by product, which will list all products that begin with the letter they had chosen. On the return of this, i had previously used the results to form a
0
1375
by: mahesh123 | last post by:
Hi, I am new to use the crystal reports8.0. I am facing the problem regarding the database connection through the ADO Connection. Suppose my database name is "sample.pra"(due to some security reasons we will change the extension of the MS Access Database and there is a password for the opening the database). So that we cannot connect to the database. Please give the information regarding this problem as soon as possible...... Thanks &...
0
9568
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9399
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10163
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10007
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
9957
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
9835
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
6649
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5423
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
3532
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.