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:

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...

14 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...

1 Answer

How do copy a table from an access database in one folder to another access database in another folder through visual basic code


Simple method Open both tables (or create second) and copy each record from source to target through 'do while not eof' or 'for each' syntax.

Second solution create link in target DB for first table, and use SELECT INTO statment in SQL.

Mar 02, 2009 | Microsoft Visual Basic 6.0 for PC

1 Answer

How to configure the sql server 2005


Enable remote connections for SQL Server 2005 Express or SQL Server 2005 Developer Edition loadTOCNode(2, 'moreinformation'); You must enable remote connections for each instance of SQL Server 2005 that you want to connect to from a remote computer. To do this, follow these steps:
  1. Click Start, point to Programs, point to Microsoft SQL Server 2005, point to Configuration Tools, and then click SQL Server Surface Area Configuration.
  2. On the SQL Server 2005 Surface Area Configuration page, click Surface Area Configuration for Services and Connections.
  3. On the Surface Area Configuration for Services and Connections page, expand Database Engine, click Remote Connections, click Local and remote connections, click the appropriate protocol to enable for your environment, and then click Apply.

    Note Click OK when you receive the following message:Changes to Connection Settings will not take effect until you restart the Database Engine service.
  4. On the Surface Area Configuration for Services and Connections page, expand Database Engine, click Service, click Stop, wait until the MSSQLSERVER service stops, and then click Start to restart the MSSQLSERVER service.

Feb 28, 2009 | Microsoft Visual Studio 2005 Professional...

1 Answer

Unable to create database from within VWD 2005 Express


try to complete uninstall .net framework and install it again or get the latest copy of .net framework to install 3.5 latest version already available for download

Dec 01, 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

2642 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18358 Answers

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

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

Answer questions

Manuals & User Guides

Loading...