Are there any standard things to check for when using SQLServer with JDBC and tomcat/java servlets? We have an application with an unreasonably...

hide.me@nowhere.com

03-21-2005 02:09 AM
alin@earthling.net

Hi. I'm trying to install SQL Server 2005 EE on my computer working under Windows 2003 Enterprise Edition. During the installation i'm configuring...

blondin

03-21-2005 01:35 AM
blondin

Just wanted to share a solution I found to this common problem that I have not yet seen posted. I am in the process of migrating an application from...

greg_s_007@yahoo.com

03-20-2005 04:14 PM
greg_s_007@yahoo.com

I have been trying to connect to MSDE in a Speech server app. I have run the app w/o the connection string and the program loads and runs fine. When...

PickwickBob

03-20-2005 02:23 PM
PickwickBob

Situation: We have some custom code running on microsoft great plains **under terminal services** on a windows 2003 machine. We have a program...

svallarian

03-20-2005 10:33 AM
John Bell

I'm using sql server 2000 in Delphi. I have no any problem on my connection string in local network. But, I can not make remote connect with this...

Cogo

03-20-2005 10:27 AM
John Bell

Database: SQL Server 2000 Developer Edition SP3a Frontend: MS Access 2000 and Access 2003 A Custm-built Medical Records Database I am having a...

desimaj

03-20-2005 10:18 AM
John Bell

HI , My application is working fine with SQL Server 2000 ; but when I change the back end to Oracle 9i it gives an error...

ghosh.sujay@gmail.com

03-20-2005 10:06 AM
John Bell

I am using a VB6 frontend to a SQL server 2000 backend. What is good coding and development practice with regards to when to open/close any...

David Oberer via SQLMonster.com

03-20-2005 10:02 AM
John Bell

How does a File DSN locate the server specified in the file? I am trying to find out if it used DNS or WINS. As I am hoping it is DNS as I can then...

Russell

03-20-2005 09:46 AM
John Bell

Working on MsSQL server I'm calling remote procedure on linked server (Sybase). like this exec BILLING.billing.adm.test MsSQL returns: Server: Msg...

Viacheslav

03-18-2005 10:15 AM
Viacheslav

Hi everybody, I'm a newbe on SQL Server; Here my problem is: In Server Explorer I create a Data Connection to Nortwind. After Creating the...

Arif Çimen

03-18-2005 09:40 AM
Gary Whitley [MSFT]

Hi all, heres my problem. I have written a C# ASP.NET app that uses SQL Server, everything works fine locally. To simulate a remote connection to...

nick

03-17-2005 01:41 PM
Vikram Vamshi

Hello, I am new to SQL and I would like to connect to a remote sql server. I have Win 2k Professional installed at my PC and I have installation CD...

Marcello

03-17-2005 01:20 PM
Vikram Vamshi

I've set up an alias for my laptop-clone of the production server with the same name as that server (since I work disconnected most often). This has...

Brian Link

03-17-2005 01:07 PM
Vikram Vamshi

Data source name not found and no default driver specified This is the error I get when attempting to install my copy of SQL Server 2000 developer...

Stephen Costanzo

03-16-2005 11:22 PM
IS

how can i connect sql server with ASP vbscript? thanks

dora

03-16-2005 05:43 PM
Jim McDonald

Hello, I'm trying to import a table from a MSDE database (databaseB) into a SQL server database (database A). Using to following sql...

Eric Spijk

03-16-2005 02:20 AM
Eric Spijk

I can't use Enterprise Manager - I've got a cable connection and Comcast blocks port 1061 which EM uses. Anyone know a browser-based alternative to...

Victor

03-15-2005 07:52 PM
Sue Hoegemeier

Hi, I am using SQL Server 2000 on Windows 2000 server. Here is my problem: @String = 'word1word2word3word4word5' - This value is passed to...

Vanessa Lee

03-15-2005 01:05 PM
Cathy Boehm

Hi, Can anyone help us in letting us know that while inserting records through VB to SQL server it takes very long time even to insert very few KB...

Sanjay Jajoo

03-15-2005 12:53 PM
Cathy Boehm

Hi: I am getting this error when the .asp page tries to connect to the DB server. Microsoft OLE DB Provider for ODBC Drivers error...

Mitul Z.

03-15-2005 08:17 AM
Gary Whitley [MSFT]

Plesae excuse if I make any howlers here, I am on the steep part of the curve. I have created a link in SQL to an AS400 but cannot create a view to...

Joss

03-15-2005 03:15 AM
Joss

Is there a way to create the login id after the database backup with users was restored into this new SQL Server. The problem is that I am trying...

Cathy Boehm

03-14-2005 07:47 PM
Derrick Leggett

I have a Windows Server 2003 Standard that I have installed MSDE with SP3a on. This server is running only as a file server on a workgroup, no...

Matt Soukup

03-14-2005 04:31 PM
Jacco Schalkwijk

We are running a 16-Bit application (I know, but we HAVE to run it). Last night, the SQL Server was rebooted, and since then no-one can connect to...

Brian Taylor

