| Groups | Blog | Home |
|
March 2003 May 2003 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 BCP -R option Posted by ravi sankar at 11/21/2003 4:04:58 AM Hi all,
I m trying to use BCP utility to upload a huge text file.
As per microsoft documentation, -R is used to specify the
regional settings. My computer (client) and the sql server
(running in a network machine) has dd/mm/yyyy as the
regional settings. The incomming text file also has d...more >>
SQL Server to Oracle Posted by Sandeep at 11/20/2003 5:55:35 PM Dear Experts,
I would like to insert a result set from the SQL server
2000 Stored procedure to Oracle 9i database.
I am thinking to create txt file out of result set, but I
am not sure How can I create a txt file directly from
stored procedure?
Anybody has a better Idea?
TIA
..
...more >>
How to get the REAL host name? Posted by Vadim Rapp at 11/20/2003 3:59:54 PM Hello:
I need to be able to determine the name of the client machine running the
session. The value in sysprocesses.hostname is client-supplied, so it may be
not the real name of the client machine. The client can explicitly specify
any host name in the ADO connection string. Is there a way to...more >>
Use openrowset with Oracle Posted by Alessandro Pin at 11/20/2003 2:47:47 PM How can I execute a select with OPENROWSET and extract only the record that
I request with the WHERE clause?
For example:
SELECT a.*
FROM OPENROWSET('MSDAORA','DBORACLE'; 'USER'; 'PWD', 'select * from
TABELLA' ) AS a
WHERE
a.Cognome like @Cognome
With this SQL statement, SQLServer ...more >>
XP Pro and SQL Server 7.0 not playing well together... Posted by David L. Rice at 11/20/2003 1:07:36 PM I have been trying various scenarios all afternoon trying to get XP Pro and
SQL Server 7.0 to play well together. SQL Server (client version, of course)
seemed to install well and no problems there. However, when I go to register
my server and connect to it, I get the following error:
[Begin e...more >>
XP Pro and SQL Server 7.0 not playing well together... Posted by David L. Rice at 11/20/2003 1:07:36 PM I have been trying various scenarios all afternoon trying to get XP Pro and
SQL Server 7.0 to play well together. SQL Server (client version, of course)
seemed to install well and no problems there. However, when I go to register
my server and connect to it, I get the following error:
[Begin e...more >>
Unable to load communication module Posted by Lester Botello at 11/19/2003 9:42:57 AM Hello
I have a VB6 app which connects to SQL Server. The application is installed
and runs correctly in all workstations, but one. The error message I receive
when I try to connect is:
"Unable to load communication module. Driver has not been correctly
installed."
The PC in question is a...more >>
replicate error Posted by §§§Enzo§§§ at 11/18/2003 4:57:29 PM Hi all,
is there anyone in area that have experience about snapshot replicate from
server ---> client?
My trouble is that in the client (subscripter) i don't succeed to start the
sqlserver-agent. log return
this error:
[LOG] Exception 5 caught at line 191 of file ..\src\refreshr.c.
SQ...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Insert Trigger Posted by Rich at 11/18/2003 9:48:16 AM Hi,
I am new to triggers and would like your help
I am trying to write an insert trigger on a table, so that when a record is
inserted in table1 a dummy record is inserted in table2
eg: table "master" has a record with fields "1', "Honda", "1998"
When this record is inserted into the "mas...more >>
Windows 95 and SQL 2K Posted by Craig at 11/18/2003 5:09:55 AM I asked the question on the connectivity side. CAn I
connect to a SQL 2K DB from a widows 95 PC. IF yes, what
is required? It was reported that the correct version of
MDAC might allow connectivity. Please advise. ...more >>
SQL Server 7/2000 APP_NAME() Connection Identification Problem Posted by Robert E. at 11/17/2003 5:08:55 PM *apologies for multipost
Hey
we have an SQL7 box (soon to be upgraded to SQL2k)
we have in-house client software that connects to a db hosted on the box via
ADO + SQLOLEDB. Our client software always specifies an "Application Name="
parameter in the OLEDB connection string. The applicatio...more >>
SQL client service pack? Posted by Carlos at 11/17/2003 2:48:36 PM Is there a service pack for the SQL client for SQL2k??...more >>
SQL client service pack? Posted by Carlos at 11/17/2003 2:40:51 PM Is there a service pack for the client of SQL2k? Thanks
...more >>
Replication Problem Posted by Noorali Issani at 11/17/2003 1:35:39 PM Dear Professional
I have created the replication b/w two servers and when I do alter the table
then it gave me an error that to can't drop the table b/c it 's being used
for replication, I am altering the table on Publication Server.
Regards
Waiting for your reply !
...more >>
Timout problem Posted by skc at 11/17/2003 12:49:36 AM We are running SQL 2000 Server Eval on a Windows 2000 Pro
box. When we run an SQL query against a table, we get
(after around 40 seconds or a minute) a Timeout error.
How do we change or ommit the Timeout?
Thanks,
skc
...more >>
Licensing Posted by Chris at 11/17/2003 12:29:03 AM How many Licenses does one need to connect 12 PC's to an
SQL database. Does one need the same amount of Server
CAL as SQL CALS?
Can there be 1 Server Cal and 15 SQL cals?...more >>
Re Posted by Amit at 11/15/2003 11:33:48 AM Hi
my application is a client-server database appication which is developped in
vb to work on the local area network. backend which is used is sql server
when i am assigned connection string to make connection through ado, server
was not found and time of the connection is expired.
...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |