Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Problems with oledb connection

Author  Topic 

filf
Yak Posting Veteran

67 Posts

Posted - 2001-08-28 : 07:32:23
Currently using sql Server 7.0, ado ver 2.1.
I am experiencing a problem connecting to a dB using the oledb provider.
Whenever i try and use input parameters with an sp it bugs out, I have run a no. of tests, if I just pull a rec-set via an sp then it is no problem. If I change to a system dsn then the inserts and updates work with input parameters, so I don't think this is a permissions thing. Are there any known issues with connecting to a db via an oledblayer.

I am scratching my head with this one, as always any help/advice is thankfully recieved. FILF


   

- Advertisement -