Hello, all!
If anyone needs this for future reference, here is the solution I created:
Set reference to "Active DS Type Library"
Private sub BackupToShare
Dim psCompId As String
Dim psBackupPath As String
Dim psDirPath As String
Dim psInfo As New ADSystemInfo
Dim pb As...
Hello, all!
I'm successfully using SQL DMO to create backups of my SQL database on my local machine. I can connect to our local network and manipulate server databases. Is there a way to create a .bak on my local disk of the server database?
my abbreviated code:
Dim poBackup As...
CCLINT -
Good question. I almost automatically said yes since I cut and pasted. But I double checked to be sure that I had:
CBool(catTbl.Tables(i).Columns(k).Attributes And adFldIsNullable)
(Which was just cut and pasted from code).
I had similar results with adFldMayBeNull.
Perhaps to...
Thanks paulbent!
Sorry, should have explained. I am using VB6 and ADO to document a SQL database. This is a very good lead, although I received 'False' back on every column (which is untrue). I'll start pursuing 'adFldIsNullable'.
Thanks!
Greetings!
I'm new to a company and will be doing some dataconversions. To get familiar with the data structure (and to dump it into rs) I've come up with:
'Loop through tables in Source to populate Result
catTbl.ActiveConnection = cn
j = catTbl.Tables.Count
For i = 1 To j
If...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.