I'm using PB 6.0 and SQL Server 6.5,
I would like to know why the column Name in My DW are case sensitive ?
When i open a dw, PB could not reconstruct graphical, i must change
the name of my column :
employe.name -> employe.NAME
Is someone who can help me, it's urgent
Yes i'm agree, but how to do it without reinstall the server ?
My customer has 15 Dababase on this server, and i can't change it for all
Peter <email@example.com> a �crit dans le message :
GS81jaPe#...Why does a simple select query in Microsoft Access return the error [Intersolv][ODBC SQL Server Driver][SQL Server]ct_results(): user api layer: internal client library error: Read from the server has
I have applied the information from support document
10447954 but that does not solve the problem. I am running
a simple select query with one criteria from one table.
...Why does a simple select query in MS Access return the error: [Intersolv][ODBC SQL Server Driver][SQL Server]ct_results(): user api layer: internal client library error: Read from the server has timed
I have applied the information contained in support document
10447954. That did not resolve the problem. I am running a
simple query with one criteria and one table
The doc refers to a different ODBC driver (for DirectConnect product) so
have a completely different problem.
The message implies you are using ODBC 12.0 (Client Library based) or
since the message indicates CtLib info. You might want to post more
involved with getting to this error.
You also might want to post exact versions of ASE and ODBC driver,
including Open ...Delphi XE5 Enterprise FireDAC SQL Server driver not in list
Just installed Delphi XE5 Studio Enterprise. Playing with FireDAC components. When I drop a TFDConnection on my form, I am looking for the driver for Microsoft SQL Server. I do not see it in the list.
I see ADS, ASA, FB, IB, MSAcc, MySQL, ODBC, PG, SQLLite.
Is there a separate install?
This is a bug. The workaround is to drop TFDPhysMSSQLDriverLink
on a form. Then MSSQL will be accessible in the drivers list.
With best regards,
Dmitry Arefiev / FireDAC Architect
FireDAC - Firebird, SQLite, MySQL, SQL Server, Oracle, PostgreSQL,
DB2, SQL Anywhere, Access, Informi...SQL Server Identity Columns Not Returning New Identity Value with PB11
We are using Powerbuilder 11.1 and SQL Server 2005 (Enterprise)
When inserting new rows (using a Datawindow) into a table with an
identity key column, the Datawindow does not always return the newly
inserted identity value.
Any help would be appreciated!
1) What connectivity mechanism are you using?
2) Does the DW have the "Identity Column" set in its update properties?
3) What do you mean by "Not always" (it sometimes works)?
Regards ... Chris
"L Morris" <sales@...SQL Server 2000 and SQL Server 2005 in the same server
Can enyone please send me a link to a white paper explaining how to run both SQL Server 2000 and 2005 in the same machine?Thanks.
I don't know about the white paper but I had both running on my machine for a while by making the SQL 2000 a named instance. So for SQL 2005 connection strings my server name was (local) while for SQL 200 using the named instance it was (local)\joesql where joesql was the instance nameHope it helps,Joe http://www.joeaudette.comhttp://www.mojoportal.com...This version of Microsoft Sql Server Management Studio can only be used to connect to Sql Server 2000 and Sql Server 2005 servers
When I connect SQL Server 2005 to a remote database i get the error: "This version of Microsoft Sql Server Management Studio can only be used to connect to Sql Server 2000 and Sql Server 2005 servers".
Can I confirm it is because: the remote db is of SQL Server 2008?
There is a soln mentioned in http://forums.asp.net/t/1324047.aspx
Did anybody try this (installing 2008 express: http://www.microsoft.com/express/sql/download/)? I am just checking again, whether it will disturb my existing SQL Server installation, in any means...?
Though it is mentioned that it will g...SQL Server 2005 Installation problems with SQL Server Express & SQL Server 2000
I have had SQL Server Express and Sql Server Management Studio Express installed on my machine for some time and recently tried to install a trial of SQL Server 2005 as well. (Yes, I'm migrating from Visual Studio Express to Visual Studio Professional, just as in tended!)
Everything went fine except that nothing seemed to be installed. I searched in all the obvious places - both on the Start/Programs menu and on the hard-drive: nothing.
A check under Add/Remove Programs showed that Sql Server 2005 Express was installed, but called SQL Server 2005.
So after a number o...Using @column = [column] SQL Server 2000
Should the following select statement return ALL the records including the records where [district] is null? Currently it is only returning non null records. I tried it with a default value and without with the same results.
SelectCommand="SELECT [ID], [last], [first], [district], [TA] FROM [regd] Where ([district] Like case when @district is null then [district] else @district end)"
<SelectParameters ><asp:ControlParameter ControlID="Last_textbox" Name="district" defaultvalue="%" PropertyName="Text" Type="Str...how to fetch column using column index in sql server.
I have several columns in my table, but I want to fetch data using column index instead of column name in select command.
is there any way to do this.Please remember to click “Mark as Answer” on the post that helps youJasim AkhtarNew Delhi ( INDIA )
Yes there is.It's called dynamic SQL and it's a complicated process.See http://www.sommarskog.se/dynamic_sql.html Please click "Mark as Answer" if my reply solved your problem.CheersRammohan...sql server and sql server express
ok i am puzzled right now....i have a web application connecting to a sql server database....i uninstalled sql server express and installed sql server 2005 full version...i changed the connection string in my application to be
Data Source=SKYBANDR62;Initial Catalog=aspnetdb;Integrated Security=True
and through the explorer bar i can access my database freely but when i run my application i get this error
Server Error in '/' Application.
An error has occurred while establishing a...Using Linq to SQL to insert into an SQL Server XML column
I'm getting an error on this line:
' auditData.PCAuditDataXML = Xdoc.Element("Model") 'Can anyone see where I'm going wrong here?
Private Sub insertDataIntoAuditDataTable(ByVal userName As String, ByVal computerName As String, ByVal Xdoc As XDocument) Dim ADDC As AuditDataDataClassesDataContext = New AuditDataDataClassesDataContext Try Dim auditData As New AuditData_ad  ...Return vals from MS-SQL-Server stored procs in embedded SQL
how do i get the return value from executing a stored procedure declared in
a MS-SQL-Server database within Powerbuilder 5.0.04 embedded SQL statements?
the return value i want is *not* the result-set nor an output parameter --
it is the return value specified by [return xxx] within the stored proc in
any help is appreciated! thanks,
The return value is returned as the first value in the SECOND result
set. Any output args are returned, in order, after the return value in
the same (second) result set.
In embedded SQL, after you execute the ...Reuse derived columns in same SQL Select statement under SQL Server 2005
Our agency is in the process of migrating our Sybase
Adaptive Server Anywhere 7.0 databases to Microsoft SQL
Server 2005. We are currently using PowerBuilder 10.5. We
have several datawindows that reuse SQL computed fields
(derived columns) in the same SQL Select statement. Here is
(CASE WHEN coalesce(s.recommended_verbal,'N') <>
coalesce(s.final_verbal,'N') then 1 else 0 end) as c_verbal,
(CASE WHEN coalesce(s.recomme...