Can someone give me a code for the connection of Vb6 To Microsoft Sql2000?
545083
goto www.connectionstring.com or www.connectionstrings.com
82386
It depends on what software interface the driver for the data aquisition card provides. If it is COM based which it probably is, you should be able to interface with VB6. But If you are writing a driver for the PCI card yourself, you cannot do that in VB. You will need to develop that driver in C and compile against the DDK (driver development kit). Also, know that VB6 is no longer supported by Microsoft. You should look into newer technologies such as .NET.
174573
If you have a locally running db such as Oracle start it up before opening a new project in VB.\n\nOnce the bd service is running VB has a wizrd to help you locate the db server.  \n\nYou'll need to specify to Oracle and also VB that you want to use ODBC connectivity.\n\nYou'll also need to define how your db information is organized.\n\nFor your needs MS Access might be much easier.\n\nIn any case PHP with MySQL is deifinitely easier.\n\nHope this helps, please vote for me!\n\nJIm
740092
in VB 2005, there is ready to use and very simple terms to use database connectivity with your application. once u have build database , in VB 2005 go to the data menu and click on add new data sourse and rest of the things you will understand for sure.
346060
just try going to this link\n\nhttp://www.w3schools.com/sql/sql_intro.asp\n\nmight help
377667
heres some code from a old ASP.NET application I found (the database connection string should be 1 line)\n\nDim Public DBS as String = "PROVIDER=Microsoft.Jet.OLEDB.\n4.0; DATA Source=c:&#92;DataBase.mdb"\n\n\n\nDim myconnection as oleDbConnection = new oleDbconnection(DBS)\nmyConnection.open()\nDim myCommand as oleDbCommand = New OleDbCommand("Select * from Threads", myConnection)\nDim myDataReader as oleDbDataReader = myCommand.ExecuteReader()
1091921
In visual basic 6.0 IDE you have to add a reference to ADODB(ActiveX Database Ojects) library.You have to declare a public variable to reference a connection in the general declaration section.\nGo to www.planetsourcecode.com and you will find a lot of programming code for that.
1182000
http://msdn.microsoft.com/vbasic/learning/default.aspx
514769
You need to download MS SQL Server 2000 or 2005 JDBC driver first. This driver doesn't need ODBC at all.\n\nexcerpt from documentation:\n\nOnce the driver is installed, you can connect from your application to your database in two ways: with a connection URL through the JDBC driver manager, or with a JNDI data source. This quick start explains how to establish your database connection using a connection URL. See "Using the SQL Server 2000 Driver for JDBC" for details on using data sources. \n\nYou can connect through the JDBC driver manager with the method DriverManager.getConnection. This method uses a string containing a URL. Use the following steps to load the driver from your JDBC application. \n\n1. Setting the Classpath \nThe SQL Server 2000 Driver for JDBC needs to be defined in your CLASSPATH variable. The CLASSPATH is the search string that your Java Virtual Machine (JVM) uses to locate the JDBC drivers on your computer. If the drivers are not on your CLASSPATH, you receive the error "class not found" when trying to load the driver. Set your system CLASSPATH to include the following entries, where install_dir is the path to your SQL Server 2000 Driver for JDBC installation directory: \n\ninstall_dir/lib/msbase.jar  \ninstall_dir/lib/msutil.jar  \ninstall_dir/lib/mssqlserver.jar \n\nWindows Example \nCLASSPATH=.;c:&#92;Microsoft SQL Server 2000 Driver for JDBC&#92;lib&#92;msbase.jar;c:&#92;Microsoft SQL Server 2000 Driver for JDBC&#92;lib&#92;msutil.jar;c:&#92;Microsoft SQL Server 2000 Driver for JDBC \n&#92;lib&#92;mssqlserver.jar \n\nUNIX Example \nCLASSPATH=.;/home/user1/mssqlserver2000jdbc/lib/msbase.jar;/home/user1/mssqlserver2000jdbc/lib/msutil.jar;/home/user1/mssqlserver2000jdbc/lib/mssqlserver.jar \n\n2. Registering the Driver \nRegistering the driver tells the JDBC driver manager which driver to load. When loading a driver using class.forName(), you must specify the name of the driver: \n\ncom.microsoft.jdbc.sqlserver.SQLServerDriver \n\nFor example: \n\nClass.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");  \n\n3. Passing the Connection URL \nAfter registering the driver, you must pass your database connection information in the form of a connection URL. The following is a template URL for the SQL Server 2000 Driver for JDBC. Substitute the values specific to your database. (For instructions on connecting to named instances, see "Connecting to Named Instances" in the SQL Server 2000 Driver for JDBC topic.) \n\njdbc:microsoft:sqlserver://server_name:1433  \n\nFor example, to specify a connection URL that includes the user ID "username" and the password "secret": \n\nConnection conn = DriverManager.getConnection \n  ("jdbc:microsoft:sqlserver://server1:1433","username","secret");  \n\nNOTES: \n\nThe server_name is an IP address or a host name, assuming that your network resolves host names to IP addresses. You can test this by using the ping command to access the host name and verifying that you receive a reply with the correct IP address. \n\nThe numeric value after the server name is the port number on which the database is listening. The values listed here are sample defaults. You should determine the port number that your database is using and substitute that value. \n\nYou can find the complete list of Connection URL parameters in "Connection String Properties" for the SQL Server 2000 Driver for JDBC.
441639
Use crystal reports or data report (for vb6). If you are using vb.net the you can use only crystal report
1333
Sorry in advance if Yahoo eats my indentation, but I think you are looking for something like this (tested under Access 2000):\n\n\nPublic Sub FiddlingWithQueryObjectsViaVBA()\n\n    Dim dbs As DAO.Database\n    Set dbs = CurrentDb\n    Dim qrydef As QueryDef\n    \n    Dim sSQLstring As String\n    Dim sQueryNames As String\n    \n    For Each qrydef In dbs.QueryDefs    ' iterate through all the Access query objects\n    \n        sSQLstring = UCase$(qrydef.SQL) ' Get the SQL for the current query\n        \n        If InStr(sSQLstring, "SOMETHING_I_AM_LOOKING_FOR") > 0 Then   ' I found what I'm looking for?\n        \n            sSQLstring = Replace$(sSQLstring, "SOMETHING_I_AM_LOOKING_FOR", "REPLACEMENT_TEXT") ' replace the text\n            qrydef.SQL = sSQLstring     ' update the query object with the new SQL\n        \n            sQueryNames = sQueryNames & qrydef.Name & vbCrLf    ' Maybe make a list of queries modified?\n        End If\n    \n    Next\n    \n    MsgBox "Modified the following queries:" & vbCrLf & sQueryNames\n    \nEnd Sub
426878
write a vb6 procedure open a new recordset using your ado connection and write the sql statemtn to select the data from the 2 tables that you want. then save this into a module and then call it from your data report.
66876
Here's a pretty good one I wrote:\n\nhttp://www.planetsourcecode.com/vb/scripts/ShowCode.asp?txtCodeId=58476&lngWId=1\n\nYou'll need Visual Basic to compile it or you can e-mail me and I'll send it to you...
241790
C# is commonly used with SQL Server. Using this you simply need to add a reference at the top of your code:\nusing System.Data.SqlClient;\n\nThen use a SqlConnection, SqlCommand, and maybe a SqlDataReader. Set the connection up to reference your DB then create an SQL statement and execute the command. Then the DataReader will allow you to see each part.\nGood Luck!
612448
Hi there,\n\nJust go to:\nhttp://www.planet-source-code.com/vb\n\nYou will find lot of VB resource there (VB,VBA,VB Net.,etc)\n\nCheers.
354180
go to Toolbox.Here u can see several options.\nData\nComponents\nWidows Forms\nCliboard Ring\nGeneral\n\nclick on Data.double click on Oledb Connection.Then it will see at the \nbottom of the page.select properties by rightclicking on the control.\nClick the dropdown arrow of the connectionstring property and click \n<New Connection...>.Then Data Link Properties page displayes.\nclick on the provider tab.Select Microsoft jet 4.0 OLEDB Provider.\nClick Next.Select ur database by clicking on the ellipse.Click on\nthe 'TEst connection' button to check ur connections.\nIf it displays the succeful message click ok.Then u will the connectionstring\njust copy the connectiostring\n\nform1.vb\n_________\nImports System.Data.OleDb\nwrite this code at the top of the form.just before the public Class Form1\n\nthen declare the connection object\nDim mycon As New OleDb.OleDbConnection\nmycon.Open()\nmycon.ConnectionString = "paste the connectionstring"\n\nInstead of writing this connectionstring u can use the Oledb control
966661
check out http://www.pscode.com for examples.  You would need to use ADO.NET in addition to VB.NET in order to obtain the required data.