VB Forum / Database Access / September 2007

I have an app that makes a connection to an SQL database using ADODB.
I am setting the "Data Source" to be the name of the server where the
database is. This all works properly - no problems.
But, if I instead set the Data Source to be the server's IP address,

PLEASE INFORM  HOW TO IMPORT - EXPORT A TEXT DELIMITED INTO DATAGRID VB.NET
THANKS
GUS

Thanks in Advance !
Accutally I have a VB 6.0 Program. I want to return recordset from ASP
file. Is there Any way to return ASP file data in VB 6.0
ASP Code:

When I used DAO, you could ask to open the database with "ODBC;" as
the string, and a system dialog appeared to enable you to select an
ODBC data source.  Now that I am using ADO, this capability is
missing.

Hi all,
I have to build a vb6 application that compares two sqlite3 database. I am
using a .dll to access the database and the query results are placed in a
variant variable. I would like to take this variant and put the result of my

Just a sort of 'don't want to step on anybody's toes' query.
Do I have to sign anything or provide any form of document with my app, if
I'm using an Access DB as a data store for my VB/ADO app?
Am I OK to change the extension of the db to something else?  I want to

Erreur d'exécution '-2147467259 (80004005)'
     La méthode 'Open' de l'objet '_Recordset' a échoué
J'obtiens ce message d'erreur sur l'instruction suivante :
Rs.Open sqlStr, Cnn, adOpenForwardOnly, , adCmdText

I need to produce a CSV file to upload to a website (Government
requirement).
The file has to have a certain structure, which consists of a header and a
body. (header is company identifier, body is actual data)

Does anyone know how to programmatically pass parameters to a
Microsoft Access report?  I have an Access report that prompts for a
month, year and manager's full name for it to run.  I attempted the
code below but the report still prompts for the requested parameters

Wondered if you could help.  I'm using SQL queries in Access 2003 and I
can't fathom the below.
My table data is defined as follows:
TERMID          SHORTNAME       YEAR

Why would VS 2005 display the message:
"An error occurred while establishing a connection to SQL Server 2005. This
failure may be caused by the fact that under default setting SQL Server does
not allow remote connections. Provider Named Pipes. Provider error 40, could

I am using the Microsoft Text Driver (DSN-less mode) to read CSV files
in my application. these files are comma delimited, but not quoted by
double-quotes. they come from many customers, so I cannot easily
control their format.

      I have installed Visual Studio 2005 and am working on Visual
Basic. I have created a ADODB connection to a DB2 database in a server
whose IP address, Portnumber, hostname...  are known to me. I have
created a recordset also and assigned a query to it.

My webapp is coded to use Oracle as a datasource.  One of our
customers wishes to use SQL Server as a database.  Is it possible to
connect to either datasource using the same code base if it were to be
coded correctly (i.e. with case statements and such).  I'd really like

My .NET SqlClient dataset throws the following runtime error when trying to
update rows in a SQL Server table:
   Dynamic SQL generation for the UpdateCommand is not supported against
   a SelectCommand that does not return any key column information.