Question about Microsoft Visual Basic 6.0 for PC

2 Answers

Hw to link database using visual basic

If the database is stored in SQL server and the front end is designed in visual basic, how can this be linked.which connectivity like odbc,adodb etc supports this activity.please do give me the procedure as well as the hint of codes to link them at run time.......its an urgent please if anyone knows jst share your knowledge...............please..........

Posted by on

  • fixdash_08 Feb 12, 2009

    use adobc <------try this

    dim rs as new adobc.recordset
    dim cn as new adobc.connection

    private sub xn()
    cn.cursorlocation = aduseclient
    cn.open "CONNECTION STRING" <------
    end sub

    private sub form_load()
    if rs.state=adstateopen then rs.close
    rs.open "select * from TABLENAME" ,cn, adlockstatic, adlockreadonly
    if rs.recordcount > 0 then
    set datagrid1.datasource = rs
    end sub




×

2 Answers

  • Level 3:

    An expert who has achieved level 3 by getting 1000 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    Master:

    An expert who has achieved Level 3.

  • Master
  • 363 Answers

If you want to know more things about RSGold can go to this website www.rsgoldfast.com
Our service is the most professional and most secure and convenient

Posted on Nov 14, 2016

  • Level 1:

    An expert who has achieved level 1.

  • Contributor
  • 1 Answer

Use adobc <------try this

dim rs as new adobc.recordset
dim cn as new adobc.connection

private sub xn()
cn.cursorlocation = aduseclient
cn.open "CONNECTION STRING" <------
end sub

private sub form_load()
call xn
if rs.state=adstateopen then rs.close
rs.open "select * from TABLENAME" ,cn, adlockstatic, adlockreadonly
if rs.recordcount > 0 then
set datagrid1.datasource = rs
end sub

Posted on Feb 12, 2009

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

Sql server 2005 based databased and visual studio 2005 based software support ncomputing?


support microsoft com
Support ends 12 months after the next service pack releases or at the end of the product's support lifecycle, whichever comes first. For more information, please see the service pack policy at http://support.microsoft.com/lifecycle/#ServicePackSupport.

Feb 16, 2016 | NComputing L300 Terminal Computer PC...

6 Answers

Repair a corrupt SQL database in SQL 2005


Known as the leading solution provider in the field of data recovery and data conversions, the company has created a niche for another efficient tool known as SQL Server Repair Toolbox. The MS SQL repair tool reads *.mdf and *.ndf files and saves data, structure, links, etc. as SQL scripts or exports directly to Microsoft SQL Server through direct connect. read more details SQL Server Repair Toolbox

Jun 13, 2015 | Microsoft SQL Server 2005 Enterprise...

5 Answers

Some requirement for SQL server repair


Read this blog at the following link: http://recoverymaster.livejournal.com and know helpful details about MS SQL server database recovery wizard. You can download this software: http://www.sqlrecovery.org

Jun 10, 2014 | Microsoft Database Software A5K-02817 SQL...

15 Answers

How can I repair a corrupted MDF files and SQL server?


Similar question has been answered here: http://www.fixya.com/support/t24364927-sql_repair_recovery_process_very

Before asking any question in the forum, first you need to search your problem.

May 12, 2014 | Microsoft Database Software A5K-02817 SQL...

2 Answers

What is .sdf file


The .sdf or standard data file is used for storing data in a structured format; uses fields of fixed lengths to store values; can be imported and exported by various database and data analysis programs; commonly used for transferring data between different programs.

Sep 03, 2011 | Oracle 10g Database Standard (ODBSEONUPP0)

1 Answer

What is sql condition in visual basic?


sql is used for databases. Something like sql server, oracle, or access uses sql. It is a group of tables configured to reference eachother, so if you are programming in visual basic, you are trying to reference something on your sql server.

Feb 28, 2011 | Microsoft Xbox 360 Console

3 Answers

Visual Basic and SQL


Hi,

Visual Basic 6.0 and MS Sql server 7 or 2000 are highly compatible with each other. VB.net is compatable with sql 2005 which is inbuilt as well.

Jul 07, 2009 | Microsoft Windows Vista Ultimate Edition

2 Answers

Printing syntax


'declare the variables
Dim Connection
Dim ConnString
Dim Recordset
Dim SQL

'define the connection string, specify database driver
ConnString="DRIVER={SQL Server};SERVER=yourServername;UID=yourUsername;" & _
"PWD=yourPassword;DATABASE=yourDatabasename"

'declare the SQL statement that will query the database
SQL = "SELECT * FROM TABLE_NAME"

'create an instance of the ADO connection and recordset objects
Set Connection = Server.CreateObject("ADODB.Connection")
Set Recordset = Server.CreateObject("ADODB.Recordset")

'Open the connection to the database

Connection.Open ConnString

'Open the recordset object executing the SQL statement and return records
Recordset.Open SQL,Connection

'first of all determine whether there are any records
If Recordset.EOF Then
Response.Write("No records returned.")
Else
'if there are records then loop through the fields
Do While NOT Recordset.Eof
Response.write Recordset("FIRST_FIELD_NAME")
Response.write Recordset("SECOND_FIELD_NAME")
Response.write Recordset("THIRD_FIELD_NAME")
Response.write "<br>"
Recordset.MoveNext
Loop
End If


'close the connection and recordset objects to free up resources
Recordset.Close
Set Recordset=nothing
Connection.Close
Set Connection=nothing

May 16, 2009 | Microsoft Windows Vista Ultimate Edition

4 Answers

How get sql data backup


there is facility in enterprise manager to take back of database!

Feb 04, 2009 | Keystone Active Server Pages (ASP)/Visual...

1 Answer

SQL Server 2000


An easy way to transfer objects (tables, user defined functions, stored procedures, etc.) is to use Enterprise Manager's "Generate SQL" feature. Use this process at your own risk. Doing it wrong could mess up your existing database.

1. In Enterprise Manager, right-click on the old database and choose "All Tasks" then "Generate SQL Script".
2. In the dialog that comes up, click "Show All" then select the checkboxes for "all stored procedures" and "all user defined functions". (You might also want to check some other boxes, depending on your exact situation.)
3. Click the "generate" button and save the script that it creates.
4. Run the script in the NEW database.

If you run the script in your OLD database, it may destroy your objects, and that would be very bad. Make sure you run the script in your NEW database. (While we're on this subject, it's a good time to mention that you should back up your database before you start this process, and you should make changes to a test system before migrating it to production.)

That should move your stored procedures and user defined functions over.

You can use a similar process to move tables, views, users, and other objects over as well.

Jan 17, 2008 | Computers & Internet

Not finding what you are looking for?
Microsoft Visual Basic 6.0 for PC Logo

Related Topics:

266 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2644 Answers

Piyal Perera
Piyal Perera

Level 3 Expert

528 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18386 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...