VB Forum / Database Access / July 2004

Is it possible to access a remote database using visual basic and a MS
Access database? I've tried to add the server to VB's server explorer, but
it says that it can't connect to a server not on the same domain. Thanks!

I'm  using VB to connect to Oracle, but I'm getting an error:
ORA-12514.
I tried the usual stuff, tnsping and tried to connect using SQL PLus,
they all worked, I've got the same program in other machine working

I need to execute a generic query SQL on SQL Server via ADO e VB6.
That query inside of it must have a named parameters. How can i do on VB6 to
have a collection of all parameter presents on a generic query, and for it
ask with InputBox, have a value and assign to it.

I am querying a SQL 7 table from VB and I need to return the contents of two different fields as a NEW field depending on the value of another field, like so:
SELECT TOP 1000 KADA.*, IIf(COIND = 'I',FORENAMES & ' ' & SURNAME,COMPANY) AS NAME FROM KADA
Left Outer Join KADA_ADD ON ...

I know this is stupid, but...
Using VB 6 packaged with Office 2000, I can't seem to declare a variable as
a database. After letting my VB skills rust for two years, I'm looking at
old stuff I used to do, but it doesn't seem to work the same way. So for my

G'day to all,
Here is the line that gave me an error:
FileSys.CopyFile X1template,NewX1sFileName
Does anyone have any ideas insolving this error.

G'Day to all,
I'm getting an error return on my script.
The following message was given to me:
ODBC driver does not support the requested properties.

Hot to insert image in database (mySQL) and retrieve it from database?
How to assign the datatype?  Thanks

How can I confirm that the ADO components are installed and working
correctly on winxp?
Thank you!

I'm trying to create a recordset in VB6 from a comma delimited txt/csv file. The code I'm using is:
Dim adoConn As ADODB.Connection
Dim adoRS As ADODB.Recordset
Set adoConn = New ADODB.Connection

Please,
attempting to set "Required Property" in a field a table of Access2k using ADO (ADOX) is impossible. That's right?
Or that is eqv. (art. "BUG: Attributes Property of ADOX Columns Collection..) to "Required Property":
 cat.ActiveConnection = conn

I've written an application that compacts databases on our network. I'm using the 'Jet Replication' library to action the database compacts.
One problem is that some of the databases are large (500MB+) & when it calls into Jet Engines 'CompactDatabase' method, the application ...

Is it possible to repair and compact an Access data base from VB.NET code???
If it's possible, how do you do it?

I have a VB 6.0 app with Access 2000 database.  I now have multiple users on my application and so my database requires more frequent maintenance (doing a compact at least once a day).  I would like to set up a routine to automatically do a Compact on the database each night.  ...

We are 2 PCs installing VB6. But I found that not all the references are in both installations (such as : "ODBC Driver & Data Source Name Functions", etc). Can someone tell me how to install them?