Skeen
Nov 16th, 2000, 09:08 AM
Hiya everybody,
I'm using VB to populate tables in a database. I'm downloading a text file from Th'internet (as yer doo), and then using SQL*loader - oracle product to populate the tables with the text file. I'm running it using the Command() function for shell commands, then I try to connect in using a connection object and it won't 'ave it! It said I'm already connected, but without the connection string I can't get anything out of any other tables. Its first time I've used the oracle sql*loader.exe and so I'm not very familiar with it (only heard of it since yest'day). Does anyone know whats compatible with it? I do want to use it beacause its increddibly quick at populating a table, and I'd reccomend it to anybody!
Cheers 'n' Beers
Skeen
I'm using VB to populate tables in a database. I'm downloading a text file from Th'internet (as yer doo), and then using SQL*loader - oracle product to populate the tables with the text file. I'm running it using the Command() function for shell commands, then I try to connect in using a connection object and it won't 'ave it! It said I'm already connected, but without the connection string I can't get anything out of any other tables. Its first time I've used the oracle sql*loader.exe and so I'm not very familiar with it (only heard of it since yest'day). Does anyone know whats compatible with it? I do want to use it beacause its increddibly quick at populating a table, and I'd reccomend it to anybody!
Cheers 'n' Beers
Skeen