Search results for query: *

Thanks Paul... That works. And it opened my slow mind.

Howdy- I'm reading SQL Server tables with VB6 and writing the results to Excel Spreadsheets. The syntax in VB6 differs slightly from VBA when manipulating Excel objects. In general; has anyone seen a comprehensive reference on this subject (I can't find anything on Microsoft's sight). In...

Will the "Format" function work for this?

The DB resides on one of our servers. I am using SQL*Server authentication and the ADODB.Connection ".open username" is the dbo. I think a certain component is missing from the workstation experiencing the error, but I know not what it is. Thank for your response.

Hello- I've written an app that works fine on one users machine but fails with an access violation on another (both Windows 2000). The symptoms are: changes are made to a bound text box control (binding to SQL*Server), when the control loses focus the error occurs and the app crashes. I suspect...

The following view belongs to sa and lives in a Db called DC. SELECT * FROM DC..COMP_TIME_LOST_V works fine for sa but not for userx. userx has select access to the underlying tables and the view. userx also has access to the PROD and DC Dbs. In query Analyzer userx executes the above select and...

Hello- I've created a view as 'sa' but other users cannot access it. Symptoms are 1) Crystal Locks Up. 2) Querying the view thru Query Analyzer runs forever. 3) Clicking on Table Columns in Query Analyzer takes a while and then shows nothing and the + symbol disappears as if the table had no...

Hello Scott- You might check the ODBC settings on that machine. (If you're using ODBC to connect, that is). Just a thought.

I've added a column to a SQLServer Table Column. But it doesn't show up in the fieldlist under tools|tables|columns. Crystal Reports has a feature called "Verify Database" which recognizes the new table column and adds it to the list. Does RS have a similiar feature. Thanks.