all groups > sql server connect > march 2004 > threads for march 1 - 7, 2004
Filter by week: 1 2 3 4 5
Arghhhh Alias (local)\FOOBAR -> TCP/IP,ditto
Posted by Alan J. McFarlane at 3/7/2004 2:00:56 PM
I've just spent days trying to get no-network protocol access to a local
(MSDE )database working. Everything I tried failed, all hints from the
documentation failed.
Eventually...I found cliconfg.exe and found out about Aliases and found the
stupid alias I referred to in the subject line, i.e... more >>
Looooong Delays Connecting with Enterprise Mgr
Posted by R.MacLean at 3/6/2004 1:53:08 PM
Ever since upgrading to SQL Server 2000, connecting to the DB servers with
Enterprise Manager results in multi-minute delays while the database list
populates.
Is there something that can be done to make the connection process faster?
... more >>
I cannot create or modify a database in SQL server through Server Explorer in VS.NET 2003. How can I fix it?
Posted by aldo75 at 3/6/2004 11:36:10 AM
I cannot create or modify a database (SQL server 2000 Enterprise), through Server Explorer, in VS.NET 2003. I've installed MS .NET framework SDK 1.1 and VB.NET resource kit. How can I fix it?... more >>
Great difficulty in setting up SQL Server authentication for replication through non-trusted domains.
Posted by Joe Mine at 3/5/2004 5:14:14 PM
I have great difficulty in getting the subscriber SQL server in (HOT domain)
to access the snapshot folder on the distributor/publisher SQL server in
(NARC domain). They are non-trusted domains.
I am aware that you must:
1) create a pass-through account on both Domains as eg. SQLadmin with same... more >>
Cannot connect to SQL Server through VPN
Posted by Paul Ohlemacher at 3/5/2004 5:13:05 PM
I established a VPN tunnel to my network at work to test merge replication.
While I am able to connect via VPN to my network and ping the server in
which the SQL server resides, I am not able to establish a connection to the
Sql Server to register in my Enterprise Manager. The error I get is "Sq... more >>
attaching DAT files
Posted by Darius at 3/5/2004 3:15:41 PM
**** Post for FREE via your newsreader at post.usenet.com ****
Hello,
I have solved my problem with connecting to SQL 6.5. Thank you for
answering.
Still I have two more questions.
I have copied DAT file from one computer with SQL 6.5 and put it to another
computer with SQL 6.5. How can I ... more >>
SQL Server does not exist or access denied during updates
Posted by Jung Steutel at 3/5/2004 2:47:04 PM
Hi,
I've got a problem connecting to a sql server 2000 (I think it's the
standard edition) database running on a windows 2003 server (small business
edition).
I can connect to the database and retrieve data, but updates/inserts give
the "sql server doesn't exist or access denied" error mess... more >>
SQL Statement Problem
Posted by Atley at 3/5/2004 2:26:06 PM
Sorry for the wide posting, but i really need some help and I posted
somethind a few hours ago and have heard nothing, so i thought that I would
try reacing more developers...
I am trying to get a date range from the first of whatever month is previous
to the current one to exactly one year pr... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
PDSSQL.DLL
Posted by Osvaldo Ospino at 3/5/2004 11:57:01 AM
THE LIBRARY PDSSQL.DLL CANNOT FOUND. I NEED THIS DLL.
PLEASE HELP ME
OSVALDO
... more >>
Connect to DB2 using SQL-Server
Posted by osoto at 3/5/2004 8:26:07 AM
Hello ther
I have SQL 7 and ODBC-Client access to connect to DB2 (AS400). I can connect to the DB2 database using the ODBC and VB without problems but now I want to use the sp_addlinkedserver to link the DB2 to my SQL database using the ODBC. Does anybody know what parameters I have to use and what... more >>
MSDE - Move database from one MSDE instance to another MSDE instance
Posted by Phil at 3/5/2004 7:17:15 AM
I'm trying to move a database from one machine with MSDE
installed to another machine with MSDE installed so that I
can use this database on the 2nd machine.
Is there a procedure in MSDE to copy/backup a database and
restore to another machine?
Thanks in advance.... more >>
DSN or DSNless connection?
Posted by Vlad at 3/4/2004 4:37:04 PM
I'm starting to move my VB6 application from Access to SQL Server. In the
beginning I'm going to use Access database with tables linked to SQL Server
tables. Then form by form are going to be moved to direct SQL Server
connection. When all of them are moved I delete Access. I have very weak
expe... more >>
configuring sql 6.5
Posted by Darius at 3/4/2004 3:04:05 PM
**** Post for FREE via your newsreader at post.usenet.com ****
Hi,
I can't see SQL 6.5 server installed on other computer. I am trying to
connect to it using SQL 2000, ODBC, ADO and none of this is helping. I
haven't experienced the same problems with SQL2000 installation. I have
installed ... more >>
Upsizing Access 2000 to SQL Server 2000
Posted by Shamim at 3/4/2004 2:56:42 PM
Hello,
I am new to SQL Server. I am trying to use the Database
upsizing wizard to upsize a Access 2000 database into SQL
Server 2000. They are both on the same machine (running
Win 03 Server). I cannot connect to the SQL Server. Error
as below:
Connection failed:
SQLState: '01000'
SQL ... more >>
Setting up pass through authentication for two SQL servers in non-trusted domains.
Posted by Joe Mine at 3/4/2004 11:23:57 AM
Hi, how do I configure pass through authentication for two SQL Servers in
non-trusted domains for replication(to access the initial snapshot folder on
the Distributor). If the subsciber is in the NARC domain and the
Distributor/Publisher is in the HOT domain. How do I create a passthrough
accou... more >>
Connecting from sql 2000 to sql 6.5
Posted by Darius at 3/4/2004 11:09:45 AM
**** Post for FREE via your newsreader at post.usenet.com ****
Hello.
I have two computers: one runing on SQL 6.5, other runing on SQL 2000. I
want to connect to SQL 6.5 server from computer running on SQL 2000, but I
can't see server runing on SQL 6.5. My SQL 6.5 is with sp5. How can I solv... more >>
Connecting to MySQL database
Posted by Dale Fye at 3/4/2004 10:51:06 AM
Anyone know how to connect to a MySQL database? I'd like to be able to just link to it or import several hundred Gig from this database into SQL Server 2K
Any ideas?... more >>
SQL 2000 and Active directory
Posted by Xignals at 3/4/2004 8:43:36 AM
Would upgrading to Active directory from a NT4 domain slow down SQL
Server communications to machines on the local network?
Are there any changes that need to be made to the SQL server to speed
up network access?... more >>
olap cube access problem
Posted by ha ha at 3/4/2004 5:46:18 AM
I just create a new olap cube from sql2000 and migrate an old cube from sql 7.0. I just create an vitual cube from sql2000
The user cannot access to the cube from the IIS
... more >>
Connecting to MS SQL from Linux?
Posted by george d lake at 3/3/2004 3:24:04 PM
Can this be done? and if so, where can I see some code?
... more >>
Active Directory Upgrade and SQL
Posted by Xignals at 3/3/2004 2:59:38 PM
Would upgrading to Active Directory from a NT4 domain have any effect
on SQL Server 2000 SP3a?
After our upgrade we started having connectivity issues with another
server that it pulls data from over the internet going through ISA
Server 2000. The AD upgrade was done on Sunday and the problem... more >>
Remote SQL Access Through ISA (SBS 2003)
Posted by anonymous NO[at]SPAM discussions.microsoft.com at 3/3/2004 11:48:18 AM
Hi All:
Our Software vendor needs to log on to SQL Server (we
have SBS 2003 Premium Edition)through ISA server. I have
followed microsoft direction and have opened port 1433.
He still cannot log on. He can log on through terminal
services but has no access to sql server. I have tried my ... more >>
Shutting down SQL
Posted by RichK at 3/3/2004 11:37:55 AM
Hello All,
I need to shutdown SQL for my Back-ups using Backup Exec. I used to have the
Tape drive and Backup exec along with SQL on one server but since we
upgraded to Win2000 I had to install the Backup and tape drive on one server
while SQL is on another.
My question is.....How can I shu... more >>
ole server login dialog box
Posted by Laura at 3/3/2004 11:34:27 AM
I am trying to connect to sql server 2000 from a windows
95 machine and windows 98. Both give me the same problem.
There is no server listing in the login dialog box and it
won't allow me to type it in. The error is unable to
connect to data source.
The workaround is to code it in the regis... more >>
Login failed for user '(null)'...Reasons?
Posted by JRE at 3/3/2004 10:27:44 AM
A SQL Server (in another domain) I'm trying to connect to with SQL Server
authentication (UID and password) fails from an Access application. I've
tried a ODBC DSN and a DSN-less connection. The SQL Server is running in
mixed authentication mode.
I can get to the SQL Server with Enterprise Man... more >>
how to configure connection pooling
Posted by Lance at 3/3/2004 10:02:11 AM
Hi,
Is there a way to control the connection pools using SQL Server 2000? I
know how to alter the connection string to do
this(http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguid
e/html/cpconconnectionpoolingforsqlservernetdataprovider.asp), but I am
looking for a setting i... more >>
Problems coneccting to BDE administrator
Posted by Elsa at 3/2/2004 9:16:07 AM
The sql server and bde administrator are in the same pc. I
am not in network when I want to get connecting althought
BDE it is not possible.... more >>
Stored procedure;1
Posted by warway at 3/1/2004 6:13:37 PM
Can anyone tell me what ;1 means after a stored procedure name. It is only
visible from some PCs in our network And they cannot run the stored
procedures
TIA
Warway
... more >>
can't connect with OLEDB, but ODBC works
Posted by Dean at 3/1/2004 6:11:33 PM
I have a local database that I'm having trouble selecting as a source in
DTS. I can connect just fine using "mymachinename", but if I try to use
(local) or an alias in Client Network Utility, I get the error:
Error Source : Microsoft OLE DB Provider for SQL Server
Error Description : [DB... more >>
Change of data source from SQL to Oracle, Unix in DTS packets will there be problems?
Posted by Larsw at 3/1/2004 3:29:15 PM
Hi,
I wonder if I can develop my DTS packets using an SQL server as data
source and then later change to an Oracle database on UNIX?
Will there be any problems?
Best regards Lars-Åke
... more >>
Pushing data from Excel to a SQL server
Posted by Christian Davidsson at 3/1/2004 12:26:18 PM
Hello,
Is it possible to feed a SQL server with data from an Excel sheet? If so -
how?
Thanks in advance,
Christian Davidsson
... more >>
Unknown token received from SQL Server
Posted by Sonia at 3/1/2004 10:38:40 AM
"Unknown token received from SQL Server" , I get this
message when I run a process on the SQL 7 Database. Can
anyone help? ... more >>
newbie can't connect
Posted by Karl at 3/1/2004 9:07:55 AM
Windows XP pro, SQL Server 2000 developers edition installed on the =
client computer.
Installed SQL Server using all defaults except changed detination drive =
and folders to D:
Now the server does not run. I get the following error:
SQL Server registration failed....
SQL Server does no... more >>
|