PostgreSQL

wkstn: Win XP
SQL Server 2000(local, on wkstn)
I'm trying to connect to a PostgreSQL(on RedHat linux
server) database using the latest PostgreSQL ODBC driver
(07.03.0200) (trying)within SQL server via Import wizard
and DTS package...I keep getting this error: "Multiple-
step OLE DB operation generated errors. Check each OLE DB
status value, if available. No work was done." I searched
Knowledge Base and received info, but none that addressed
this specific issue. I am able to connect through MS
Access 2002.
Any suggestions?Mike,
Try connecting to PostgreSQL from a different tool such as WinSQL just
to make sure there is no problem with the ODBC driver.
Pete
MikeM wrote:

quote:

---

>wkstn: Win XP
>SQL Server 2000(local, on wkstn)
>I'm trying to connect to a PostgreSQL(on RedHat linux
>server) database using the latest PostgreSQL ODBC driver
>(07.03.0200) (trying)within SQL server via Import wizard
>and DTS package...I keep getting this error: "Multiple-
>step OLE DB operation generated errors. Check each OLE DB
>status value, if available. No work was done." I searched
>Knowledge Base and received info, but none that addressed
>this specific issue. I am able to connect through MS
>Access 2002.
>Any suggestions?
>

---

You don't pay to get spam, why pay to clean it?
Visit http://www.spammarshall.com to create an account for free
<http://www.spammarshall.com>

POST SP3 Problems

Fresh install of Win2K Server with all the latest Services Packs and Patches.

Fresh Install of SQL Servers 2000

Everything works OK

Install SP3

SQL Services Manager runs for 1 second and closes

Running New SQL Server Registration Wizard in Enterprise Manger, after hitting Next on the first screen Enterprise Manager goes poof and closes

DR. Watson Error:

Event Type: Information
Event Source: DrWatson
Event Category: None
Event ID: 4097
Date: 2/14/2003
Time: 8:38:37 AM
User: N/A
Computer: CRUISE03
Description:
The application, mmc.exe, generated an application error The error occurred on 02/14/2003 @. 08:38:37.458 The exception generated was c0000005 at address 780011CD (wcslen)

Has anyone else experienced this error, or know how I can correct it?I have experienced a different error (possibly related)

Windows 2K box
SQL 2K sp2

Add SQL SP3

SQL Server process crashes on any extended stored procedure execution. Some DBCC commands (checkdb but not showcontig) also crash the server process.

I talked to Microsoft about it, and it seems that there is one MDAC hotfix that will report a successful installation no matter what. Out of 4 machines, I only had one go bad, but I still have 30 to go...

The fix in my case was as follows:
1) run C:\SQL2KSP3\x86\other\sqlredis.exe /t:C:\Extract /c

2) run C:\Extract\mdac_qfe.exe
2a) reboot.
3) Re-run SQL SP3 setup

It fixed my particular problem, but I don't know if it will do anything to yours. Can you run extended stored procs in Query Analyzer?
~Matt|||Unfortunately this fix didn't work for me.

I don't having any stored procedures to test, this is a very simple setup for my new web server.