Search results for query: *

You can use the SQL Namespace objects (SQL-NS) to launch the dialog that you see in Enterprise Manager from a VB app. Check out the VB SQL Namespace Browser sample on the SQL Server CD-ROM (I can't remember where it is exactly since it is some time since I used this stuff)

Hi, I am trying to get started with programming the SQL Server Meta Data Services Repository Object, using Visual Basic. Specifically, I am interested in retrieving existing meta data information from SQL Server to my application. Does anybody have example code or links to useful sites...

Hi, How can I determine the default data directory property for an Instance of SQL Server. I need to determine from within an application so I would use SQL-DMO or T-SQL. -Paul

Thanks for the reply Torg. I suspected it would not be salvagable. I do have source control so I've 'only' lost a days work.

Hi, I'm using Windows 2000 and developing in VFP 6. I was working on a form when my machine lost power. On re-boot I'm unable to open the form from my VFP Project and get a 'not a table' error when I try to rebuild the project. Any possible fix for this? Thanks in advance. Paul

That should of course be ConnString = "DRIVER=SQL Server;SERVER=[Server Name];UID=;PWD=;DATABASE=[Database Name]" Handle = SQLSTRINGCONNECT(ConnString) SQLEXEC(Handle, 'sp_tables', 'cResults')

Try this.. Executes the 'sp_tables' stored procedure and retuns data to the cursor 'cResults' ConnString = "DRIVER=SQL Server;SERVER=[Server Name];UID=;PWD=;DATABASE=[Database Name]" Handle = SQLSTRINGCONNECT(ConnectionString) SQLEXEC(Handle, 'sp_tables', 'cResults')

Hi, I am using the DTS object model to create SQL Server DTS packages dynamically from VFP 6 I can create the packages and add connections no problem. However I am encountering a problem when I try to add a Task and Step to the package. The Task is not appearing when I try to view the package...

Hello there, The ghosted property is only apparent when you use images on the listitems. As far as I know you can still set the ghosted property without images and check this property when the item is selected but this doesn't help the user determine which items are unavailable. I am not...

Thanks Weedz, I'll look into it. I'm also trying to launch the 'Data Link Properties' dialog from VFP and get the resulting connection string. It's pretty straight forward in VB. However in VFP I would need to register the OLDDB dll's. Anyone out there done this? -Paul

Put something like this in the cmd button click event WITH [listview object] FOR i = 1 to .LISTITEMS.COUNT IF .LISTITEMS(i).CHECKED ** Code to process if item checked WAIT WINDOW .LISTITEMS(i).TEXT + ' is checked' ENDIF ENDFOR ENDWITH

What is the best way to obtain a list of registered OLE DB providers in VFP6? -Paul

I am indeed reconstucting the grid at run- time. I had resorted to the 'brute force' approach of scanning the grid columns, re-populating the column widths array before a change was likely and then re-contructing after the change. It works but is not as elegant as your solution. I definitely...

Unable to get this event to trigger on any of my grid columns. Need to store column widths after column resize. Many thanks