|
|
|
June 2003 July 2003 August 2003 September 2003 October 2003 November 2003 December 2003 January 2004 February 2004 March 2004 April 2004 May 2004 June 2004 July 2004 August 2004 September 2004 October 2004 November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 November 2007 |
Filter by week: 1 2 3 4 5 How can I create a passthrough query from a VBA code? Posted by asteroid at 6/28/2006 5:37:09 AM Hi!
I am trying to migrate the Back end of an MS Access based aplication to
an SQL server 2000. I KNOW how to use passthrough queries in MS Access.
So, my question is: How can I CREATE a passthrough query from a VBA
code?
I want to know WHERE to point that this will be a passthrough query? I
...more >>
LINK SERVER BAD PERFORMANTCE Posted by Chedva at 6/28/2006 12:00:00 AM A SP with join's between tables of 2 SQL 2000 linked server used to work
relatively quick.
Since a few weeks the same SP that runs on +/- the same amount of data takes
much more time (43 sec).
When i copied the DB so that the SP should run on the same server it takes
only 13 seconds.
Probab...more >>
Table names in Enterprise Manager and Access when linking tables Posted by Richard at 6/26/2006 9:03:18 PM Hi.
I have a SQL 2000 server that I have created a number of tables. When I
connect to the database using ODBC with ACCESS the table names appear to
have my user details added to the front.
ie. I create a table in Enterprise manager called "names"
When I try to link to the tables with a...more >>
MS SQL Server Express connection error from VB.net Program Posted by Sujata P at 6/26/2006 5:56:02 PM I am trying to make new connection with SQL Server 2005 Express Database from
my Visual Basic.Net program. I am using connection string as "Dim
connectionString As String = "Data Source=.\SQLEXPRESS;Initial
Catalog=MgmtSystem;User Instance=True".
But it is giving me error as " Failed to gener...more >>
Linked Server Oracle 10g problem Posted by Hob_Naggers at 6/26/2006 5:14:01 PM I have followed the examples from MS. to create the link between my MSSQL2005
and Oracle 10g
I have all of the Oracle client installed on the server.
I have a net service defined.
Here is what I ran to create link:
EXEC sp_addlinkedserver 'OraLinkServer2', 'Oracle', 'MSDAORA', 'HPRD89...more >>
Problem to delete a user Posted by Pedro at 6/26/2006 8:51:02 AM Hi,
I have a problem to delete a user and it gives me this message in SQL2K5:
The database principal owns a schema in the database, and cannot be dropped.
(.Net SqlClient Data Provider)
Can any body help me. I will be grateful
This databade came from a SQL2K and I can connect from any ...more >>
sql server2005 issue for the connection Posted by Nilkanth Desai at 6/26/2006 2:54:02 AM "The request failed or the service did not the respond in a timely fashion"
I am using xp servicepack 2.0 and sql server 2005 developer edition...more >>
Cannot login using 'sa' user name and password Posted by Mike9900 at 6/25/2006 12:08:01 PM Hello,
When I try to connect it give the following message I copied from the log:
Source Logon
Message
Login failed for user 'sa'. The user is not associated with a trusted SQL
Server connection. [CLIENT: <local machine>]
I am using Win 2003 Ent. and is domain controller. I use ad...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Multiple Threads and Licensing Posted by Patrick Brand at 6/22/2006 2:33:02 PM Hello,
I am working on a project that will require the use of SQL Server 2005
Workgroup Edition. We were planning to use the version that comes with
5 CALs instead of the version that is licensed based on processors due
to the enormous cost difference.
The application I am working on is...more >>
Images in SQL Posted by I notice that SQL 2000 has a datatype of image.
My question is after I setup the table and fields how do I populate the
table with image data?
...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |