SEARCH RESULTS

to update clients with a new server DSN?   we are adding a new server to replace an old one, but both of them need to coexist on the network. it has fallen to me to update each client's registry w...

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...

Using Oracle Heterogeneous Services in an Operational Data Store or Data Warehouse By John Adolph Palinski I recently received a user request to bring information into the data warehouse for ...

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...

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 ...

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...

3 question ------------------------------------------------------------------ First question I have 3 jobs scheduled in maintenance plan. 1. Optimizations (DBCC ) - every sunday at 12:00am 2....

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...

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...

Abraham, Here is an example connecting to SQL via ODBC. We don't use MySQL so I could test against it. Before you open the code template page and paste the code in, be sure to add an output and...

Thanks everyone. This seems to have worked fine. HKEY_LOCAL_MACHINE\Software\ODBC\ODBC.INI (for system DSN's) HKEY_CURRENT_USER\Software\ODBC\ODBC.INI (for user DSN's) We were installing O...

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...

Thank Robert. I think it would work. But since I haven't touched any codes for more than 4 years, it will take a long time for me to figure out how to fill the CreateNewOutputRows(). I appre...

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...

OK so I found a little script that will create a system DSN for SQL Server: Dim oWshShell Set oWshShell = CreateObject ('WScript.Shell') oWshShell.RegWrite 'HKLM\Software\ODBC\ODBC.INI\Ba...

Abraham, I have not tried this so no guarantees . . . Start by creating an ODBC connection in the connection manager - select New Connection, and a list of supported connection manager types w...

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...

Accessing data distributed in SQL Server 2008 and EnterpriseDB by Jayaram Krishnaswamy Distributed queries leverage the idea of linked servers for accessing data from both homogeneous and ...

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...

Microsoft Access 2003 Linked Server on SQL Server 2008 using the JET and MSDASQL Providers For accessing geographically distributed data linked servers provides a good solution. MS SQL Servers alw...