03-14-2005 04:31 PM
Gary Whitley [MSFT]

Hello, I need help :-)) We use an SQL 2000 Server. in the Systemmanager one Prozess with PID is sleeping, no databese context, and I can not cancel...

matthias

03-14-2005 03:18 AM
matthias

Hello, I have sql server 2000 on a XP/SP2 machine.. with XP firewall active. But I cannot connect to sql server. I receive this message "Unable...

.:alex:.

03-13-2005 05:22 PM
Sue Hoegemeier

Steen, Thank you, but it fails with the same message when using an UNC like disk='\\Peter\C\backups\dottietest.bak', instead of disk...

PKuhne

03-13-2005 01:36 PM
Derrick Leggett

I have a stored procedure that is executed periodically by a SQL Agent job. Normally the job takes 3-5 seconds to run. But every few weeks it...

Eric G

03-11-2005 09:55 AM
Eric G

Hi, I installed the .Net Application on emulator and while opening the connection it's throwing exception: Native Error-25035. I wrote fallowing...

Chandra Prakash via SQLMonster.com

03-09-2005 03:07 AM
Chandra Prakash via SQLMonster.com

We are having one client PC running Win XP. SQL Server has been set to Windows Authentication, TCP/IP 1433, Windows 2003 (!). Via Cisco VPN we are...

Jeroen

03-05-2005 08:27 AM
Jeroen

Hi everybody, I have a problem in SQL Server 2000. I need to connect as a linked server the AS400 database (V5R3). I read in the SQL documentation...

Francesco Trigiante

03-04-2005 07:37 PM
Sue Hoegemeier

When I try to connect to SQL Server with windows NT authentication using the network login ID from my machine (Win XP) it gives me SQL Server...

Dejan Ivkoviæ

03-04-2005 07:15 PM
Sue Hoegemeier

I created a linked server in SQL server in order to connect another SQL Sever. I used the domain window account. I put my domain ID in Local...

Do Park via SQLMonster.com

03-04-2005 08:55 AM
Do Park via SQLMonster.com

I'm not the SQL admin, but I'm trying to help fix a problem. Here's the situation: Microsoft SQL Server running Windows 2000 Server. Workstation...

Terry Olsen

03-04-2005 04:43 AM
Mike Epprecht (SQL MVP)

I work for DataDirect-Technologies. My customer is using our Connect for ODBC 5.00.0059 driver on Solaris 8 to connect to SQL Server 7 on Win 2000....

Pat Frost

03-03-2005 03:45 PM
Pat Frost

I am attempting to shrink a datafile (I have 2 primary data files) when I receive this error message 'Error 8985 cannot locate file xxx in...

andy williams via SQLMonster.com

03-02-2005 08:10 PM
Sue Hoegemeier

What is the propery syntax to establish a connection with a named instance of MSDE on a server from a client workstation using the SQL Query...

astro

03-02-2005 05:11 PM
Mike Epprecht \(SQL MVP\)

i have one database with sql server i want with asp vbsript to connect with database my code is <% Dim conn Set conn =...

dora

03-02-2005 06:56 AM
Sue Hoegemeier

I am having trouble connecting to my local sql server from either the Server Explorer or vb.net code. The problem is connected to the Norton...

Mark Lewis

03-01-2005 09:01 AM
Mark Lewis

Hi, I have a problem... Supposed that in a store procedure, I have two operation for example: insert into mytable field1,field2 values...

Ste

03-01-2005 07:26 AM
Ste

Please help. On my default instance of SQL Server 2000, which could be accessed OK with both Windows and SQL server authentication, I now get the...

PeterK

02-28-2005 04:01 PM
Kevin McDonnell [MSFT]

I have what I see from this forum and other places is a common symptom: "SQL Server does not exist or access denied". I have tried every approach I...

J. R. Tessier

02-28-2005 09:18 AM
Vikram Vamshi

Hi, I'm new to SQL and would like to connect to a remote sql server where a website is hosted and do some updates. I have a local sqlserver setup...

shan

02-28-2005 09:05 AM
Steve Thompson

Hi Thi sis probably another dumb question, but any advice would be great. I have an SQL db under a website that I have to get to with an Access...

Jim McDonald

02-28-2005 08:00 AM
Steve Thompson

Quisiera saber si alguien sabe como atachar de una forma facil bases de datos en SQL sin neceidad deter enterprise ni el query analizer Gracias por...

Oswaldo

02-25-2005 10:31 AM
Oswaldo

We have recently upgraded to SQL Server 2000 and Server 2003. We're running with TCP/IP and can access the db but the connection appears to then...

Rod at MHC

02-25-2005 05:35 AM
DiP

I am running a Windows Server 2003 machine as my web server. I would like to use Windows authentication for connections to my SQL Server 2000...

mcollier

02-24-2005 12:11 PM
Vikram Vamshi

Hi, Can anyone help - I've got an Access 2002 Database which links to our SQL Server 2000 Database via an ODBC connection. The connection is set to...

Hoja, Michael

02-24-2005 06:26 AM
Hoja, Michael