Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Tying to move from ODBC to OLEDB
31 views
Skip to first unread message
Connie
Aug 5, 2011, 7:59:22 PM8/5/11
to
I have a couple applications in PB 10 that were using ODBC for the
connection string. I am wanting to move these to OLEDB. Most
everything works, except for datawindows built off stored procedures.
THey either give an error message saying the parameter is not found,
or they just do not return any data.
connection string. I am wanting to move these to OLEDB. Most
everything works, except for datawindows built off stored procedures.
THey either give an error message saying the parameter is not found,
or they just do not return any data.
I have added SET NOCOUNT ON
SET ANSI_WARNINGS OFF to the stored procedures.
My connection string when I run the application looks like this.
PROVIDER='SQLOLEDB',DATASOURCE='SERVER',PROVIDERSTRING='DATABASE=DBName,OJSyntax='ANSI',CallEscape='No',StaticBind=0,DisableBind=1,PBTrimCatCharColumns='Yes',PBTrimCharColumns='Yes',StripParmNames='Yes'
bruce.a...@yahoo.com
Aug 10, 2011, 10:19:10 AM8/10/11
to
This group is no longer active on the Sybase server. In addition, the feed between Google and the Sybase server is not currently working. If you post
through Goolge the post will never show up on the Sybase server, and most
people who answer questions in that group will never see it.
Instead, you may want to access the Sybase newsgroups directly at:
through Goolge the post will never show up on the Sybase server, and most
people who answer questions in that group will never see it.
Instead, you may want to access the Sybase newsgroups directly at:
http://www.sybase.com/detail_list?id=11507&pageNum=1&multi=true&show=1248
0 new messages