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 >>
Don't see what you're looking for? Search DevelopmentNow.com.
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 >>
|