SQL Server ODBC Optimization Tips (12/8/2004)
SQL Server ODBC Optimization Tips
Install the latest SQL Server ODBC drivers. Because new SQL Server ODBC drivers can provide better performance and resolve some problems, ensure that you use th...
[Msg]: RE: [sswug:sql2k] Script to create ODBC DSN (9/10/2002)
Thanks for the replies. I am going to create a file odbc dsn and copy it to
the client machine. I found a dao method, DBEngine.RegisterDatabase, but
was hesitant to use it because it was on a list...
[Msg]: RE: [sswug:sql2k] Script to create ODBC DSN (9/10/2002)
John,
I'm trying to do a related thing - set up a batch file that allows the
DSN to be set to different database instances from the same application.
So a developer can run the batch file and ...
[Msg]: RE: [sswug:sql2k] Script to create ODBC DSN (9/10/2002)
Not sure from an application standpoint. I am using excel to access the dsn
and the file dsn shows up in the list of dsn's. I would assume that the
file dsn should be unique from any user of syste...
ErrorLogs (10/5/2005)
3 question
------------------------------------------------------------------
First question
I have 3 jobs scheduled in maintenance plan.
1. Optimizations (DBCC ) - every sunday at 12:00am
2....
[Msg]: RE: [sswug:sql2k] Script to create ODBC DSN (9/10/2002)
Ignoring the file dsn as I have not done this before, all it takes to create
a DSN is
a little registry magic...
Take a look at HKEY_LOCAL_MACHINE\Software\ODBC. This is where the
ODBC Connecti...
[Msg]: RE: [sswug:sql2k] Script to create ODBC DSN (9/10/2002)
File DSN is simply a file with a list of ODBC 'attribute = value' pairs, each on a separate line. You can create a file DSN and open that file to verify.
I could use Perl's Win32::ODBC module to e...
[Msg]: Database Corruption (10/27/2004)
Any suggestion on how to troubleshoot the cause for this one?
SQL 2000 EE sp3a running on a W2K3 cluster.
Everything seems to be OK now, but I need to find a root cause.
Looks like somethi...
Troubleshooting error 17803 (3/7/2007)
Troubleshooting error 17803
The error 17803 occurs when SQL Server cannot perform some operation because there is no memory available to perform this operation. This is the error message text: "I...
[Msg]: [sswug:sql2k] Need checkdb error help (7/23/2002)
I'm not having much luck finding anything meaningful on this error in
BOL or the Knowledge Base, so I thought I'd try here. The output of the
dbcc command is copied below. Can anyone shed any ligh...
[Msg]: RE: Database Corruption (10/27/2004)
Just to be clear, since you used the repair_allow_data_loss option you
HAVE lost data and it is impossible to tell how much. Restoring from a
known good backup is generally recommended over losing a...