473,375 Members | 1,318 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,375 software developers and data experts.

Vo2Ado/MSDE Create Index problem

Hi,
i'm having a problem to create indexes.

STEP 1
-----------
Connection is OK (you can find the string at the end of the message)

Table ("Couleurs") creation is OK

STEP 2. Index Creation
---------------------------------
I'm trying to create an index on this table BUT the following code
does NOT work and my app does NOT return an error
1)
oConn:Execute("CREATE INDEX Appelations ON Couleurs
(COLORNAME)",adExecuteNoRecords,adCmdText)

or
2)
oCmd := AdoCommand{}
oCmd:ActiveConnection := SELF:oConn
oCmd:CommandText := "CREATE INDEX Appelations ON
Couleurs (COLORNAME)"
oCmd:CommandType := adCmdText
cbErr := ErrorBlock({|oErr|_Break(oErr)})
BEGIN SEQUENCE
oRs:= oCmd:Execute(NIL,NIL,NIL)
RECOVER USING uVOError
END
ErrorBlock(cbErr)

STEP 3 : a look at the results in the AdoCatalog
--------------------------------------------------------------------
Via Vo2Ado example "Explorer ADOX", i can see some index information.

The name of the index ("Appelations") is shown.
The column ("ColorName") is also shown...

There is an AdoIndex object but when i have a look at the properties
(Clustered,Primary Key,Unique and Fil Factor), the listview "Value"
column returns .........."The index does not exist"...

How can i solve this problem ?

Thank you
Guy Deprez, Belgium
----------------------------------------------
Connection String:
Provider=SQLOLEDB.1;
Integrated Security=SSPI;
Persist Security Info=False;
Initial Catalog=archdat;
Data Source=XP-MY094GEYUFG3\BcaSoftware;
Use Procedure for Prepare=1;
Auto Translate=True;
Packet Size=4096;
Workstation ID=XP-MY094GEYUFG3;
Use Encryption for Data=False;
Tag with column collation when possible=False
Properties :
Current Catalog : archdat
Multiple Connections : .T.
Reset Datasource : NIL
Enable Fastload : .F.
Active Sessions : 0
Alter Column Support : 501
Asynchable Abort : .F.
Asynchable Commit : .F.
Pass By Ref Accessors : .T.
Catalog Location : 1
Catalog Term : base de données
Catalog Usage : 15
Column Definition : 1
NULL Concatenation Behavior : 1
Connection Status : 1
Data Source Name : XP-MY094GEYUFG3\BcaSoftware
Read-Only Data Source : .F.
DBMS Name : Microsoft SQL Server
DBMS Version : 08.00.0760
Data Source Object Threading Model : 1
GROUP BY Support : 4
Heterogeneous Table Support : 3
Identifier Case Sensitivity : 8
Maximum Index Size : 900
Maximum Open Chapters : 0
Maximum Row Size : 8060
Maximum Row Size Includes BLOB : .F.
Maximum Tables in SELECT : 256
Multiple Parameter Sets : .T.
Multiple Results : 1
Multiple Storage Objects : .F.
Multi-Table Update : .F.
NULL Collation Order : 4
OLE Object Support : 33
Open Rowset Support : 8
ORDER BY Columns in Select List : .F.
Output Parameter Availability : 4
Persistent ID Type : 1
Prepare Abort Behavior : 2
Prepare Commit Behavior : 2
Procedure Term : procédure stockée
Provider Name : sqloledb.dll
Provider Friendly Name : Microsoft OLE DB Provider for SQL Server
OLE DB Version : 02.70
Provider Version : 08.10.9031
Quoted Identifier Sensitivity : 8
Rowset Conversions on Command : .T.
Schema Term : propriétaire
Schema Usage : 15
Server Name : XP-MY094GEYUFG3\BCASOFTWARE
SQL Support : 283
Structured Storage : 1
Subquery Support : 31
Transaction DDL : 8
Isolation Levels : 1118464
Isolation Retention : 0
Table Statistics Support : 3
Table Term : table
User Name : dbo
Unicode Locale Id : 0
Unicode Comparision Style : 0
Column Level Collation Support : .T.
Character Set Name : NIL
Sort Order Name : NIL
Current Collation Name : French_CI_AS
Integrated Security : SSPI
Password : NIL
Persist Security Info : .F.
User ID : NIL
Initial Catalog : archdat
Data Source : XP-MY094GEYUFG3\BcaSoftware
Window Handle : NIL
Locale Identifier : 1036
Prompt : 4
Extended Properties : NIL
Connect Timeout : 15
General Timeout : 0
Current Language : NIL
Network Address : NIL
Network Library : NIL
Use Procedure for Prepare : 1
Auto Translate : .T.
Packet Size : 4096
Application Name : NIL
Workstation ID : XP-MY094GEYUFG3
Initial File Name : NIL
Use Encryption for Data : .F.
Replication server name connect option : NIL
Tag with column collation when possible : .F.
Autocommit Isolation Levels : 4096
Quoted Catalog Names : .F.
Allow Native Variant : .F.
SQLXML Version : SQLXMLX
Jul 20 '05 #1
0 2787

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: izzy | last post by:
I was wondering if any of you guys can kindly help me in finding all the different versions of MSDE 2000 that came out since it's first release. I expected to find something similar like Sun's...
5
by: Igor Solodovnikov | last post by:
Hi. I am trying to automatically backup transaction log when error 9002 happened. So i have created appropriate job and alert to catch this error. I have two instances of sql server under Windows...
3
by: *no spam* | last post by:
I want to move my Access 2K database into MSDE. The Access Upsizing Wizard crashes (a known bug wi A2K), so I'm using the following suggested method: Access --> New --> Project (Existing...
1
by: DB developer | last post by:
Hello friends I am trying to create a deployment project to distribute my VB.NET application with MSDE database. I am using VS.NET with MSDE 2000 deployment toolkit (release candidate) to achieve...
1
by: Danny Liberty | last post by:
Hi, I am writing an application that uses MSDE to store data. Both application & MSDE run on the same computer. I want to regulate the operations done on the DB by the user. For example, I...
0
by: Lou Arnold | last post by:
Why isn't a database created on the MSDE?? Network: Two Win2K Pro machines connected as peers. (No domains.) MS Access is on X, MSDE2000A is on H. MS Access is run under: Windows...
3
by: Paul Aspinall | last post by:
Hi I want to package my C# winforms app, to be deployed with MSDE, as easily as possible for the end user. I want to create an MSI or Installshield (prefer MSI), to setup my C# app, together...
2
by: SenthilVel | last post by:
Hi i have radio buttons in my Page and i am able to see some starnge behaviour with those. 1st : DSN 2nd radio button: MSDE the above 2 are in collection.
9
by: HC | last post by:
Hello, all, I started out thinking my problems were elsewhere but as I have worked through this I have isolated my problem, currently, as a difference between MSDE and SQL Express 2005 (I'll just...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.