Summary: OK im trying to connect my local machine to my local sql database in VB6 but the connection strings i`ve tried dont work, i have set ado 2.7 as a refe...
Summary: Hi, i`m having a problem using an html file to display my reports for my vb database program, does anyone know how i can make it so my .htm file can g...
Summary: Dear Friends, I have been using MS Access as the backend and presently I have planned to use SQL Server as the back end. The connecting string to MS A...
Summary: Hi there, please can someone help me out, i`m really having a tough time tring to connect to my remote mysql DB, this is the connection string i`m usi...
Summary: Dear Friends, Pls Help. I want to write an sql statement which makes use of 2 tables in 2 different databases. How do I write the connection string. ...
Summary: Hi there i`m in need of some help with a connection string to an access db on an ftp site that has a usr name and pass word...is this possible??? or d...
Summary: i`m stuck please can someone help!!! this is my connection string at the moment, Set Conn3 = New ADODB.Connection Conn3.CursorLocation = adUseClient ...
Summary: Hi I'm trying to connect to SQLExpress database. I'm using c# express and it's sqlexpress that came with it. I want to use OleDbConnection but I can'...
Summary: Hi, I want to create a table at runtime with create table sql command in vb6. Can someone help me as to how to pass text entered at runtime in a textb...
Summary: This is how I make a connection string to a SQL database: ConnectionString = "Provider=SQLOLEDB;Driver={SQL Server};Server=" & ServerName & ";Database...
Summary: I am attempting to access a local sql server 2000 db, but to no avail. Here is the connection string I am trying, but receive the typical [Microsoft]...
Summary: Hello, I'm no expert when it comes to SQL, so go easy on me. I'm a novice. Here's the situation: My VB6 code is constructing an SQL query string whi...
Summary: Hi Guys, I am new to windows programing, and my computer is running Windows XP Home Edition. Would somebody tell me how to connect from VB6.0 to SQL S...
Summary: If you want to add a field to the database table? You need to use an ADODB.Connection object and the SQL command ALTER TABLE Like this: Dim ConnString...
Summary: How are you trying to connect? ADODB, ODBC??? I'm guessing you might be stuck with the connection string: http://www.connectionstrings.com/ ...
Summary: Here is the first part you need to do, what I did was place this in a module Option Explicit Private Conn As New ADODB.Connection Private Cmd As New ...
Summary: You clarified your question, but then you reversed it...First you asked if VB6 comes with SQL, and now you ask if SQL comes with VB6. Either way, the ...
Summary: there are alot of example available on net and also alot is available on msdn. here are steps i am considering sqlserver as database server. 1- past a...
Summary: Hi Everyone! I am trying to run a stored procedure from SQL 2005 with Excel 2003 and VB 6.3. I am getting the error: Run-time error 1004 Application-...
Summary: It's up to the database to accept or reject the SQL, not VB6. Display the query, and make sure the string VB6 is sending doesn't have a mistake. ...
Summary: When you say validate, do you mean: check if the SQL statement it syntacticly correct; or whether the SQL will actually return a record(s)? If the fir...
Summary: There are so many possibilities. First, if you added a reference to your application (Microsoft ActiveX Data Objects) then you have bound that version...
Summary: I am linking a Database up to a windows App in visual studio and I can only get one table in the database to respond to the application. I am using t...
Summary: you will need to do one of the following: 1) Use a database 2) pass hidden values To use a database is very easy. First you make a db and add all you...