Archived Months
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
August 2008


all groups > sql server connect > april 2006 > threads for april 1 - 7, 2006

Filter by week: 1 2 3 4 5

Enable Quoted Identifiers=0 System.Data.SqlClient.sqlConnection
Posted by CathieC at 4/7/2006 3:44:02 AM
Hi there, this is probably a common question, how can i include the "enabled Quoted Identifiers" settings in the connection string of the sqlconnection. on trawling through web pages i have identified 1 .that by default the quoted identifiers in SQL Server 2000 is by default set to ...more >>

Access connectivity to SQL Tables (Urgent)
Posted by pcsmitpra at 4/7/2006 2:26:03 AM
Please let me know whether Microsoft Access(2000), running on our office computers, will be able to link (over the Internet) to the tables in our SQL Server (2000) database on your server....more >>

sql server does not exist - urgent
Posted by Jaiganesh at 4/7/2006 12:18:14 AM
I have a sql server in the local network.I am able to connect to this server through my .net windows application using both dsnless and dsn connection.But using the same code in my web application it is not connecting to this server.In this case while using dsn-less connection, error message is ...more >>

ASP2.0 SQL Server 2000 "ASP SQL GURU" NEEDED!
Posted by GH at 4/7/2006 12:00:00 AM
Hi New to ASP2.0 programming, I need some help on the Connection String that I want to place in the web.config file. I am running Visual Studio 2005 Web Developer and the web hosting company has is using SQL Server 2000. I need to build a connection string... <connectionStrings> ...more >>

How to connection MS Access Porject (.adp) with SQL server?
Posted by Pat at 4/6/2006 7:49:02 AM
Hi all, I got the question, how can i connection MS Access Project to a SQL Server in vba in runtime. The situation is i create a new MS Access Project, it's didn't have any connection with any SQL-server. It's just consist a couple of form. What i want is that user can via an inlog form...more >>

fn_dbLog or DBCC
Posted by Luis Felipe BolĂ­var Restrepo at 4/5/2006 2:01:21 PM
Good Afternoon, Really I have two problems, and Only i need one of them. Both is because I try to read the Log. The first Question is about the function fn_dbLog, how can I do to see the information of register inserted or updated or deleted. The second question is that with the DBCC Log...more >>

SQL 2005 fails to enumerate tables for ProvideX Mass 200.
Posted by royvij NO[at]SPAM hotmail.com at 4/5/2006 10:08:13 AM
I have multiple ODBC connections configured and they parse the tables correctly however inside any SQL 2005 application the tables are not listed. I can run queries against any table in ProvideX however. The tables are listed in SQL 7.0 and 2000. ...more >>

Connection string
Posted by McHenry at 4/4/2006 12:00:00 AM
I am connecting to a SQL Express database from Excel 2K. I have three connection strings examples. The first two work however the third was the one I wanted to use as I do not want to specify a local db. These two work fine: strConn = "PROVIDER=SQLOLEDB; DATA SOURCE=(local);INITIAL CATALOG=...more >>



Creating a View linked to a VFP table
Posted by Preacher Man at 4/3/2006 4:23:39 PM
I have a SQL database and I need to link to a VFP table. I have been told that a view is what I am needing. Can someone lead me in the right direction of creating and using a view to a VFP table? ...more >>

Enterprise Manager tail snap-in initialization
Posted by Pierpaolo at 4/3/2006 3:56:48 AM
Hi Guys, I tried to install client tools of Sql Server 2005 DevEd. Wow! Big product... but my boss imposed me to deinstall this tools. Now when I launch Enterprise Manager I get this message: Snap-in failed to initialize. Name:<unknown> CLSID:{00100100-1816-11D0-8EF5-00AA0062C58F} I alr...more >>

Linked server
Posted by Tullamore at 4/3/2006 12:00:00 AM
Our SQL Server has a linked server that we are trying to query. Our SQL-Server is on a DMZ-net, behind an ISA-Server, the linked server is not behind any firewall. I have no problem to make a connection as a linked server from my local workstation (not on the DMZ-net). Does anybody know w...more >>

Connecting to SQL Server 2005
Posted by McHenry at 4/1/2006 10:45:45 PM
Hi, I am having ongoing problems connecting to the server. I thought I had it solved thanks to help from a prev post: C:\>sqlcmd -S dimension9150\SQLExpress HResult 0xFFFFFFFF, Level 16, State 1 SQL Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF]. Sqlcmd: Error:...more >>


DevelopmentNow Blog