Ole DB Source Build Query Issue

[klewis10367]

When I try to use the Build Query option within the OLE DB Source i Continually get

Object reference not set to an instance of an object

The error header is Microsoft Visual Studio.

I am attempting to query a SQL 2000 database, but it ultimately I have not been able to get any source to work. I get this error on Windows XP and Windows 2003 OS's. Any ideas would be great . I am up to date with all service packs for SQl 2005.

 

[mrdenny]

Sounds like you haven't set the connection on the query object before trying to build the query.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[klewis10367]

The connection has been set. I can connect to the database if i use the table view option.

 

[klewis10367]

It turns out I get this error only on my Windows XP machine and not the Windows 2003 Server. Probably permissions issue, but I have no idea.